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
CELL PROPERTIES in TM1 MDX
-
- Posts: 3
- Joined: Mon Jul 30, 2018 8:53 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- 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
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.
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
www.infocat.co.uk