Re: DSO to list members?

From: Sean Boon [MS] (seanboon_at_online.microsoft.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 10:47:23 -0700

Hi Rickard,

DSO is strictly for administrative purposes (defining cubes, dimensions and
levels). Only OLAP administrators can use it. If you want to get a list of
dimension members, then you'll need to look at ADOMD, ADOMD.NET and XML/A to
retrieve that information. The MDX sample application or the XML/A sample
application which comes with the SDK (which includes the source code) would
probably be a good place to start. 

-- 
Sean
-- 
Sean Boon
SQL Server BI Product Unit
-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Rickard" <rickardrygin@hotmail.com> wrote in message
news:687e5de8.0404210438.73e2a5ec@posting.google.com...
> Hi,
>
> Is it possible to use DSO to retrieve and list all members in a specific
dimension?

Relevant Pages

  • Re: problem to display calculated dimension members in pivot table
    ... >> SQL BI Product Unit (Analysis Services) ... >>> i created several calculated dimension members and don't understand ... >>> excel the calculated members can't be displayed under the dimension. ...
    (microsoft.public.sqlserver.olap)
  • Re: dimension vs level
    ... dimension members into memory when the service starts up. ... is to be able to drill into transaction level detail data. ... Decision is important> since if it loads all the rows, then it can have significatly load the> memory- TransNo will have thousands of members and they can form many> conbimations with store no and reg no> ...
    (microsoft.public.sqlserver.olap)
  • Re: Drillthrough problem
    ... Is "bananas" a technical term? ... is caused by the fact that an unoptimized schema has an inner join with the ... dimension table and -- as we all know -- inner joins eliminate data with no ... non-existent dimension members, then in the processing of an unoptimized ...
    (microsoft.public.sqlserver.olap)
  • Add a dimension problem
    ... I'm trying to add a dimension to my cube with DSO objects. ...
    (microsoft.public.sqlserver.olap)
  • Re: Retrieving Custom Properties on a dimension
    ... for cubes, dimensions, and levels using DSO. ... rights. ... >> that there were so many kinds of custom properties for a dimension. ...
    (microsoft.public.data.xmlanalysis)