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?