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.
Storing work session of a logged in user till logout
- orlando
- Community Contributor
- Posts: 167
- Joined: Fri Aug 04, 2017 8:27 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
Re: Storing work session of a logged in user till logout
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.
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.
-
- Posts: 47
- Joined: Thu Jun 21, 2018 8:33 am
- OLAP Product: IBM cognos
- Version: 10.2.2
- Excel Version: 2013
Re: Storing work session of a logged in user till logout
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.
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.
- Steve Rowe
- Site Admin
- Posts: 2416
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Storing work session of a logged in user till logout
Hi Sparten, please don't double post your queries, please continue to ask questions on your previous thread.
Technical Director
www.infocat.co.uk
www.infocat.co.uk