TM1 Forum

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

Presumably the dimension in question has element security applied?

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?

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

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?

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 )

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.

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)

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,