Blank pivot when displaying a dimension member and a calculated member.

  • Thread starter mangaraju venuturupalli
  • Start date
M

mangaraju venuturupalli

Hello,

I have an account dimension, with members like REVENUE, COST, WIP and
so on. And I have a calculated member called "TOTAL COST" created from
this dimension which is (COST + WIP).

Now, here is what I have in pivot:
- ROW dimension (time)
- COLUMN dimension (currency, account) ... there's only one member in
currency.

When I show the pivot, I have a case, where REVENUE is zero and COST
is non-zero. In this case, if I choose to display REVENUE (a zero
regular member) and "TOTAL COST" (a non-zero calculated member), the
pivot is going blank.

Is this a known problem ? Could anyone please help ?

Thanks a lot.
 
Top