dbTalk Databases Forums  

newbie question - browse all data MSAS cube

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


Discuss newbie question - browse all data MSAS cube in the microsoft.public.sqlserver.olap forum.



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

Default newbie question - browse all data MSAS cube - 01-03-2006 , 11:45 PM






Hi group,

I know this might b dumb question, but I am new to MSAS thing.
I have a to write code to browse all data stored in MSAS cube. Issue is
I have to even display all properties of all the data & members
involved. Say when I get into Market dimension I have to display all
the relevant properties. I am not sure what approach to take on this
one. I am sure MDX (ODBO interface) should be able to help me out here,
but it wud require huge manipulations to get all the relevant data.
Also I might not be able to display the properties such as formulae
associated with member.

So I wud like to know if there is any other API for doing this Looking
forward to hear about possible approaches.

Abhijeet


Reply With Quote
  #2  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: newbie question - browse all data MSAS cube - 01-16-2006 , 02:55 AM






Hi,

Do you now this construct in MDX query to get dimension member properties?

SELECT
....
PROPERTIES ...
on columns
FROM ...

Behind the PROPERTIES you can specify all member properties that you need.


Thanks,
Vladimir Chtepa

"abhijeet" <abhi.10dulkar (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1136353526.271412.276590 (AT) f14g2000cwb (DOT) googlegroups.com...
Quote:
Hi group,

I know this might b dumb question, but I am new to MSAS thing.
I have a to write code to browse all data stored in MSAS cube. Issue is
I have to even display all properties of all the data & members
involved. Say when I get into Market dimension I have to display all
the relevant properties. I am not sure what approach to take on this
one. I am sure MDX (ODBO interface) should be able to help me out here,
but it wud require huge manipulations to get all the relevant data.
Also I might not be able to display the properties such as formulae
associated with member.

So I wud like to know if there is any other API for doing this Looking
forward to hear about possible approaches.

Abhijeet




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.