dbTalk Databases Forums  

get measure display format from adomd

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap get measure display format from adomd

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


Discuss get measure display format from adomd in the microsoft.public.sqlserver.olap forum.



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

Default get measure display format from adomd - 07-04-2003 , 10:19 AM





how can i get to the "display format" property of a measure from adomd ?
thanks,
vincent


Reply With Quote
  #2  
Old   
Vincent
 
Posts: n/a

Default Re: get measure display format from adomd - 07-07-2003 , 01:36 PM





matt,
i found an example. thanks for your help.
vincent

Quote:
Matt Carroll [MS]<MattCar (AT) online (DOT) microsoft.com> 7/7/2003 11:20:39 AM
If you request the FORMAT_STRING member property in the query, then you can access this property in the Properties collection on the ADOMD Member object.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Vincent" <vincent41 (AT) msn (DOT) com> wrote

how can i get to the "display format" property of a measure from adomd ?
thanks,
vincent



Reply With Quote
  #3  
Old   
Vincent
 
Posts: n/a

Default Re: get measure display format from adomd - 07-07-2003 , 05:26 PM


matt,
i'm trying now to get the format string property with the oledb properties schema rowset. i can't seem to get the restriction columns right. is it possible to get the value this way. if yes, could you maybe point me to an example of the correct syntax.
thanks,
vincent

Quote:
Matt Carroll [MS]<MattCar (AT) online (DOT) microsoft.com> 7/7/2003 11:20:39 AM
If you request the FORMAT_STRING member property in the query, then you can access this property in the Properties collection on the ADOMD Member object.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Vincent" <vincent41 (AT) msn (DOT) com> wrote

how can i get to the "display format" property of a measure from adomd ?
thanks,
vincent



Reply With Quote
  #4  
Old   
Matt Carroll [MS]
 
Posts: n/a

Default Re: get measure display format from adomd - 07-11-2003 , 05:03 PM


My mistake: Format_string is a cell property not a member property. If you lookup "Intrinsic Properties" and then choose "Intrinsic Cell Properites" in books online, you'll get a list of the built in cell properties including format string.

Hope this helps,
- Matt Carroll

--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Vincent" <vincent41 (AT) msn (DOT) com> wrote

matt,
i'm trying now to get the format string property with the oledb properties schema rowset. i can't seem to get the restriction columns right. is it possible to get the value this way. if yes, could you maybe point me to an example of the correct syntax.
thanks,
vincent

Quote:
Matt Carroll [MS]<MattCar (AT) online (DOT) microsoft.com> 7/7/2003 11:20:39 AM
If you request the FORMAT_STRING member property in the query, then you can access this property in the Properties collection on the ADOMD Member object.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Vincent" <vincent41 (AT) msn (DOT) com> wrote

how can i get to the "display format" property of a measure from adomd ?
thanks,
vincent


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