Search found 1089 matches

by gtonkin
Sat Jul 08, 2023 4:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Identify All References to Cube
Replies: 7
Views: 9806

Re: Identify All References to Cube

Another way is to use Debug utility 123 (all the usual exclusions and waivers apply when using undocumented features) Extracts a file with information about all cubes and dimensions So in short given the following: DebugUtility( 123, A, B, 'Model_Information_0_1.txt', '', '' ); A = 1 suppresses cont...
by gtonkin
Wed May 24, 2023 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove duplicate elements in MDX subset build
Replies: 6
Views: 1045

Re: Remove duplicate elements in MDX subset build

Lotsa's solution is far more elegant for what you are trying to achieve here.
by gtonkin
Wed May 24, 2023 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1SET function - Any trick getting it to work?
Replies: 5
Views: 973

Re: TM1SET function - Any trick getting it to work?

Hi John, iirc, my connection in PAfE used the URI to the PASS server rather than the TM1 server and HTTPPortNumber.
The PASS "pass-through" was the missing link.
by gtonkin
Wed May 24, 2023 5:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove duplicate elements in MDX subset build
Replies: 6
Views: 1045

Re: Remove duplicate elements in MDX subset build

If you are building vi TI there are any number of ways to do this. Simplest is probably to add the elements to a string and scan the string. If you are about to add an element check if it is in your string i.e. previously added. If not add otherwise skip. You could also build an MDX string - add the...
by gtonkin
Fri May 12, 2023 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turning on the performance monitor in PAW
Replies: 6
Views: 2167

Re: Turning on the performance monitor in PAW

... So which is wrong...Garbage or Cube..... If there is a process running, you would not see how much memory it is consuming with transactions in case it needs to roll back. And then don't forget that all the dims, sets etc. eat memory too - can still use the properties window in architect from th...
by gtonkin
Fri May 05, 2023 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
Replies: 7
Views: 2192

Re: 2.0.9.16 Rule save time dramatically less - Feeder calcs?

Noticed this parameter in the TM1S.CFG - may be worthwhile checking/reviewing. Default is True though. SaveFeedersOnRuleAttach When set to False, postpones writing to feeder files until SaveDataAll and CubeDataSave are called, instead of updating the files right after rules are changed and feeders a...
by gtonkin
Thu Apr 06, 2023 9:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives Active Form generating duplicate sections
Replies: 1
Views: 589

Re: Perspectives Active Form generating duplicate sections

After deleting all rows below the TM1RPTROW, have you tried removing the named range referring to the DATARNG? This should be regenerated on rebuild.
by gtonkin
Wed Apr 05, 2023 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!
Replies: 2
Views: 997

You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!

Cross-posting this topic here in case someone needs it. TL:DR Inserting the below function will allow you to append to a file when using AsciiOutput or TextOutput. Works across Prolog, Metadata, Data and Epliog as well as other TI processes: AsciiOutputOpen(<filename>,0|FILE_OPEN_APPEND|FILE_OPEN_SH...
by gtonkin
Sat Apr 01, 2023 4:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ever needed to recover a TM1 user's password when using native security i.e. mode 1?
Replies: 1
Views: 782

Ever needed to recover a TM1 user's password when using native security i.e. mode 1?

The below script uses some undocumented functions to do the decryption. These are not recognized in PAW but save and just ignore the error or use Architect. Create a new process with a string parameter called pClient then add the following to the prolog section: IF(pClient@=''); pClient=TM1User; END...
by gtonkin
Wed Mar 29, 2023 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW to Powerpoint
Replies: 4
Views: 1484

Re: PAW to Powerpoint

Know nothing about functionality etc., only that Intito offers Office Connect which may meet your requirement MarenC.
by gtonkin
Wed Mar 29, 2023 7:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Get children with Multiple Parents
Replies: 6
Views: 1454

Re: MDX Get children with Multiple Parents

Glad it helped.

I left the duplicates in as I have ideas of adding more MDX around them to show their parents in the rollup so that it is easy to track down the nonsense. A project for another day...
by gtonkin
Tue Mar 28, 2023 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Get children with Multiple Parents
Replies: 6
Views: 1454

Re: MDX Get children with Multiple Parents

Are you stalking me? Did this just yesterday to meet a requirement: Basically looking at all the elements in a rollup and counting those that appear multiple times. You could likely add your own TM1FilterByLevel where/if necessary: FILTER ( {DESCENDANTS({[<dim>].[<hier>].[<rollup>]})}, COUNT( {INTER...
by gtonkin
Mon Mar 13, 2023 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 how to copy private view from one user to another user?
Replies: 5
Views: 1069

Re: tm1 how to copy private view from one user to another user?

Consider that if you are dealing with a private view, those views may have private sets which would need to be copied along with the .vue
by gtonkin
Sun Mar 12, 2023 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to count view opening times
Replies: 2
Views: 478

Re: How to count view opening times

Maybe one of the loggers could write to a log that you could use: https://www.tm1forum.com/viewtopic.php? ... ers#p81607
by gtonkin
Sat Mar 11, 2023 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX exploration view automatic recalc?
Replies: 2
Views: 567

Re: PAX exploration view automatic recalc?

As a start, are both of you in Automatic calculation mode in Excel? PAfE works better like this whereas Perspectives was better suited to Manual.

What version of PAfE are you both using?
by gtonkin
Tue Mar 07, 2023 4:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help with a feeder
Replies: 9
Views: 1335

Re: Need Help with a feeder

If you are using PAW as the UI and assuming you are just trying to show the PLC Rate, you could use a derived Member to get the value from the underlying cube and display it in the exploration. No feeding as it is purely for display purposes.
by gtonkin
Thu Mar 02, 2023 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewSubsetAssign - what am I doing wrong?
Replies: 15
Views: 2540

Re: ViewSubsetAssign - what am I doing wrong?

Probably not going to solve your problem but one of my pet hates is random variable names. Why pDir for the new of the new hierarchy? Is this a poor convention picked up from the consultant? Why not call it what it is, pHierarchy? Same would go for all variables used. Be descriptive for the next per...
by gtonkin
Wed Mar 01, 2023 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules with virtual hierarchies
Replies: 10
Views: 1959

Re: Rules with virtual hierarchies

A little gotcha for anyone following this or reading on CellValueN.
Had an issue on a rule not workingas expected. A silly typo, but rules editor does not warn of invalid hierarchies or elements.
Best to try use the intellisense/Ctrl+space (in PAW) to avoid silly mistakes...
by gtonkin
Wed Mar 01, 2023 10:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirantis mandatory for PAW
Replies: 10
Views: 1884

Re: Mirantis mandatory for PAW

You are in for a surprise! IBM sent this out recently: https://www.ibm.com/support/pages/node/6856989?myns=swgother&mynp=OCSSCTEW&mync=E&cm_sp=swgother-_-OCSSCTEW-_-E TLDR: From end April 2023, the runtime will no longer be free, you will need to purchase a subscription to get access to ...