TM1 WEB dimension elemnts not display after dimension Update

Post Reply
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

TM1 WEB dimension elemnts not display after dimension Update

Post by AnonimusMax »

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
lotsaram
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

Post by lotsaram »

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.
AnonimusMax
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

Post by AnonimusMax »

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?
AnonimusMax
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

Post by AnonimusMax »

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
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 WEB dimension elemnts not display after dimension Update

Post by tomok »

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?
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?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
tm1expert
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

Post by tm1expert »

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
AnonimusMax
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

Post by AnonimusMax »

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.
lotsaram
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

Post by lotsaram »

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)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
AnonimusMax
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

Post by AnonimusMax »

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,
Post Reply