Member Properties of Dimension..

From: Vivek Vaidya (vivek.vaidya_at_rapt.com)
Date: 04/28/04 

Date: 28 Apr 2004 12:09:07 -0700

Hello!

Is there a way to get the list of member properties that have been
defined for a Dimension? I don't want the values of the properties for
each Dimension Member--I know I can get that when I use
MDSCHEMA_MEMBERS. I want to know which properties have been defined in
the Dimension (i.e. I want the list of properties as part of the
response to MDSCHEMA_DIMENSIONS) so that I can query for the
corresponding properties while processing the MDSCHEMA_MEMBERS rowset.

Thanks in advance,
Vivek.

Relevant Pages

  • Re: Incremental update on changing dimension corrupting data in cu
    ... By "corrupting" I mean that the subtotals are incorrect (I have no record of ... If yet another incremental update of the dimension is ... The dimension does have member properties on which 2 other dimensions are ... therefore not associated with this cube. ...
    (microsoft.public.sqlserver.olap)
  • Re: Pivot Tables with OLAP Cube - Dimension Properties Excel 2K
    ... SQL magazine ran an article called "Member properties bootcamp" which talked ... SQL BI Product Unit ... Excel 2000 doesn't handle the dimension ... > Does anyone know a free asp web cube browser such as ...
    (microsoft.public.sqlserver.olap)
  • Upgrade to SSAS 2005
    ... We are facing issues while creating dimensions with respect to the ... levels and member properties. ... Our source for this dimension is a view which has all the above ... It's an urgent requirement and any hint is highly appreciated. ...
    (microsoft.public.sqlserver.olap)
  • displaying member properties in PivotTable
    ... Im trying to display Member Properties in PivotTable. ... I have a cube that has one dimension called Products. ...
    (microsoft.public.office.developer.web.components)
  • Re: Datawarehouse Architecture
    ... designing a cube with a large customer dimension. ... slow if you want to view the members even the member properties on your ... A count of the customers who were active during a certain period. ...
    (microsoft.public.sqlserver.datawarehouse)