only after ownership at total level in contributor, user can edit in TM1 web??

Post Reply
TM1user_pri
Posts: 9
Joined: Fri Aug 26, 2016 11:27 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

only after ownership at total level in contributor, user can edit in TM1 web??

Post by TM1user_pri »

Hi TM1 masters,

Please guide how below situation can be handled.

Scenario is-

Some users(Business planners) are using TM1 application portal(contributor) in an approval hierarchy setup and some users( business super users) are using TM1 web for input to all the nodes which are part of approval hierarchy.

e.g Nodes- approval hierarchy

Total
Node1
Node2
Node3

1. user1- belongs to group having access to 'Node2' & 'node3'- only input from application portal
2. user2- belongs to group having access to 'Total' node and all other groups as well. He is a superuser who needs to login to web to access INput views and edit for all nodes.
But when he logs in to web, he is not able to edit until he goes back to contributor and takes ownership on total level . he can only edit those nodes for which he takes ownership even when he has access to all nodes.

I think it works like this but still is there any other way where he do not need to go back to contributor to take ownership as it is an additional step for them.
Also, we wanted that when superuser will edit in web then that time no other business planners can edit application. But if superuser will edit- it means all the nodes are open only.

Please guide. we cannot make Superuser as 'ADMIN'. need any other way.
Thanks.
pandinus
Posts: 78
Joined: Tue Mar 18, 2014 8:02 am
OLAP Product: TM1, Cognos Express
Version: 10.2.2
Excel Version: 2013

Re: only after ownership at total level in contributor, user can edit in TM1 web??

Post by pandinus »

In the }CubeProperties cube there is a measure named DATARESERVATIONMODE.
When using TM1 Applications this mode is set to REQUIRED or REQUIREDSHARED by default for each cube that is used in the application.

You are free to change this value as you wish. For example, you can set this to OFF to no longer bother users to go into the TM1 Applications and take ownership of the specific node.

Be careful however, this may create potential conflicts where one user enters data directly into TM1 Web, and another one commits their data from their (sandboxed) TM1 Applications.
TM1user_pri
Posts: 9
Joined: Fri Aug 26, 2016 11:27 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: only after ownership at total level in contributor, user can edit in TM1 web??

Post by TM1user_pri »

Hi Pandinus,
TM1user_pri
Posts: 9
Joined: Fri Aug 26, 2016 11:27 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: only after ownership at total level in contributor, user can edit in TM1 web??

Post by TM1user_pri »

Hi pandinus,

Thanks for your reply.
But, I want that planners go to the application and take ownership and then edit. But, when superusers who have access to all the nodes, they should login and see all white cells in web.
Without changing the reservation mode in cubeproperties control cube, because as you mentioned it can lead to issues.

How it should be in general scenario, how cubes used in application portal will behave in Tm1 web for users? Because in web, there is no ownership concept.
Please guide. Thanks.
Post Reply