Re: Unable to set intrinsic "DESCRIPTION" member property

Descripton is a mandatory property -- you can set it in the AS mgr and
it shows up for schema objects (i.e. cube, dimension, level, even
member property), but I don't know that there is anything special about
it as a property of a member. I'm still struggling with Excel's pivot
table not recognizing the Caption property!
JR

Mark Landry wrote:
> The OLEDB for OLAP specification lists a set of mandatory member
> properties. (Spofford lists them on p. 409 of "MDX Solutions".) One of
> these is called "Description" however there appears to be no way to set
> this value so it's always null.
>
> Has anyone discovered a way to set the "Description" member property?

.

Relevant Pages

  • Re: Possible ROLAP Cube Design Scenario
    ... > we have very limited time window for cube processing. ... > I am just curious if we have a way to design acube with both MOLAP & ROLAP ... >> While 2M is a big dimension, I don't see why it isn't doable. ... but so long as you keep it at 2M with no member properties then ...
    (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
    ... 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: Why would NonEmptyCrossJoin fail on a virtual cube which joins
    ... I had previously assumed that when defining a virtual cube containing ... default member from all missing dimensions would be used to define the ... as the coordinate for that dimension when defining the virtual cube to ...
    (microsoft.public.sqlserver.olap)