Hi there,

I have a fianancial cube and I want to generate
a financial report based on this cube.

Now, I have a problem on the KPI.


My report likes this:


Actual Budget Variance
INCOME 10 8 2
COST 3 4 -1
NET INCOME 7 4 3
MARGIN% 70% 50% 20%


What I am going to do is to add a KPI Status Column next to the
"Variance" Column like this


Actual Budget Variance Lights
INCOME 10 8 2 Green
COST 3 4 -1
NET INCOME 7 4 3 Green
MARGIN% 70% 50% 20%


My problem is how to set the KPI Lights only applied to the specified
rows, "INCOME" and "NET INCOME". I don't want the "COST" and
"MARGIN%" rows have the KPI Lights.


Some information about my cube:
In my cube, "Actual", "Budget", and "Variance" are three Calculated
Measure members. Additionally, "NET INCOME" and "MARGIN%"
are two Calculated Dimension members applied to Accounts Dimension.


Thanks in advance.


Best Regardly.


Tom