Hi,
a quetion about Custom Roll up.

I have the following cube (trying toshow the same lay-out as in the cube):

Period dimension: All Period
Unit Dimension : All Unit
Measures
MonthValue TargetValue
KPIDimension
Financial
Revenue 10000 15000
Cost 8000 13000
Customer
Complaints 50 40

Depending on what Unit i select i want to make one of the KPI-dimensions
appear or disappear. So for example when i select Unit A than it should only
show the financial KPIs and wheni select Unit B it should only show the
Customer KPIs.
Is this possible?

Thnx,

Stanley

Couldn't you establish this relationship in the fact table?
I mean, rows of Unit A would have only Financial KPIs Ids, Unit B Customers
KPIs and so on

regards,
Vanclei

"Stanley" wrote:

Hello Vanclei,

I finally rearrange my views, so now i only get to see KPIs from Units i
want to see.

Thnx

"Vanclei Matheus" wrote: