access control objects

Wim Gielis
MVP
Posts: 2258
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: access control objects

Post by Wim Gielis » Sun Nov 03, 2019 5:14 pm

What does the user see ? Can you finally answer that question ? A user that is not an admin user. Also, in the base sandbox. To verify, show us that exact cell while being logged on with that user.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

declanr
MVP
Posts: 1628
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: access control objects

Post by declanr » Sun Nov 03, 2019 6:23 pm

vikram.balaji16 wrote:
Sun Nov 03, 2019 2:41 pm
and the value in tm1 web view looks in blue color.
Is the user using a sandbox ?
no he is not using any sand box.test_process1.PNG
The blue colour means that the user is using a sandbox.This could either be a manually created and selected sandbox - or very likely the user has the Personal Workspace capability enabled.

Press the tick icon "commit" in the ribbon and the value will be commited from the user's sandbox/workspace to the base data. Try this out to confirm that is what's happening, after you do it the admin user will be able to see the value as well.

If you are certain that the user is not using a sandbox then go to the capabilities section to confirm they are enabled for a personal workspace.
https://www.ibm.com/support/knowledgece ... d2001.html

You can of course work out why workspaces were enabled and then decide whether they should be disabled for the group or whether you should just train the users to press the commit button.
Declan Rodger

Wim Gielis
MVP
Posts: 2258
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: access control objects

Post by Wim Gielis » Sun Nov 03, 2019 9:49 pm

Mentioning capabilities is indeed good Declan.

But what I don’t understand, if it is indeed the Personal Writeback mode : by default, user groups do not have the Personal Workspace Writeback mode capability granted. So you vikram.balaki, or another admin person, must have enabled it. You don’t remember enabling that capability ?

On the contrary, sandboxes are enabled by default.

Please go through the list here, in detail:
http://www.wimgielis.com/tm1_cellchange_EN.htm
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

vikram.balaji16
Posts: 17
Joined: Tue Oct 29, 2019 3:50 am
OLAP Product: IBM Cognos
Version: 10.2.2
Excel Version: 1808

Re: access control objects

Post by vikram.balaji16 » Mon Nov 04, 2019 2:27 am

declanr wrote:
Sun Nov 03, 2019 6:23 pm
vikram.balaji16 wrote:
Sun Nov 03, 2019 2:41 pm
and the value in tm1 web view looks in blue color.
Is the user using a sandbox ?
no he is not using any sand box.test_process1.PNG
The blue colour means that the user is using a sandbox.This could either be a manually created and selected sandbox - or very likely the user has the Personal Workspace capability enabled.
Anw: In user workspace sandbox shows is default , and i have checked in architect that personal workspace is enabled i.e.. i can see grant

Press the tick icon "commit" in the ribbon and the value will be commited from the user's sandbox/workspace to the base data. Try this out to confirm that is what's happening, after you do it the admin user will be able to see the value as well.
Anw: As you said i have commited the data by selecting tick icon on the ribbon ,but data is not reflecting in the base data.
i can see data in users default sanbox, where as i see zero data in base sandbox .

Wim Gielis
MVP
Posts: 2258
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: access control objects

Post by Wim Gielis » Tue Nov 05, 2019 6:59 am

Wim Gielis wrote:
Sun Nov 03, 2019 9:49 pm
Please go through the list here, in detail:
http://www.wimgielis.com/tm1_cellchange_EN.htm
What is the result of this exercise ?
If you quote an earlier reaction here, make sure your own answers are visible immediately.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

vikram.balaji16
Posts: 17
Joined: Tue Oct 29, 2019 3:50 am
OLAP Product: IBM Cognos
Version: 10.2.2
Excel Version: 1808

Re: access control objects

Post by vikram.balaji16 » Thu Nov 07, 2019 3:17 am

Wim Gielis wrote:
Tue Nov 05, 2019 6:59 am
Wim Gielis wrote:
Sun Nov 03, 2019 9:49 pm
Please go through the list here, in detail:
http://www.wimgielis.com/tm1_cellchange_EN.htm
What is the result of this exercise ?
If you quote an earlier reaction here, make sure your own answers are visible immediately.
Issue is resolved by make none to execute in the process security cube and after that I made websheet reset. Then which users created sandbox is working. But default sand box is not working

Post Reply