Search found 88 matches
- Sat Nov 27, 2021 7:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How is }ElementSecurity_dimensionname create?
- Replies: 4
- Views: 16928
Re: How is }ElementSecurity_dimensionname create?
Thanks but how to create this Cube to begin with?
- Sat Nov 27, 2021 5:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How is }ElementSecurity_dimensionname create?
- Replies: 4
- Views: 16928
How is }ElementSecurity_dimensionname create?
Please help - I cannot find any article on how to create }ElementSecurity_dimensionname.
- Thu Jul 22, 2021 2:09 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: 2474
Re: Is there a way for TI Process to create Subset using MDX?
Perfect! thank you! thank you!
- 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: 2474
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
I want the MDX to be stored with Subset too so that elements are dynamic.
Thank you
- Thu Apr 22, 2021 4:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to dynamically refer to cube view in TI?
- Replies: 5
- Views: 2806
Re: How to dynamically refer to cube view in TI?
Thank you so much!
- 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: 2806
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
does it matter where I place DataSourceNameForServer?
I currently set it at the Prolog bottom
- 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: 2806
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...
- Wed Apr 21, 2021 7:19 am
- 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: 3370
Re: Is there a way to for TI to write to multiple intersection in one line?
Appreciate all the inputs. Thank you as always.
- 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: 3370
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...
- 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: 3370
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
- 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: 3370
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...
- Fri Oct 30, 2020 10:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ElementParent Function return blank
- Replies: 4
- Views: 1816
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
Thank you!
Within the documentation IBM didn't mentioned it or I must have missed it
Thank you!
- Thu Oct 29, 2020 4:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ElementParent Function return blank
- Replies: 4
- Views: 1816
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.
In Excel Sheet it is not recognized.
- Thu Oct 29, 2020 4:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ElementParent Function return blank
- Replies: 4
- Views: 1816
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', ...
- Thu Apr 09, 2020 11:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to write to range of cells within TM1 Cube
- Replies: 9
- Views: 4165
Re: How to write to range of cells within TM1 Cube
Thanks again Wim for your help.
- 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: 4165
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.
- 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: 4165
Re: How to write to range of cells within TM1 Cube
Thanks for the insight / very useful information. I'll definitely try CellPutProportionalSpread.
- 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: 4165
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=...
- 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: 4165
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.
Please advise.
- Thu Apr 02, 2020 12:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to prevent any TI process writing to cells which are set to READ
- Replies: 4
- Views: 2259
Re: How to prevent any TI process writing to cells which are set to READ
thanks. Appreciate your help/support.