Re: Using XMLA to get intrinsic/basic properties

From: Hanying Feng [MS] (hfeng_at_online.microsoft.com)
Date: 06/08/04

  • Next message: Chris Harrington: "Re: Using XMLA to get intrinsic/basic properties" 
    Date: Tue, 8 Jun 2004 11:12:46 -0700

    Intrincis properties are for members, not for metadata objects.

    To get intrinsic properties for members, you can use MDX query to specify
    dimension properties. For example, select measures.members dimension
    properties description on 0 from sales. If the description property contains
    value, you will see it in Member.

    To get the description property from cubes and other metadata objects, you
    should use schema rowsets.

    Thanks,
    Hanying 

    -- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Chris Harrington" <charringtonDEL@ETEactiveinterface.com> wrote in message
news:OncjzrPTEHA.3872@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Is is possible to get the description property from cubes, dimensions,
> levels, etc. using XML/A? If so, how is it done.  Thanks.
>
> Chris
>
>
  • Next message: Chris Harrington: "Re: Using XMLA to get intrinsic/basic properties"

    Relevant Pages

    • RE: Calculating Max Usage with OLAP
      ... to answer your question about how to only build aggregations at ... dimension and then looking at the Advanced tab in the properties pane). ... The combined number of members on both these ... > Max Used Licenses means –how many concurrent licenses have been used during ...
      (microsoft.public.sqlserver.olap)
    • Re: Problem with Member Counts and applying filters using MDX in M
      ... Now i am trying to count the "members" in this big dimension based on ... various possible filters that the user might apply. ... So far i am able to get the count of members on this big dimenion with one ... Here is the MDX i am trying.... ...
      (microsoft.public.sqlserver.olap)
    • Re: MDX Compatibility Property
      ... It looks like a bug. ... Please do not send email directly to this alias. ... The dimension browser forms an integral part of our ... have hidden members work ok! ...
      (microsoft.public.sqlserver.olap)
    • Re: Help Needed with Dynamic Dimension Security
      ... business application for securing members. ... and the point in the hierarchy where the security ... > of using Dimension Security with a Virtual Cube. ...
      (microsoft.public.sqlserver.olap)
    • RE: Computing histograms / bins in MDX
      ... you can't define a new dimension for the scope of a query unfortunately. ... if you have too many buckets to define manually and you don't mind ... //OF MEMBERS IN AS THE NUMBER OF BUCKETS DESIRED ...
      (microsoft.public.sqlserver.olap)