How to derive dimension id based on selected properties of a dimension

[former_member250987]

Hi Experts,

I have following requirement

Requirement:

Cost_Center dimension has 2 properties called Budget Manager AND Financial Analyst.

Users want all these three (Cost_CenterID, BM_NAME AND FA_NAME in inputform filters/prompts)

input form prompts

User can select Cost center, Budget Manager, Financial analyst independently.

For example, if user selected cost center then records in the form should be displayed only based on selected cost center irrespective of budget manager and financial analyst.

Similarly, if user selected properties Budget manager or Financial analyst then records in the form should be displayed only based on Budget manager or Financial analyst irrespective of Cost center.

Solution:

I am thinking to derive id(cost center) of dimension based on selected properties(Budget manager or Financial analyst) of cost center and then to perform dimension override on cost center.

But i am not sure if there is a way to derive dimension ID based on selected property .Please help me if there is way in which we can derive id based on selected properties.

or please let me know if there is any better solution for above requirement.

Thanks in advance

Siva

[former_member186338]

EPMDIMENSIONOVERRIDE will do the job, what’s the issue?