Search found 1099 matches
- Wed Mar 29, 2023 1:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW to Powerpoint
- Replies: 4
- Views: 1528
Re: PAW to Powerpoint
Know nothing about functionality etc., only that Intito offers Office Connect which may meet your requirement MarenC.
- 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: 1540
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...
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...
- 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: 1540
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...
- 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: 1181
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
- 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: 501
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
- Sat Mar 11, 2023 9:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX exploration view automatic recalc?
- Replies: 2
- Views: 617
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?
What version of PAfE are you both using?
- Tue Mar 07, 2023 4:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need Help with a feeder
- Replies: 9
- Views: 1414
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.
- 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: 2654
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...
- Wed Mar 01, 2023 11:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules with virtual hierarchies
- Replies: 10
- Views: 2036
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...
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...
- Wed Mar 01, 2023 10:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mirantis mandatory for PAW
- Replies: 10
- Views: 2010
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 ...
- Mon Feb 27, 2023 6:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules with virtual hierarchies
- Replies: 10
- Views: 2036
Re: Rules with virtual hierarchies
Have you looked at CellValueN?
Probably the right function to use:
https://www.ibm.com/docs/en/planning-an ... cellvaluen
Probably the right function to use:
https://www.ibm.com/docs/en/planning-an ... cellvaluen
- Sat Feb 18, 2023 12:19 pm
- Forum: Useful code, tips and tricks
- Topic: Copying a tab from one PAW book to another
- Replies: 0
- Views: 14490
Copying a tab from one PAW book to another
If you have ever needed to copy a tab from one PAW book to another, please read this article on the IBM Community. It describes how to locate the necessary source JSON and how to insert it into the target book. This obviously saves a whole lot of time needed to recreate the tab as well as reducing t...
- Fri Feb 17, 2023 2:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migration from Perspectives to PAX
- Replies: 12
- Views: 3330
Re: Migration from Perspectives to PAX
An update on this one. I got a response from Sami that DBR and DBRA are identical in PAfE (REST API world).
Documentation has also recently been updated to reflect that they are identical and both effectively WAN-optimised.
Documentation has also recently been updated to reflect that they are identical and both effectively WAN-optimised.
- Thu Feb 09, 2023 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1264
Re: Hierarchy security update require a call to SecurityRefresh Function
Think I had something similar and ended up adding this along with the HierarchyElementSecurityPut statements iirc:
Code: Select all
#--Give Access to see a particular hierarchy in the dimension
CellPutS(sElSecurity, '}DimensionSecurity', pDim | ':' | pHierarchy, sGroup);
- Wed Feb 08, 2023 6:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automatically update time dimension
- Replies: 2
- Views: 646
Re: Automatically update time dimension
A couple of things here but the main one is that your apostrophe should be after the month number and before the pipe, not after the year.
Edit: Also best to do meta data updates in meta data otherwise you may rather want to look at the Direct commands for your inserts.
Edit: Also best to do meta data updates in meta data otherwise you may rather want to look at the Direct commands for your inserts.
- Mon Feb 06, 2023 7:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - How to identify empty subset through MDX
- Replies: 4
- Views: 954
Re: MDX - How to identify empty subset through MDX
I am thinking that you may have found a use-case for TM1TupleSize!
- Mon Feb 06, 2023 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Strange behaviour of Subsets used in DBRW
- Replies: 5
- Views: 801
Re: Strange behaviour of Subsets used in DBRW
I have used M_Clear in macro code previously but has some additional erratic behaviour like suddenly having your connection close.
Hopefully someone else has a better alternative…
Hopefully someone else has a better alternative…
- Mon Feb 06, 2023 12:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Strange behaviour of Subsets used in DBRW
- Replies: 5
- Views: 801
Re: Strange behaviour of Subsets used in DBRW
What happens if you create the new sets, close Perspectives and Excel then open and connect again?
Could be a meta data sync issue where new objects are not available/recognized.
Could be a meta data sync issue where new objects are not available/recognized.
- Fri Feb 03, 2023 7:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migration from Perspectives to PAX
- Replies: 12
- Views: 3330
Re: Migration from Perspectives to PAX
... Note: Difference between DBR and DBRW in PAX: "DBRW works the same as the DBR function, with one major difference; DBRW reduces network traffic and may improve performance on wide area networks. ... https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wf-dbrw Not sure I agree with th...
- Fri Feb 03, 2023 5:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migration from Perspectives to PAX
- Replies: 12
- Views: 3330
Re: Migration from Perspectives to PAX
For my case, we wanted to avoid having users copying things around. I guess we could have also created a script that does the copy of the necessary files to the relevant folder. Still in testing so final deployment may change. In terms of your questions: 1) Best place for the add-in - we rename the ...