TM1 User Types

Post Reply
AliUgur
Posts: 58
Joined: Tue Aug 05, 2014 2:13 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: Excel 2013

TM1 User Types

Post by AliUgur »

Hi guys,

I am working on a Consolidation Project with TM1 10.2.2 version. As ı know TM1 user types become Power User and End User(Maybe there are more different types of user but generally like this).
The problem is for admin user everything is ok. He can do anything with the dimensions, views, cubes, rules.
But end user when he/she trace the rule, they can see the rule but they can not see the data it shows everything 'N/A'. İs this beacuse of being end user. or not?

Thanks..
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: TM1 User Types

Post by BariAbdul »

Mostly N/A error occurs due to incorrect use of dividing (forward slash) '/' . Division by zero using this operator returns an undefined value,Where as \ (back slash) DivisionDivision by zero using this operator returns zero.Please check your rules again.Thanks.
"You Never Fail Until You Stop Trying......"
AliUgur
Posts: 58
Joined: Tue Aug 05, 2014 2:13 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: Excel 2013

Re: TM1 User Types

Post by AliUgur »

You are right BariAbdul. But in this case the differences of the users just about user type being admin or not. when admin trace the same rule it shows the data not N/A.

Thanks for reply..
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: TM1 User Types

Post by BariAbdul »

Did you check the permissions for the users.Since admin can view everything that is the reason you might be seeing whole,Might be data rights issue.Not quite sure ,Though!Thanks
"You Never Fail Until You Stop Trying......"
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 User Types

Post by lotsaram »

AliUgur wrote:Hi guys,

I am working on a Consolidation Project with TM1 10.2.2 version. As ı know TM1 user types become Power User and End User(Maybe there are more different types of user but generally like this).
The problem is for admin user everything is ok. He can do anything with the dimensions, views, cubes, rules.
But end user when he/she trace the rule, they can see the rule but they can not see the data it shows everything 'N/A'. İs this beacuse of being end user. or not?

Thanks..
Do the users have at least read security rights to the cells that are being referenced? If not then I believe that what you are seeing is likely "by design". Although calculations will always work regardless whether end users have access to the intermediate cells in the calculation chain this doesn't mean that users will be able to see the values when doing a rule trace. This did use to be the case but the rule tracer circumventing security was raised as a security issue. I can't recall off the cuff exactly when this was fixed but I believe it was and what you are seeing is a result of that.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
AliUgur
Posts: 58
Joined: Tue Aug 05, 2014 2:13 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: Excel 2013

Re: TM1 User Types

Post by AliUgur »

My question wiil change a little bit. The problem is not about data. Its about attributes. The end user can not see the attribures value but admin can see it.

Have any idea?

Thanks..
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TM1 User Types

Post by tomok »

AliUgur wrote:My question wiil change a little bit. The problem is not about data. Its about attributes.
And what exactly do you think an attribute is? It's just data stored in a cube like everything else in TM1. If you don't have security access to the attribute cube then you can't see them.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
AliUgur
Posts: 58
Joined: Tue Aug 05, 2014 2:13 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: Excel 2013

Re: TM1 User Types

Post by AliUgur »

You are write Tomok. Thanks for helping. It was about security Access.

Have a nice day..
Post Reply