Search found 1949 matches

by Wim Gielis
Wed Mar 20, 2019 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CubeUnload
Replies: 5
Views: 104

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: 873

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: 873

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: 1065

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: 1065

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: 873

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: 1065

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: 873

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: 873

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: 290

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: 1261

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: 1261

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: 1261

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: 174

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: 174

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: 91

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.
by Wim Gielis
Tue Mar 05, 2019 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Update from TM1 9.5 to TM1 11
Replies: 3
Views: 91

Re: Update from TM1 9.5 to TM1 11

You can skip the versions in between.
Obviously, without more details on 'that model' we can't provide more detailed information.
by Wim Gielis
Mon Mar 04, 2019 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rebuilding Websheets Twice in One Event
Replies: 1
Views: 87

Re: Rebuilding Websheets Twice in One Event

Interesting, thanks for that.
by Wim Gielis
Sun Mar 03, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Localizing a TM1 model, part 2
Replies: 1
Views: 125

Re: Localizing a TM1 model, part 2

Update: Good news, it works in TM1 Web on my local machine, 2.0.6. See A in green. 01.png I have no PAW installed on my machine. On the remote machine where I used PAW I cannot be certain about the TM1 server version but I think it's 2.0.4. What does not seem to work in TM1 Web 2.0.6 is the localize...