dbTalk Databases Forums  

Get Parent-Child Level with DSO

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Get Parent-Child Level with DSO in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Johannes
 
Posts: n/a

Default Get Parent-Child Level with DSO - 01-15-2004 , 03:24 AM






I have a problem in getting the names of levels
in a Parent-Child Dimension. I only get one, but
I want to have them like it is in the MDX Generator, e.g
Level 01
Level 02
Level 03,
...

There is a Property "LevelNamingTemplate" but it can
change e.g. with the language version of the Analysis
Services ("Level 01, Level 02, ..." or "Ebene 01, Ebene
02", ...).
There are sometimes fix level names, placeholders like *
or nothing in this property.

How can I get the Level names of a Parent-Child Objekt?

Thanks, Johannes

Reply With Quote
  #2  
Old   
Sean Boon [MS]
 
Posts: n/a

Default Re: Get Parent-Child Level with DSO - 01-15-2004 , 01:54 PM






Parent Child dimensions only have two levels in DSO, (All) and the
Leaf-level. The intermediate "levels" are not considered DSO objects. DSO
also does not allow you to access the actual members of the hierarchy. DSO
is strictly for administrative purposes.

If you are developing a client application that needs to expose this
information you should use ADOMD or XML/A.


--
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.



"Johannes" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a problem in getting the names of levels
in a Parent-Child Dimension. I only get one, but
I want to have them like it is in the MDX Generator, e.g
Level 01
Level 02
Level 03,
...

There is a Property "LevelNamingTemplate" but it can
change e.g. with the language version of the Analysis
Services ("Level 01, Level 02, ..." or "Ebene 01, Ebene
02", ...).
There are sometimes fix level names, placeholders like *
or nothing in this property.

How can I get the Level names of a Parent-Child Objekt?

Thanks, Johannes



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.