Search found 1952 matches

by Wim Gielis
Wed Mar 20, 2019 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LEN works in Architect, not PAW
Replies: 2
Views: 28

Re: LEN works in Architect, not PAW

Hello,

You could fill up an attribute with the length of the string, probably with TI but a rule is possible too. After that you can query on the attribute. I haven’t used it in Workspace until now.
by Wim Gielis
Wed Mar 20, 2019 5:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1WEB 2.0.6 Number Issue
Replies: 7
Views: 114

Re: TM1WEB 2.0.6 Number Issue

Bakkone wrote:
Wed Mar 20, 2019 5:18 pm

I do love how this shows that IBM ships stuff without even testing on a computer with a different regional setting tho. Very nice...
That is not the first time: https://www.tm1forum.com/viewtopic.php?f=3&t=14417
by Wim Gielis
Wed Mar 20, 2019 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CubeUnload
Replies: 5
Views: 121

Re: TM1 CubeUnload

For example, you would use CubeUnload (or the equivalent in the user interface) to remove all feeders from a cube. Useful during debugging. Technical requirement: all views must be closed in Architect / Perspectives. This is not a tool for limiting RAM consumption in a TM1 model. For that, you have ...
by Wim Gielis
Mon Mar 18, 2019 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 8
Views: 880

Re: TM1 report bursting

Hello jrizk, Thank your for confirming that this isn't going to work. But... it did work in previous versions of Windows. Anyways. What are the different options I still have ? - Someone here on the forum, or within my organisation, the customer's organisation, the Internet, ... knows a way to do it...
by Wim Gielis
Mon Mar 18, 2019 1:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 8
Views: 880

Re: TM1 report bursting

Hi, If Excel identity is interactive, it's my username (wimgieli) If Excel identity is the launching user, it's the username with which the task is created (tm1burstservice) I now have the following: - everyone logged off, Excel identity set as the user wimigeli and the scheduled task running under ...
by Wim Gielis
Sat Mar 16, 2019 10:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1069

Re: Automating TM1 in VBA

Hi Paul, I think that I tested about each permutation of all the options: - users - highest privileges - 'Run whether user is logged on or not' - Task compatibility 2008/2000-2003... - Excel without vbscript before - Logged on or not - UNC paths - ... Still no joy, at now 2 different customers. But ...
by Wim Gielis
Sat Mar 16, 2019 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1069

Re: Automating TM1 in VBA

Hello Paul, I am not using a TI for now, but a scheduled task. The testing that I am currently doing in my newest topic : - If I schedule the task to run at a certain point in time, so scheduled, and I am logged on: it works fine. - If I schedule the task and I log off (and everyone else is logged o...
by Wim Gielis
Sat Mar 16, 2019 2:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 8
Views: 880

Re: TM1 report bursting

Hello Yuri Thanks. I should have added the following too: - This topic is a continuation of my earlier topic: https://www.tm1forum.com/viewtopic.php?f=3&t=14157 It's the same challenge and the same problem. Last year I thought it worked, but it does not. I forgot to update that topic, I did this now...
by Wim Gielis
Sat Mar 16, 2019 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1069

Re: Automating TM1 in VBA

Hello,

I still cannot get it to work. See for an updated topic:
https://www.tm1forum.com/viewtopic.php?f=3&t=14157

There is also a Word document including things to check and try.

Wim
by Wim Gielis
Fri Mar 15, 2019 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 8
Views: 880

Re: TM1 report bursting

Thanks, I will try to set up a variant without TI and without the vbscript part in the middle. Focus on the Excel and scheduled task part only.
by Wim Gielis
Fri Mar 15, 2019 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 8
Views: 880

TM1 report bursting

Hello all, My case is the following. I have a Perspectives report with DBRW and SUBNM and I would like to: - generate a version of the report with hard values - email the report to a number of recipients - this should be done in an automated way No manipulations need to happen in the report, only ge...
by Wim Gielis
Wed Mar 13, 2019 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List of all rules
Replies: 2
Views: 292

Re: List of all rules

In PA there are control objects for subsets and views. I mean subsets for a dimension and views for a cube. For rules you might want to look at the }StatsForRules control cube. Or just open up the .rux text files.
by Wim Gielis
Fri Mar 08, 2019 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Replies: 10
Views: 1269

Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly

I think you might be getting mixed up with ItemReject. AFAIK LogOutput should not cause any minor error status (in fact would be pretty bad if it did). I will pursue using a global variable instead of the return code... Yes because the software... will not do this, changing the return code, as was ...
by Wim Gielis
Fri Mar 08, 2019 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Replies: 10
Views: 1269

Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly

jcr55 wrote:
Fri Mar 08, 2019 2:28 pm
According to the TI manual, using the logoutput command should cause the return code to be 5, but the return code is zero. I think it's a bug. Was just trying to see if anyone else has experience with this situation.
Can you send a link please ?
by Wim Gielis
Thu Mar 07, 2019 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Replies: 10
Views: 1269

Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly

Hi, Bypassing the issue at hand for a while, why don't you use a global variable ? As in (in the calling process): NumericGlobalVariable( 'vFound' ); vFound = 0; ExecuteProcess( '...' ); If( vFound <> 0 ); # ... EndIf; and in the called process: NumericGlobalVariable( 'vFound' ); vFound = ...; Regar...
by Wim Gielis
Thu Mar 07, 2019 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 183

Re: REST API: consolidated elements without children

PavoGa wrote:
Wed Mar 06, 2019 12:16 pm
Seriously, thanks. I am going to visit your MDX page again! Good :idea:
Thanks ! Happy reading.
by Wim Gielis
Wed Mar 06, 2019 12:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 183

Re: REST API: consolidated elements without children

Hi Not sure I understand why you would not use easier functions that TM1TupleSize and Item. Straight from my MDX page: Consolidations without children: {Filter( TM1FilterByLevel( TM1SubsetAll([test]), 1), ISLEAF( [test].CurrentMember ))} {Filter( TM1FilterByLevel( TM1SubsetAll([test]), 1), [test].Cu...
by Wim Gielis
Tue Mar 05, 2019 12:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Update from TM1 9.5 to TM1 11
Replies: 3
Views: 94

Re: Update from TM1 9.5 to TM1 11

If it's Cognos Express you might need to review the security regarding clients and groups.