Tm1 WorkSheet Security

Post Reply
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Tm1 WorkSheet Security

Post by vinnusea »

Hi
We are developing a new server where there will be a Cube with products and measures. And need to be Input Templet where user Input Price for each Product.
ISSUE:

1. There are 10 Users and 10 users inputs 'Price' for each product and If a User opens the Cube He needs to see the Price he Input and should nt see Other Users Input Prices.

2. There is a 'Standard Price' Measure which is populated by only One Main User. So This User Inputs 'Standard Price' And this can be seen by all users but cannot edit it.

3.So If the Regular User Selects 'Price' He will see the price which he input and If he selects the ' Standard Price' He will see the standard price which was input by Main User

Please any one have any Idea...what do i need to use in Input Worksheet Templet...???

Thanks for your time.
Thanks
Vinnusea
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Tm1 WorkSheet Security

Post by rkaif »

Answer to your question is simple - Implement TM1 security. This is explained in the TM1 Operations guide. See this link:

http://publib.boulder.ibm.com/infocente ... 700A4.html
Cheers!
Rizwan Kaif
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Re: Tm1 WorkSheet Security

Post by vinnusea »

Oh Thank you very much .
So if after implementiong the security USER sees Prices Only he input not OTHER USERS INputs ... Am i correct.
Thanks
Vinnusea
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Tm1 WorkSheet Security

Post by rkaif »

vinnusea wrote:So if after implementiong the security USER sees Prices Only he input not OTHER USERS INputs ... Am i correct.
Yes using the TM1 security you can achieve what you are looking for.
Cheers!
Rizwan Kaif
Post Reply