Search found 3033 matches

by Wim Gielis
Sat Apr 20, 2024 4:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Methods for Inputting Data into TM1 Cube
Replies: 5
Views: 54

Re: Methods for Inputting Data into TM1 Cube

Yes, e.g. what Adam describes: in the past I wrote PowerShell to do just that.
by Wim Gielis
Thu Apr 11, 2024 5:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button - Process Failed - with No Log
Replies: 3
Views: 579

Re: Action Button - Process Failed - with No Log

TM1 Perspectives ? PAfE ? A sheet dragged on a PAW dashboard ?

The process exists ? For instance, in case the process name could be retrieved dynamically from a cell.
Process parameters are fine ?
by Wim Gielis
Thu Apr 11, 2024 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button in PAX with parameters
Replies: 1
Views: 534

Re: Action Button in PAX with parameters

Yes. There is no screen the change the parameter values or enter them.
by Wim Gielis
Wed Apr 10, 2024 6:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code: Records per Second Tracking
Replies: 1
Views: 630

Re: Code: Records per Second Tracking

Thank you Andrew, it's useful. I reworked a bit to my preferences :-) and delimiters in the numbers. Also, the choice to go really detailed until milliseconds, or not. ####################################### ##### IF NOT USING MILLISECONDS ##### ####################################### ## START of th...
by Wim Gielis
Mon Apr 08, 2024 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX analysis of what you are feeding
Replies: 10
Views: 1027

Re: MDX analysis of what you are feeding

I think that AsciiOutput is still there, but then towards folders relative to the model_upload folder.
by Wim Gielis
Mon Apr 01, 2024 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 68
Views: 8190

Re: Ultimate Long TM1 quiz

gtonkin wrote: Mon Apr 01, 2024 3:27 pmHang on, Wim - Was this you? :shock:
No. Just a TM1 REST API Impersonation of Wim.
by Wim Gielis
Mon Apr 01, 2024 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 68
Views: 8190

Re: Ultimate Long TM1 quiz

Impose your cat to go to the boss and explain what happened.
by Wim Gielis
Mon Apr 01, 2024 6:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Message to the TM1 Community
Replies: 1
Views: 865

Message to the TM1 Community

Hello all, When you enjoy working with TM1 and you can do that for a living, you should be very happy. However, getting to learn new tools can be rewarding too. I already have a number of successful Jedox projects under my belt and it always felt like I wanted to do more with it. Our time is preciou...
by Wim Gielis
Thu Mar 28, 2024 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to avoid queuing at the end of processes parallelization ?
Replies: 5
Views: 1107

Re: How to avoid queuing at the end of processes parallelization ?

Also, 2000 processes doing less work is most of the time less optimal than less processes doing more work (on average).
by Wim Gielis
Thu Mar 28, 2024 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Financial Consolidation TM1 Sample Module
Replies: 1
Views: 918

Re: Financial Consolidation TM1 Sample Module

That would definitely be useful. Maybe uploading to a Google Drive ? Or your own webspace if possible ?
by Wim Gielis
Mon Mar 25, 2024 10:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule to Propagate Values Between Dimensions
Replies: 7
Views: 1251

Re: TM1 Rule to Propagate Values Between Dimensions

Do you really think people will still want to help, voluntarily, after your first post here ?
viewtopic.php?t=16641
Hijacking a thread, not responding to help given, etc.
Not for me :-)
by Wim Gielis
Thu Mar 21, 2024 2:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CubeSecurity and ProcessSecurity
Replies: 4
Views: 859

Re: CubeSecurity and ProcessSecurity

No it will not give an error.
by Wim Gielis
Thu Mar 21, 2024 1:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A couple of strange TM1 bugs
Replies: 4
Views: 2692

Re: A couple of strange TM1 bugs

Could it be some kind of string length that is exceeded, when concatenating parameter names and parameter values at runtime ?
by Wim Gielis
Tue Mar 19, 2024 5:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 18
Views: 1452

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

zbhmida wrote: Tue Mar 19, 2024 5:08 pmIBM support ask to up grade the engine,
What a surprise :D
by Wim Gielis
Tue Mar 19, 2024 9:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 18
Views: 1452

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

200 GB ? No rules and feeders ?

You don’t have to put the whole TM1 model in 1 cube.or are you recreating the DWH in a cube ?
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: 18
Views: 1452

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: 8
Views: 1782

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: 18
Views: 1452

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: 18
Views: 1452

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