Hi all,

is there a way to retrieve the FORMAT_STRING property of a measure via MDX?

I'm thinking about something like this:

WITH MEMBER [Measures].[Format]
AS [Measures].[Internet Sales Amount].Properties("FORMAT_STRING")

SELECT [Measures].[Format] On Columns,
[Date].[Date].DefaultMember ON Rows
FROM [Adventure Works]

But this statement just returns "#Error"

Thanks for any sugestions,

Andreas

FORMAT_STRING is a cell property
Try to use this command:

SELECT [Measures].[Internet Sales Amount] On Columns,
[Date].[Date].DefaultMember ON Rows
FROM [Adventure Works] CELL PROPERTIES FORMAT_STRING,VALUE

Vladislav Beliaev

Vladislav,

thank you for your reply.

My problems is, that I want to use the formatting defined in the cube in a
RS 2005 report. Unfortunately it seems that RS doesn't return extended
properties when using the MSOLAP.3 provider for a generic OLE.DB data
source.

Any ideas?
Andreas

"VBeliaev" <vbeliaev (AT) mail (DOT) ru> wrote