TM1 Forum

Hello All,

Is it possible in tm1 , to store information entered by a logged in user in some sheets till log out. Like storing the information entered by the user at that particular session and using that information in other sheets till that work session.

Hi,

if you use the Web-Cube-Viewer, the answer is: no, you can't store these informations.
If you use Exce websheets, you got the answers how to store the data

https://www.tm1forum.com/viewtopic.php? ... 091#p72091

if you only want this inoformation available during one session, and forget after logout maybe this could work:

A:
Assumption:
The cube, you store the information, contains the dimension "}Clients"

In the cube "}ClientProperties" you find the element "STATUS". There you can see, if a user is active.

Now you write a rule in your cube like:

[] = N: if(DB('}ClientProperties',!}Clients,'STATUS') @='ACTIVE', continue, 0);
[] = S: if(DB('}ClientProperties',!}Clients,'STATUS') @='ACTIVE', continue, '');

B:
You write a process, that checks if a client is active. If not, delete the values.
Put this process into a chore and let it run every few minutes.

Hello Orlando,

I have a question, can we access a value in work book1 to workbook2.

Like, in workbook1 i have selected year as 2019, so the year in workbook2 should be automatically generate by taking value of year from workbook1 in TM1 WEB.

Hi Sparten, please don't double post your queries, please continue to ask questions on your previous thread.