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 ...

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...

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...