Dear all,

Is there anyway to retrieve cell properties information using MDX?

for eg, this will retrieve properties information
with member [Measures].[Store Sqft] as
'Store.currentmember.properties("Store Sqft")'

any way to get cell properties FORMAT_STRING information?
Member [Measures].[Format] as '[Measures].[Unit
Sales].CELLPROPERTIES("FORMAT_STRING")' ???

SELECT {[Measures].[StoreName],[Measures].[Store Sqft]} on Columns,
{Store.[Store Name].members}
on rows
FROM SALES
Where [Time].[1997]
CELL PROPERTIES VALUE, FORMATTED_VALUE, FORMAT_STRING, FORE_COLOR,
BACK_COLOR


Thanks in advance.
cc

Hello,

You may want to refer to the information in the following web site:

Using Cell Properties
http://msdn.microsoft.com/library/de...us/olapdmad/ag
mdxadvanced_11yr.asp

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.