Creatae a TI proess who simulates the same role of Snapshot cube button

Post Reply
pikolikoli
Posts: 37
Joined: Sun May 17, 2020 2:37 am
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Creatae a TI proess who simulates the same role of Snapshot cube button

Post by pikolikoli » Tue Nov 16, 2021 12:24 pm

Hello TM1 People,

For a business need, I should create a TI process who extracts any public view created by users to database. I tried using parameters and passing the cube and vue to parameters then adding these two lines :

Code: Select all

DataSourceNameForServer = pCube;
DataSourceCubeView = pView;
But it seem taking all the dimension elemnts of the view, not just the selected elemnts of the view ( selcetd ctitle, selected columns etc ...).
How can I make my process For any given view, take only the selected values by the user and insert into database the values that show in the view. In other words, dymanimycly simulate Snapshot button for every view?

Thank you in advance

Wim Gielis
MVP
Posts: 2792
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.10
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Creatae a TI proess who simulates the same role of Snapshot cube button

Post by Wim Gielis » Tue Nov 16, 2021 1:51 pm

Either you ask the users to only have 1 element in the title selections.
Either you process the associated *.vue file, maybe there's information on what is shown as the chosen element.
Either you look at the REST API.

The solutions are presented from easiest to most difficult.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 120 TM1 articles and a lot of custom code
Newest blog article: Documenting processes and rules https://github.com/wimgielis

Post Reply