Re: calculated member caption

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vinay Dharmik (v.dharmik_at_zensar.com)
Date: 08/13/04 

Date: 13 Aug 2004 02:16:52 -0700

"Olivier Matrat" <olivier.matrat_nospam@winsight.fr> wrote in message news:<OPdUBgHgEHA.236@tk2msftngp13.phx.gbl>...
> Hi
>
> First check on which dimension you've created the calc member.
> If it's not on Measures then chances are that your member is somewhere on a
> slicer dimension on top of the browser.
> Also, if the syntax you use in your calculation is incorrect then the member
> will not show in the standard MS AS cube browser view.
>
> HTH
>
> Olivier.
>
> "Lasse Simonsen" <LasseSimonsen@discussions.microsoft.com> wrote in message
> news:B4CC8D0E-5C33-4D7E-B710-4AFCBAF226AD@microsoft.com...
> > I create a calculated member but the name doesn't show in the column or
> row
> > header in the data view. Does anyone know why?

Check the syntax of the calculated member. If it says the syntax is
OK, save the same and u'll see the member in the data view of the cube
where u created the calc. member.

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: 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)
  • 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)