dbTalk Databases Forums  

Can a measure's relational definition be retrieved via ADODB/MD?

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


Discuss Can a measure's relational definition be retrieved via ADODB/MD? in the microsoft.public.sqlserver.olap forum.



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

Default Can a measure's relational definition be retrieved via ADODB/MD? - 06-02-2005 , 03:49 PM






Hello,

Can a measure's relational definition be retrieved programmatically? The
EXPRESSION property retrieves the calculation (if any) used, but can I get
the actual definition of a base measure? For example, if a measure is
defined as SomeFactTable.SomeFactTableColumn, is there a way I could
retrieve that via an ADODB/MD object or schemarowset call?

Thanks!

Keith



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Can a measure's relational definition be retrieved via ADODB/MD? - 06-02-2005 , 06:56 PM






Sorry.
I believe the only way to get the calculation is via DSO.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Keith" <keith (AT) alh (DOT) com> wrote

Quote:
Hello,

Can a measure's relational definition be retrieved programmatically? The
EXPRESSION property retrieves the calculation (if any) used, but can I get
the actual definition of a base measure? For example, if a measure is
defined as SomeFactTable.SomeFactTableColumn, is there a way I could
retrieve that via an ADODB/MD object or schemarowset call?

Thanks!

Keith




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.