Limiting drop down values by user using MDX

[M1ndbender]

I am wondering if it is possible and if so how you could use MDX to limit the values returned in a drop down by the user logged in.

User opens a TM1Web data entry form and has to enter data for 4 companies they are responsible for. Currently when they select the drop down they see all the companies in the system.

Is there a way to use MDX so that they would only see the companies that they are aligned to. We align the user to the companies in a cube and then push the security using a process to assign with read or write access to the companies.

Any insight would be appreciated

[Wim Gielis]

If you push the security with a process, then why don’t you have element security on the elements in the picklist ?

[MarenC]

Hi,

I presume the security process already applies the element security?

But if the process applied either Read or Write then they would all show in the picklist. There was no mention anyone was given NONE access.

Assuming you want everyone to have read or write access, then you could put an attribute against the company for the responsible user and build the MDX based on this.

Maren