Re: Simple MDX question - selecting dimension members

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

If you have not explicitly set a default measure I believe the first
measure in the list will be used.

BTW every dimension has a default member, its just that for all the
other dimensions their default is the All member. :)

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <eQh2xM6vFHA.2792@xxxxxxxxxxxxxxxxxxxx>,
kevind@xxxxxxxxxxxxxxxxxxxxxx says...
> Hmm, interesting. In this case, the cube doesn't have a default measure set.
> Is SSAS just picking one (this is SSAS 2005, btw)?
>
>
> "Deepak Puri" <deepak_puri@xxxxxxxxxxxxxxx> wrote in message
> news:OKhU4BzvFHA.3860@xxxxxxxxxxxxxxxxxxxxxxx
> > The values belong to the cube default measure. For example, the Foodmart
> > Sales cube has [Unit Sales] as default, and so these 2 MDX queries
> > return the same results:
> >
> >>>
> > select Non Empty [Store].[Store State].Members on columns
> > from Sales
> >
> > ----------
> >
> > select Non Empty [Store].[Store State].Members on columns
> > from Sales
> > where [Measures].[Unit Sales]
> >>>
> >
> >
> > - Deepak
> >
> > Deepak Puri
> > Microsoft MVP - SQL Server
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
>
>
>
.

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)