dbTalk Databases Forums  

how to get the customproperties of measures

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


Discuss how to get the customproperties of measures in the microsoft.public.sqlserver.olap forum.



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

Default how to get the customproperties of measures - 09-16-2003 , 09:39 AM







1>We added customproperties to measures by using DSO. Is it possible to
retrieve them from MDX?

2> How to retrieve the "Description" value for a measure from MDX?

For example, we can get

WITH member [Measures].[A] as '
[Measures].[Cost].Properties("CAPTION")'



or

WITH member [Measures].[A] as ' [Measures].[Cost].Properties("Name")'





But the following always give an error

WITH member [Measures].[A] as '
[Measures].[Cost].Properties("Description")'


--
Posted via http://dbforums.com

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.