Re: reading dimension members with DSO

You read dimension members using MDSCHEMA_MEMBERS; not using DSO.
DSO creates the structures, but not for reading the data, i.e. what the
members look like.
The Analysis Manager dimension browser actually creates a cube (or uses an
existing cube) behind your back to provide the browsing experience.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Supriya" <Supriya@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D27804A2-896F-4FDF-92C1-A5116C270172@xxxxxxxxxxxxxxxx
> Hi,
> I am trying to get members that belong to a given dimension level using
DSO
> in my C# application. I can't find an Olap collection object of members or
> any such. Can anybody help.
> Thanks
> Supriya.


.

Relevant Pages

  • RE: How to count the cells between CURRENTMEMBER and LastNonEmpty?
    ... I tested how the cube would behave if I also provide the "missing data". ... Slicing doesn't change the members of a set at all, ... One solution--given the dimension assumptions I stated ... the time.CURRENTMEMBER of a specified product and its last sale. ...
    (microsoft.public.sqlserver.olap)
  • SQL 2005
    ... Cubes in a virtual cube 255 maximum ... Levels in a dimension 64 maximum ... Members per parent 64,000 maximum ... Calculated members in a parent measure in session context 31,743 ...
    (microsoft.public.sqlserver.olap)
  • Re: design for distinct count
    ... A fact table with only keyforlevel3 will save disk space. ... use disabled level property of the dimension in each cube for less ... if virtual dimensions based on the dimension are used together. ... > count should be for the lowest level members alone. ...
    (microsoft.public.sqlserver.olap)
  • Re: dumb question on Dimensions
    ... optimizing is a step done thourgh the menu in the cube editor. ... system will execute an inner join when you process the cube. ... any missing members are not loaded and no key error should occurs. ... dimension table and the string is truncated, ...
    (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)