Hi there,

I have a report like this:

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

It was generated from my financial cube.

The "INCOME" and "COST" are physical members of Account

dimension. PROFIT and MARGIN% are calculated dimension

members of Account. Here are their Mdx scripts:

Calculate Member [Account].PROFIT AS
[Account].INCOME - [Account].COST

[Account].MARGIN% AS
[Account].PROFIT / [Account].INCOME

Besides, Actual, Budget, and Variance are another three calculated

measure members. Now I have a problem with KPI in AS 2005.

I want my new report looks like this:

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

I defined my KPI Status MDX as follows:

Case
When [Account].CurrentMember.Name = 'INCOME'
AND [Measures].Variance < 0 then -1
When [Account].CurrentMember.Name = 'INCOME'
AND [Measures].Variance >= 0 then 1

When [Account].CurrentMember.Name = 'PROFIT'
AND [Measures].Variance < 0 then -1
When [Account].CurrentMember.Name = 'PROFIT'
AND [Measures].Variance >= 0 then 1
End

In this manner, I got a report I don't want. I think it's a problem

of solve order between Calculated member and KPI.

The KPI Status works fine at "INCOME" row, but errors at the

"PROFIT" row. I think KPI Status generates before the PROFIT

in the AS 2005. Becasue I tried to print the
[Account].CurrentMember.Name

at KPI Value. The PROFIT and MARGIN% columns can't be displayed.

Can anyone help me on this?

Thanks in advanced

Best Regardly