Search found 3 matches
- Mon Jan 07, 2019 8:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CELL PROPERTIES in TM1 MDX
- Replies: 1
- Views: 1594
CELL PROPERTIES in TM1 MDX
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 ...
- Mon Jan 07, 2019 8:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Comment not Considering in TM1 MDX Command
- Replies: 1
- Views: 1677
Comment not Considering in TM1 MDX Command
PLEASE POST IN THE CORRECT FORUM Dear Experts, We have a tool for executing the MDX queries. We observed that the comments styles "//" and "--" not working. The /*TEXT */ comment is working fine. Here are the sample exapmples /* Column Selection */ SELECT NON EMPTY { [Time].[All...
- Mon Jul 30, 2018 11:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to find data Type of Cell in TM1 MDX
- Replies: 1
- Views: 1742
How to find data Type of Cell in TM1 MDX
Hello Experts, We are executing the below MDX command on TM1. MDX=SELECT NON EMPTY { } ON COLUMNS, NON EMPTY { } ON ROWS FROM [ SalesCube ] WHERE ( [actvsbud].[actvsbud].[Variance] ,World ,[model].[model].[L Series 2WD] ,[account1].[account1].[Gross Margin%] ,[month].[month].[Year] ) This MDX comman...