TM1 Forum

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

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. ...

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...

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 ...

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...

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...

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 ...

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

Hi sorry,

Yes we are using
11.8.00800.5

best regards,
Zied

Hi Wim,

Thank you for your quickly answer,

we are on cloud 2.0.93

Best regards,
Zied

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 ...

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

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

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

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...

Thank you wim,

it works now ^^

Thk you guys
Best regards

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 ...

Hi Jim,

Yes its going back to TM1,
and Yes the DatasourceASCIIQuoteCharacter='';

i ll try

thank you for your reply
Zied

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...

hi

You have to put this script on DATA tab
It works for me:

#***************************************************************
If ( vtest = 1 );
ItemReject ('Error Msg');
ProcessBreak;
EndIf;
#**************************************************************