cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic column based on dimension change: SAP BPC 10.0

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member186338
Active Contributor
0 Kudos

First you have to explain the relationship between your Entity and CostCenter dimensions: one to many, many to many... Please illustrate!

Oleks_Master
Participant
0 Kudos

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

lucas_costa3
Active Contributor
0 Kudos

Use EPMDimensionOverride specifying the cost centre from the Entity property.

former_member225135
Active Contributor
0 Kudos

Hi,

Create entitty property in cost center dimension and filter the property while creating the report.

Regards,

Rahul