Search found 3503 matches

by lotsaram
Thu Mar 28, 2024 7:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to avoid queuing at the end of processes parallelization ?
Replies: 5
Views: 307

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

Data commit (the last step of the process) is single threaded / locking as it updates the cube index structure, so it might be the case when a lot of Tis are committing at the same time and are queuing due to this. It might be better to split data less evenly, so that they're committing at differen...
by lotsaram
Wed Mar 27, 2024 8:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule to Propagate Values Between Dimensions
Replies: 6
Views: 366

Re: TM1 Rule to Propagate Values Between Dimensions

Hi MarenC, Thank you so much for your reply, but I tried this, this isnt working. And I am writing the rule in product attribute cube only. 2 rules I tried:- 1.) ['at_PBBU'] = S: If( (DB('}ElementAttribute_Cpg_hierarchy', ATTRS('Product', !Product ,'at_CPG'), 'att_PPBU') @= 'Y') , 'Y' , '' ); 2.) [...
by lotsaram
Fri Mar 22, 2024 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CubeSecurity and ProcessSecurity
Replies: 4
Views: 438

Re: CubeSecurity and ProcessSecurity

If I am not mistaken, the TI process will generate error if there is command to update the cube. You are mistaken. TI processes always run with DataAdmin rights (full Admin if the "Security Access" option is also selected). Therefore users can update dimension and cubes they don't have th...
by lotsaram
Tue Mar 19, 2024 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 18
Views: 900

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

zbhmida wrote: Mon Mar 18, 2024 1:24 pm 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
by lotsaram
Mon Mar 04, 2024 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Drill process return handle
Replies: 3
Views: 181

Re: }Drill process return handle

I wasn't aware of this. Will have to look up ReturnCSVTableHandle and see if I can get it to work. The "classic" way of doing this is to use a text to ODBC driver and set up a public ODBC DSN pointed to a specific folder then have a TI process write a CSV to the folder which can then be di...
by lotsaram
Mon Mar 04, 2024 11:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Concentrating two dimensions elements together to form a unique identifier
Replies: 4
Views: 250

Re: Concentrating two dimensions elements together to form a unique identifier

It might help if you can explain why you need to do this. Do you need to flatten data and export using the key to another system?
by lotsaram
Thu Feb 29, 2024 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewConstruct on XBV view
Replies: 1
Views: 201

Re: ViewConstruct on XBV view

I assume the version in your profile isn't up to date? What version are you on as I am quite sure this has been solved for quite some time.
by lotsaram
Wed Feb 28, 2024 6:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 364

Re: RAM and PVU licensing

+100 for George’s 1st post.
by lotsaram
Wed Feb 14, 2024 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Subset TI Data Source Alias
Replies: 4
Views: 734

Re: Dimension Subset TI Data Source Alias

Is it a limitation that aliases do not show when the data source is Dimension Subset? Not a limitation, a feature! ;) It doesn't matter what alias is assigned to subsets used in datasources (views and subsets). From a data source variable perspective TI will always read the principal name. As sugge...
by lotsaram
Tue Feb 06, 2024 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA on IBM Cloud - Uploading users
Replies: 4
Views: 1052

Re: PA on IBM Cloud - Uploading users

I'm not convinced that being able to create users but not have the user accounts be properly active and able to be used (that is log onto the system with the account) is a really useful feature.
by lotsaram
Fri Jan 05, 2024 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Dependency Query
Replies: 2
Views: 708

Re: Rule Dependency Query

If the rule sheet for both cubes reference the attributes of the same dimension via a lookup, something like a prior period lookup then does this create a dependency between my two cubes? No. in Cube A ['Measure'] = DB ('Cube A' , ......, DB('}ElementAttributes_Period' , !Period, 'Prior') ,....); i...
by lotsaram
Mon Dec 11, 2023 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16659

Re: ViewZeroOut doesn't work

EP_explorer wrote: Sat Dec 09, 2023 11:28 am
burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
Why are you using a 3 year old version?
by lotsaram
Mon Dec 04, 2023 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM usage exploding with CubeUnload and ViewConstruct
Replies: 5
Views: 11695

Re: RAM usage exploding with CubeUnload and ViewConstruct

Why don't you export data to CSV on production and load the CSV in Test/Dev? It seems to me that this would be a better solution. - more scope for automation since at the end of the export the process to load the file could be chained by tm1runti or rest call - presumably the whole history doesn't c...
by lotsaram
Wed Nov 15, 2023 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance drop between 2.0.9.1 and 2.0.9.15
Replies: 7
Views: 9954

Re: Performance drop between 2.0.9.1 and 2.0.9.15

I can only agree that there is absolutely no point in testing an upgrade to 2.0.9.15 as this is already a year old. Go with the latest release: 1. as you will get better support if needed from IBM or your BP rather than being helpfully asked to upgrade 2. if you are working for a organization with g...
by lotsaram
Wed Nov 15, 2023 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 18575

Re: REST API Dimension Clone

There's no single endpoint to duplicate a dimension. You can get the elements and structure, but you then need separate calls to create the attributes and then copy the data.
by lotsaram
Tue Nov 14, 2023 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to ViewZeroOut }bedrock.cube.view.create
Replies: 3
Views: 7464

Re: Unable to ViewZeroOut }bedrock.cube.view.create

Declan's answer is correct. You need to use ExecuteProcess not RunProcess. 1. So that all processes will be part of the same commit transaction, which makes temp objects accessible to other processes whihc are part of the same transaction. 2. So that the execution is serial and the calling process w...
by lotsaram
Tue Nov 14, 2023 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10189

Re: Tm1 Model - Limit Overall RAM Usage

Not being able to shutdown the instance would seem to be a fatal flaw in using this! What would happen to a long-running TI process that was processing rule calculated cells and consequently growing the calculation cache? If memory limit exceeded does the TI process just error? Or does it do somethi...
by lotsaram
Wed Nov 08, 2023 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10189

Re: Tm1 Model - Limit Overall RAM Usage

You can't.

TM1 will eat up all available memory until it runs out.

And then it is paging, hanging and crashing time.
by lotsaram
Thu Oct 12, 2023 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Dependency with DB Function - How Smart?
Replies: 3
Views: 6468

Re: Cube Dependency with DB Function - How Smart?

We have an issue at the moment when updating a meta-data cube that is relied on heavily throughout our larger data cubes that it seems to be causing a constant recalc everytime a view is pulled once it's updated. The odd thing is, the measure that is being updated I do not believe is in ANY rules. ...
by lotsaram
Wed Sep 20, 2023 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock delimiter
Replies: 5
Views: 3694

Re: Bedrock delimiter

I think if you just comment out lines 90-92 on the prolog then this should suffice. If( pThousandSeparator @= '' ); pThousandSeparator = ','; EndIf; You can raise a ER at https://github.com/cubewise-code/bedrock/issues The check for empty paramater and inserting a default makes sense. To achieve non...