Hi all,
Hope you are doing well!
i'm trying to use OptimusPy on IBM cloud, and i don't know if i can use it!
i ve succefully connected tm1py from my local PC to the cloud server ?
Any ideas,
best regards,
Zied
Search found 20 matches
- Tue Apr 09, 2024 11:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: OptimusPy - Ideal dimension order finder
- Replies: 15
- Views: 6729
- Thu Mar 21, 2024 1:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Hi all, and thank you again for your diffirent answers, i write to you the comment of IBM for my case! Support IBM a commenté Hi Zied, Development responded on a previous case and confirmed this can be expected. Re-ordering the cube dimensions completely changes our memory layout for the cube data. ...
- Wed Mar 20, 2024 9:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
It's better to use OptimusPy rather than Architect's automatic dimension reorder: https://code.cubewise.com/open-source/tm1py/optimuspy/ When searching for optimal dimension order, it does not just minimize ram, but finds optimal balance between speed and ram Hi Elessar, cool I saw it on the intern...
- Tue Mar 19, 2024 5:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Having this, I assume that dimensions which are used at consolidated level in source view were moved from first ones to last ones in dimension order, am I right? 8-) :idea: :idea: Yes it is the case ! the main dimension that contains the conso level were moved to last dimension. Thank s a lot, IBM ...
- Tue Mar 19, 2024 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
200 GB ? No rules and feeders ? Yes I understand that you are shocked, :? :shock: :o and no the ropic is not to use a cube like a DWH ! but we have an SKU level. We had a cube with 400 GB before. So during our audit we were able to remove some dimensions and also we used alternative hierarchies ins...
- Tue Mar 19, 2024 9:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
We reordered the dimensions of the target cube (the system proposed a 42% memory gain). Why would you reorder to a worse dimension order?! When reordering the idea is to REDUCE memory footprint Hi lotsaram we reordered the dimensions to gain RAM, because before the reorder we have 200 GB on the cub...
- Tue Mar 19, 2024 9:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Now, what is it, same cube or different cube ? Not that it makes a lot of difference, but still. Yes it is the same cube. If I were you, I would first look at why it takes 35 minutes to copy data. That seems like a long time. Yes i see it s too long but we have a lot of data on this cube ! and our ...
- Mon Mar 18, 2024 8:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Okey i wil see for the upgrade
But juste fyi
We ve tried to run the process for one perimeter without runing the parallel TI and and unfortunately we have the same issue
That’s mean that the process takes longer than before the reordering :/
Thanks
- Mon Mar 18, 2024 4:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Hi sorry,
Yes we are using
11.8.00800.5
best regards,
Zied
Yes we are using
11.8.00800.5
best regards,
Zied
- Mon Mar 18, 2024 4:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Hi Wim,
Thank you for your quickly answer,
we are on cloud 2.0.93
Best regards,
Zied
Thank you for your quickly answer,
we are on cloud 2.0.93
Best regards,
Zied
- Mon Mar 18, 2024 1:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2553
Performance Implications of Dimension Reordering in Turbo Integrator Processes
Hi Hi All, Hope you are doing well !!! I am writing to inform you of our problem when executing a Turbo Integrator process. Below are the different operations we performed: 1.We have a Turbo Integrator that makes a copy within the same cube. In the source cube, we selected a consolidated level, and ...
- Tue May 31, 2022 12:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SUMIF results in #ERR! on TM1 web
- Replies: 2
- Views: 2322
Re: SUMIF results in #ERR! on TM1 web
Hi,
I had the same problem,
the solution will be to put the sum.if at the end of the DBRW, because the systme execute the first line before the reste, so for that you will have #Err,
best regards,
Zied
I had the same problem,
the solution will be to put the sum.if at the end of the DBRW, because the systme execute the first line before the reste, so for that you will have #Err,
best regards,
Zied
- Wed Oct 20, 2021 9:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security matter
- Replies: 5
- Views: 4653
Re: Security matter
Hi All,
Thanks for your reply,
Well it works after a server TM1 restart,
i forget to specifie, the Cell Security is a specific CellCubeSecurity that doesn't contain all dimensions,
Best regards,
Zied
Thanks for your reply,
Well it works after a server TM1 restart,
i forget to specifie, the Cell Security is a specific CellCubeSecurity that doesn't contain all dimensions,
Best regards,
Zied
- Tue Oct 19, 2021 9:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security matter
- Replies: 5
- Views: 4653
Re: Security matter
Thank for reply
I ve cheked thé user is assigned to one groups,
No perf modeler,
Isn't a bug on this PA version ?
Best regards
Zied
I ve cheked thé user is assigned to one groups,
No perf modeler,
Isn't a bug on this PA version ?
Best regards
Zied
- Tue Oct 19, 2021 2:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security matter
- Replies: 5
- Views: 4653
Security matter
Hi I'm trying to put security on cellsecurity cube, I ll describe the case: - i'have a security for cube A on }CubeSecutity for a cube implemented by Rules: the access right is WRITE - i'have a }CellSecurity for element on the cube A for Two elements - Element x ==> Write - Element y ==> <Empty> - w...
- Thu Aug 24, 2017 9:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Clean a carriage return character
- Replies: 7
- Views: 5876
Re: Clean a carriage return character
Thank you wim,
it works now ^^
Thk you guys
Best regards
it works now ^^
Thk you guys
Best regards
- Wed Aug 23, 2017 2:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Clean a carriage return character
- Replies: 7
- Views: 5876
Re: Clean a carriage return character
Well, i have tried: nLength = Long(vValeur); nScan = SCAN(CHAR(13), vValeur); IF(nScan >0); vValeur = SubSt(vValeur,1,nScan - 1) | ' ' | SubSt(vValeur,nScan + 1,nLength); endif; it works but the string is not loaded totally, i explain: LF = CHAR(13) = carriage return caracter, pString = "tissu ...
- Wed Aug 23, 2017 12:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Clean a carriage return character
- Replies: 7
- Views: 5876
Re: Clean a carriage return character
Hi Jim,
Yes its going back to TM1,
and Yes the DatasourceASCIIQuoteCharacter='';
i ll try
thank you for your reply
Zied
Yes its going back to TM1,
and Yes the DatasourceASCIIQuoteCharacter='';
i ll try
thank you for your reply
Zied
- Wed Aug 23, 2017 10:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Clean a carriage return character
- Replies: 7
- Views: 5876
Clean a carriage return character
hi guys, i m tring to export data from a cube using ASCIIOutput on a TurboIntegrator process, and on txt export i have a string that contain a carriage return character, i ve tried to cleansed in the same TI with DELET (pString, SCAN(CHAR(13), pString),1) but it didnt work do you have any other sugg...
- Thu Nov 28, 2013 10:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using ItemReject in the Prolog of a TI
- Replies: 11
- Views: 9607
Re: Using ItemReject in the Prolog of a TI
hi
You have to put this script on DATA tab
It works for me:
#***************************************************************
If ( vtest = 1 );
ItemReject ('Error Msg');
ProcessBreak;
EndIf;
#**************************************************************
You have to put this script on DATA tab
It works for me:
#***************************************************************
If ( vtest = 1 );
ItemReject ('Error Msg');
ProcessBreak;
EndIf;
#**************************************************************