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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top