Search found 3017 matches

by Wim Gielis
Mon Mar 18, 2024 8:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 7
Views: 169

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

"We have a Turbo Integrator that makes a copy within the same cube. In the source cube, we selected a consolidated level, and in the target cube, we load at a fine level." Now, what is it, same cube or different cube ? Not that it makes a lot of difference, but still. If I were you, I woul...
by Wim Gielis
Mon Mar 18, 2024 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 1
Views: 65

Re: Planning Analytics workspace is down

Hello,

I do have a suggestion. Why don't you use a recent version of the software (and related OS) ?
You are now on software that is almist 4 years old. In PAW and PA-land this is quite a big gap.

2.0.9.2 is from July 2020.
by Wim Gielis
Mon Mar 18, 2024 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 7
Views: 169

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

Version 11.8.00800.5 ?

That is 2.0.9.9 from July 2021 and 3 years old.
Plenty of changes and fixes in the meantime. I would try upgrading first.
I also had issues with RunProcess and only in 2.0.9.19 it seemed solved.
by Wim Gielis
Mon Mar 18, 2024 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 7
Views: 169

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

That's not the full picture. You need the version of PA, not (necessarily) the version of PAW.
2.0.9 something probably
by Wim Gielis
Mon Mar 18, 2024 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 7
Views: 169

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

Difficult to say with this information but I know that efforts were made regarding RunProcesses in the latest versions.
What version are you using for the PA server ?
by Wim Gielis
Mon Mar 18, 2024 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Delete table error with MS SQL2019
Replies: 7
Views: 190

Re: ODBCOutput Delete table error with MS SQL2019

Hello, I did not mean a production environment, but a testing environment would have been good too. Nice to see that there is a solution. Just note that ExecuteCommand will not be available anymore in the next major version of PA (that being said, changes to ODBC could come too but that's a differen...
by Wim Gielis
Mon Mar 18, 2024 7:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Delete table error with MS SQL2019
Replies: 7
Views: 190

Re: ODBCOutput Delete table error with MS SQL2019

Hello,

Do you have an environment with the latest version of PA ?
by Wim Gielis
Fri Mar 15, 2024 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Moving data from cube with different dimension
Replies: 5
Views: 216

Re: Moving data from cube with different dimension

2 people who do not reply anymore because no one wrote down all the code they needed ? 🤔
by Wim Gielis
Mon Mar 11, 2024 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding two if loops to a statement
Replies: 4
Views: 672

Re: Adding two if loops to a statement

ardi wrote: Mon Mar 11, 2024 1:31 pm lol: I was thinking exactly the same. Impossible to follow the question with these object names
100% !
by Wim Gielis
Fri Mar 08, 2024 5:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Conditional Pick Lists
Replies: 3
Views: 149

Re: Conditional Pick Lists

Hi Wim, Thank you for this. It really helped me to understand more about using picklist control cubes. I've wrote this rule for one of my picklists: ['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function...
by Wim Gielis
Thu Mar 07, 2024 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Conditional Pick Lists
Replies: 3
Views: 149

Re: Conditional Pick Lists

Hello

Did you try Google on:
TM1 dependent picklists
by Wim Gielis
Wed Mar 06, 2024 5:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding two if loops to a statement
Replies: 4
Views: 672

Re: Adding two if loops to a statement

Hello, Can I ask you why you don’t finish your words and dimension names? It seems weird to have dimension names like that. I have never seen such strange dimension names. You mentioned that you have double loops, but I don’t see any code for that. I would also like to question your cube design. Ins...
by Wim Gielis
Mon Mar 04, 2024 6:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Moving data from cube with different dimension
Replies: 5
Views: 216

Re: Moving data from cube with different dimension

Yes, but I need help with the TI code As is the case for many TI processes, the Prolog tab code contains a zero out of the target cells. Also, the Prolog tab contains the code for creating a view collecting the input cells - those that need to be allocated. After that, the Data tab contains code to...
by Wim Gielis
Sun Mar 03, 2024 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Drill process return handle
Replies: 3
Views: 173

Re: }Drill process return handle

Hello,

George Tonkin and Edward Stuart have been working on this in the past:
https://community.ibm.com/community/use ... utput-file

Does this help ?
by Wim Gielis
Fri Mar 01, 2024 6:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW mdx subset
Replies: 1
Views: 170

Re: PAW mdx subset

It’s not very clear to me but hopefully I get it right. The cube on which you have a view, doesn’t it have dimensions year / version / department ? Why would you be creating concatenations of these in another dimension ? I expect to see these 3 dimensions and the }Clients dimension and possibly a fe...
by Wim Gielis
Sun Feb 25, 2024 9:02 am
Forum: Useful code, tips and tricks
Topic: Transfer private objects from one user to another
Replies: 7
Views: 12287

Re: Transfer private objects from one user to another

Updated version.
WG_CLOUD_transfer_private_objects.pro
(22 KiB) Downloaded 18 times
TECH_folder for output.pro
(6.35 KiB) Downloaded 15 times
by Wim Gielis
Wed Feb 21, 2024 7:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ELPAR in Rule
Replies: 2
Views: 163

Re: ELPAR in Rule

Of you can turn it into a parent-child relation, why not store the parent name in a string value for the child ?
by Wim Gielis
Mon Feb 19, 2024 8:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets locked by phantom views
Replies: 9
Views: 5886

Re: Subsets locked by phantom views

That version is 2 years old, maybe it’s solved in the meantime ?
by Wim Gielis
Wed Feb 14, 2024 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Subset TI Data Source Alias
Replies: 4
Views: 726

Re: Dimension Subset TI Data Source Alias

Yes. You would retrieve the values in the Metadata and/or Data tab of the process. Or use the element attributes cube as the data source.