TM1 Forum

Dear Experts,

In MSAS we can execute the MDX statement as below.
With Member [Measures].[commision] as [Measures].[Commission]
,FONT_SIZE=10
, FORMAT_STRING='#,#.0000'
SELECT NON EMPTY { [Measures].[commision] } ON COLUMNS,
NON EMPTY { ([Category].[Category].[Categories].ALLMEMBERS ) } ON ROWS FROM [A - Training Sales]
CELL PROPERTIES VALUE, FONT_SIZE, FORMATTED_VALUE

So I have question how we can handle the CELL PROPERTIES in TM1 MDX statement. Does it support in TM1 similar to MSAS.
If I try to add the FONT_SIZE and FORMAT_STRING in TM1 MDX then the MDX statement is not executed.

Thanks and Regards,
Sachin

Hi Sachin,
Please do try and post in the correct forum.

AFAIK these functions are not supported in MDX with TM1.
I'm curious as to where you are trying to do this as in native TM1 there isn't really anywhere you can return a number and care about the format it is in.