on 08-28-2016 3:05 PM
Dear Experts
We have a requirement to show the respective cost centers in column on context change of an entity.
For eg: If my ENTITY selection is 2000 then all the cost centers pertaining to ENTITY 2000 should be reflected in the column on the report. Same is the case when I change my entity to 2100.
Please note: I have 2 different dimension ie ENTITY and COST CENTER Dimension.
Can anyone help be resolve this requirement.
Regards
ATG
First you have to explain the relationship between your Entity and CostCenter dimensions: one to many, many to many... Please illustrate!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ATG,
You need to use Entity property of CostCenter dimension as Rahul mentioned. However, filter by CONTEXT is working when users select to show ID only in Context selector window, what is not convenient for users.
So, as Lucas suggested, it is better to use EMPDimensionOverride function to filter the specific Cost Centers in your report.
Best regards,
Oleksandr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use EPMDimensionOverride specifying the cost centre from the Entity property.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.