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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mangaraju venuturupalli (mangaraju_at_yahoo.com)
Date: 07/08/04 

Date: 8 Jul 2004 07:51:27 -0700

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.

Relevant Pages

  • Re: Slow member loading in excel 2003 pivot table
    ... it loads member quickly... ... I'm gonna add a transform step in my cube loading and just truncate the data... ... Maybe a simply filter another file extension dimension table with a ">3)" and set all the fact with the missing key error to a default member... ... I'm gonna sound crazy, bu I need to find a way to create various sized dimension and see how excel react and display them, I want to range from ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow member loading in excel 2003 pivot table
    ... The more I think about it, the more I fear the "almost instantaneous" display of this dimension member was just a dream:'( ... I'm gonna sound crazy, bu I need to find a way to create various sized dimension and see how excel react and display them, I want to range from 2K to 30K with a 2K step... ... I couldn't process the cube anymore or load 2 smaller cube with 500MB dimtree. ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow member loading in excel 2003 pivot table
    ... I couldn't process the cube anymore or load 2 smaller cube with 500MB dimtree. ... with the cube browser in Visual Studio, the first load is long, but then the add/remove from the browser became instantaneous. ... and it is longer than a similar member data set (the only difference is this big parent child dimension which is smaller) ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow member loading in excel 2003 pivot table
    ... Did you try Excel 2007? ... it loads member quickly... ... I'm gonna add a transform step in my cube loading and just truncate the ... (that way I could still have the whole dimension available, ...
    (microsoft.public.sqlserver.olap)
  • RE: How to count the cells between CURRENTMEMBER and LastNonEmpty?
    ... Slicing doesn't change the members of a set at all, ... change the current member of, making it useless to do any kind of IIF ... One solution--given the dimension assumptions I stated ... the time.CURRENTMEMBER of a specified product and its last sale. ...
    (microsoft.public.sqlserver.olap)