dbTalk Databases Forums  

ADOMD - How to represent hierarchy

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap ADOMD - How to represent hierarchy

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


Discuss ADOMD - How to represent hierarchy in the microsoft.public.sqlserver.olap forum.



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

Default ADOMD - How to represent hierarchy - 08-11-2003 , 11:07 AM





Use the LevelDepth Property of the Members to define the
indentation Level.

HTH.
Cheers,
Sanka

Quote:
-----Original Message-----
We are going to show the data using ADOMD
How will we show hierarchies

MDX Query sample foodmart 2002:-
SELECT
{[Measures].[Unit Sales]} ON COLUMNS,
{DESCENDANTS(STORE)} ON ROWS
FROM Sales

i.e Country/State/StoreName (Unit Sales Data)
Now on rows I get every member from MDX query but how do
I show them in
hierarchical fashion
Regards,
Akshay



.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top