Search found 88 matches

by Ashleigh W
Sat Nov 27, 2021 7:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How is }ElementSecurity_dimensionname create?
Replies: 4
Views: 16903

Re: How is }ElementSecurity_dimensionname create?

Thanks but how to create this Cube to begin with?
by Ashleigh W
Sat Nov 27, 2021 5:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How is }ElementSecurity_dimensionname create?
Replies: 4
Views: 16903

How is }ElementSecurity_dimensionname create?

Please help - I cannot find any article on how to create }ElementSecurity_dimensionname.
by Ashleigh W
Thu Jul 22, 2021 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way for TI Process to create Subset using MDX?
Replies: 2
Views: 2456

Is there a way for TI Process to create Subset using MDX?

Hi experts, is there a way for TI Process to create permanent Subset using MDX expression so it is dynamic.
I want the MDX to be stored with Subset too so that elements are dynamic.

Thank you
by Ashleigh W
Thu Apr 22, 2021 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to dynamically refer to cube view in TI?
Replies: 5
Views: 2777

Re: How to dynamically refer to cube view in TI?

Thank you for quick response.

does it matter where I place DataSourceNameForServer?
I currently set it at the Prolog bottom
by Ashleigh W
Thu Apr 22, 2021 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to dynamically refer to cube view in TI?
Replies: 5
Views: 2777

How to dynamically refer to cube view in TI?

Hi experts, is there a way to dynamically refer to cube view in TI without setting reference to specific cube and view in 'Data Source'? I have a TI which need to run on top on multiple cubes. Same TI - Multiple cubes with only 1 dimension difference and I do not want to replicate multiple TIs. Than...
by Ashleigh W
Tue Apr 20, 2021 7:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to for TI to write to multiple intersection in one line?
Replies: 8
Views: 3330

Re: Is there a way to for TI to write to multiple intersection in one line?

Thanks burnstripe. I will check the approach of writing to csv and loading back to target cube. Currently I am checking for best solution, and it is taking about 30mins which is not expectable :) Process 1: Stage all relevant data. Few seconds to process Process 2: Process above data using below cod...
by Ashleigh W
Tue Apr 20, 2021 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to for TI to write to multiple intersection in one line?
Replies: 8
Views: 3330

Re: Is there a way to for TI to write to multiple intersection in one line?

thanks for quick response. This might actually work. I need to flag 0,1 or 2
by Ashleigh W
Tue Apr 20, 2021 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to for TI to write to multiple intersection in one line?
Replies: 8
Views: 3330

Is there a way to for TI to write to multiple intersection in one line?

Hello experts, Is there a way to for TI to write to multiple intersection in one line without looping through each element in Dimension subset? Any alternative ways or options are most welcome. Below code works find which to create a dynamic subset and tag all the elements by looping through element...
by Ashleigh W
Fri Oct 30, 2020 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ElementParent Function return blank
Replies: 4
Views: 1786

Re: ElementParent Function return blank

that must be the reason. I use PA.
Within the documentation IBM didn't mentioned it or I must have missed it :D

Thank you!
by Ashleigh W
Thu Oct 29, 2020 4:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ElementParent Function return blank
Replies: 4
Views: 1786

Re: ElementParent Function return blank

I am trying this in TI and Rule as well it does not work in both.

In Excel Sheet it is not recognized.
by Ashleigh W
Thu Oct 29, 2020 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ElementParent Function return blank
Replies: 4
Views: 1786

ElementParent Function return blank

Hello experts, I have been trying to get parent of element from specified hierarchy but it wont work for me I tried in below format with multiple sample of index 1,2,3 etc. but it won't return any value. In Model Dimension I have 4 top / parent node / hierarchy. ElementParent('Model', 'Automobile', ...
by Ashleigh W
Thu Apr 09, 2020 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write to range of cells within TM1 Cube
Replies: 9
Views: 4125

Re: How to write to range of cells within TM1 Cube

PavoGa - I tried CellPutProportionalSpread and it is fast enough but I actually wanted to fill/write String values. Loop as well worked pretty much the same however I am interested to know if there are other options too.
by Ashleigh W
Tue Apr 07, 2020 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write to range of cells within TM1 Cube
Replies: 9
Views: 4125

Re: How to write to range of cells within TM1 Cube

Thanks for the insight / very useful information. I'll definitely try CellPutProportionalSpread.
by Ashleigh W
Tue Apr 07, 2020 1:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write to range of cells within TM1 Cube
Replies: 9
Views: 4125

Re: How to write to range of cells within TM1 Cube

If I have a Parent Element (A), can I have a TI Process to write 'X' to measure 'Flag' all the children of A instead of having to loop? Currently my code looks something like this in data tab. Is there another way to write to cells instead of loop through tDIM? tDIM = 'Cost Center'; Idx = 1; MaxIdx=...
by Ashleigh W
Tue Apr 07, 2020 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write to range of cells within TM1 Cube
Replies: 9
Views: 4125

How to write to range of cells within TM1 Cube

Hello again Experts, is there a way to write to range of (level 0 elements ) cells within TM1 Cube like in Rule we can specify a range we want to populate? For example CellPutN or CellPutS can only write to single point of intersection.

Please advise.