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.
Tm1 WorkSheet Security
- 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
Thanks
Vinnusea
Vinnusea
- 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
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
http://publib.boulder.ibm.com/infocente ... 700A4.html
Cheers!
Rizwan Kaif
Rizwan Kaif
- 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
Oh Thank you very much .
So if after implementiong the security USER sees Prices Only he input not OTHER USERS INputs ... Am i correct.
So if after implementiong the security USER sees Prices Only he input not OTHER USERS INputs ... Am i correct.
Thanks
Vinnusea
Vinnusea
- 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
Yes using the TM1 security you can achieve what you are looking for.vinnusea wrote:So if after implementiong the security USER sees Prices Only he input not OTHER USERS INputs ... Am i correct.
Cheers!
Rizwan Kaif
Rizwan Kaif