CELL PROPERTIES in TM1 MDX

Post Reply
sachinvpatil26
Posts: 3
Joined: Mon Jul 30, 2018 8:53 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

CELL PROPERTIES in TM1 MDX

Post by sachinvpatil26 »

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
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: CELL PROPERTIES in TM1 MDX

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
Post Reply