Hi,
I have the following problem.( This problem is only for users with NO ADMIN access. The users with ADMIN don t have this problem ).
After the user updates dimension A, he logs in TM1WEB and the values from Dimension A are not displayed. The field is BLANK.
The values are coming from a subset that is recreated for each user every time he is accessing this Report. It s a subset created dynamic with MDX.
If i go into Architect and i check the subset, this is created and contains the correct values. The problem is that this Values are not displayed on TM1WEB.
For getting the values i used SUBNM.
As a solution I tried giving users admin access over the dimension, but it didn t work.
IF i go and refresh the security, then the users are able to see the values. But I don t want to include Refresh security in the process because it will block the application.
Thank you
TM1 WEB dimension elemnts not display after dimension Update
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
-
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 WEB dimension elemnts not display after dimension Update
Presumably the dimension in question has element security applied?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 WEB dimension elemnts not display after dimension Update
Sorry i forgot to mention that.
Yes the Dimension has element security set to Write. ( But the ALL element has Read)
Should i change that to Admin?
Yes the Dimension has element security set to Write. ( But the ALL element has Read)
Should i change that to Admin?
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 WEB dimension elemnts not display after dimension Update
Hi,
I found somewhere that the rules can be attached with a TI.
How can I do that?
Or someone has another idea?
thank you
I found somewhere that the rules can be attached with a TI.
How can I do that?
Or someone has another idea?
thank you
-
- 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 WEB dimension elemnts not display after dimension Update
So you've just added new elements to a dimension. How is the security being updated to make the new elements WRITE? Did you do it via the ElementSecurityPut function in the same TI process? Is that TI process set to allow security updates?AnonimusMax wrote:Sorry i forgot to mention that.
Yes the Dimension has element security set to Write. ( But the ALL element has Read)
Should i change that to Admin?
-
- Posts: 27
- Joined: Sun Aug 02, 2009 2:57 am
- OLAP Product: Cognos TM1/Cognos BI
- Version: from 9.4 to PA 2.0.9
- Excel Version: 2010
- Location: Toronto
Re: TM1 WEB dimension elemnts not display after dimension Update
If you have }ElementSecurity_cube populated by Rules, you need to include SecurityRefresh command in the TI process that Updates the Dimensions ( usually in the Epilog Tab of the process )
Ardian Alikaj
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 WEB dimension elemnts not display after dimension Update
Hi,
I know about the SecurityRefresh, but i don t want to use this because it is placing on Wait State the other processes that are ruining in parallel.
Do you know another way to do this?
The security is updated by rules. I don t do it in a process. This is the only solution? Write the security in a process?
I have the dimension security for the dimension that i insert the new Element set to ADMIN for all users. and the ElementSecurity is set to READ.
Thank you.
I know about the SecurityRefresh, but i don t want to use this because it is placing on Wait State the other processes that are ruining in parallel.
Do you know another way to do this?
The security is updated by rules. I don t do it in a process. This is the only solution? Write the security in a process?
I have the dimension security for the dimension that i insert the new Element set to ADMIN for all users. and the ElementSecurity is set to READ.
Thank you.
-
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 WEB dimension elemnts not display after dimension Update
If element security is done by rules then SecurityRefresh function is needed to update for changes including new elements.
To minimize locking do this in a separate chore.
(Or use data entry via TI rather than rules for the security)
To minimize locking do this in a separate chore.
(Or use data entry via TI rather than rules for the security)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 WEB dimension elemnts not display after dimension Update
And i also have another problem.
If I am logged into TM1WEB.
I start the process of loading data. The dimension is updated by inserting 1 new element and the rest of the processes are calculating the new data.
If i open a report, the new data is not displayed until I close TM1WEB and I open it again.
Thank you,
If I am logged into TM1WEB.
I start the process of loading data. The dimension is updated by inserting 1 new element and the rest of the processes are calculating the new data.
If i open a report, the new data is not displayed until I close TM1WEB and I open it again.
Thank you,