Skip to Content
Former Member
May 27, 2013 at 01:37 PM

How to solve Dimension Relationship


Is there a way to solve dimension relationship in a SAP BPC report?

I have account and cost center dimensions in my model. I need to filter in a report to show only some accounts for each cost center.

For exemple, I want to have something like this in a report ROWs:

Cost Center Expenses - Account Cost Center 1 Expense 1 Expense 2 Expense 3 Cost Center 2 Expense 2 Expense 3 Cost Center 3 Expense 3 Cost Center 4 Expense 1 Expense 3

I have around 40 expense account and 300 cost centers. I need to filter that in a way that each cost center only see their respective expense account. Each manager can have access to around 5 to 10 cost centers.

What is the best way to do that?