How to solve Dimension Relationship

[Former Member]

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?

[Former Member]

Hi Handerson,

We cannot maintain many - to - many relationship in BPC as properties.

We, usually, load it as transaction data. For example, post a value of 1 for all the possible combinations of cost center and account. Keep the data in a unique datasrc. Keep the other dimensions to some dummy member.

In you template, first create a report with the above datasrc, and do a zero suppression. This will show only the valid records (valid combinations). Now create the 2nd report, and do an axis sharing with the first report.

Hope this helps.