Hello, I am working on Planning Analytics Workspace as a Service 2.0.106. I am trying to fix a process that gets a cube's rules file (.rux) and then convert it to a .txt file and store it in my File Manager inside PAaaS. In the Planning Analytics Local version, the process executed a command line via ExecuteCommand function, and was retrieving the .rux file from the TM1data folder (see ti process below) ```TM1Path= CellGetS( 'z_Admin_Param' , 'REP_TM1DATA' ,'STR_VAR1') |'\';Query= 'cmd /c copy "'| TM1Path| 'Rule1.rux" "'| TM1Path| 'textFile1.txt"' ;ExecuteCommand(Query,0);``` How can I retrieve the .rux file in the PAaaS version ? Thank you in advance, Best regards,Zied
Ti Code:
RuleText = CubeRuleGet('Calendar');TextOutput('Files/textFile1.txt', RuleText);
This retrieves the rule script for the cube named Calendar and writes it to the textFile1.txt .I don't think accessing .RUX is directly possible on PAaaS
Have a look at some of the newer functions like CubeRuleGet (per post above) you could assign this to a cube/string cell.However, on PAaaS and in the containerised environment, not sure if that will help but may be something to work with...
Hi George I tested the CubeRuleGet function in PAaaS and it works perfectly for my use case. I'm now able to retrieve the cube's rules and store them as a .txt file in the File Manager.
CubeRuleGet
.txt
Appreciate your help!
Excellent! I think you had it anyway - I was just not sure where the file would be written but if you can access in the File Manager that is great.Also possibly good to know this if we need to test those situations where we do a bulk load and remove rules then at the end load again.Thanks for confirming - will post back when I get around to testing the export, delete, reload one day.
Just for additional information, I have the impression that the function is limited to about 66,000 characters in a RUX file :i ve already open a support ticket to IBM to have the confirmation :)