Comment not Considering in TM1 MDX Command
Posted: Mon Jan 07, 2019 8:32 am
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].[Alle Jahre], [Time].[2014], [Time].[2015], [Time].[2016]} ON COLUMNS,
/* Row Selection */ NON EMPTY { [Product].[All Products] } ON ROWS
/* Cube */ FROM [Sales] /*Comment*/
/*Background Selection */ WHERE ([Customer].[All Customers], [Currency].[Group Currency],[Category].[All Categories], [SalesOrg].[Pantara Holding], [Measure].[Margin2])
This works fine. However if we try to add below two lines then TM1 server gives the error
// My Comment
/* Column Selection */SELECT NON EMPTY { [Time].[Alle Jahre], [Time].[2014], [Time].[2015], [Time].[2016]} ON COLUMNS,
/* Row Selection */ NON EMPTY { [Product].[All Products] } ON ROWS
/* Cube */ FROM [Sales] /*Comment*/ /*Background Selection */ WHERE ([Customer].[All Customers], [Currency].[Group Currency],[Category].[All Categories], [SalesOrg].[Pantara Holding], [Measure].[Margin2])
// My Comment 1
-- My Comment 2
/* Column Selection */SELECT NON EMPTY { [Time].[Alle Jahre], [Time].[2014], [Time].[2015], [Time].[2016]} ON COLUMNS,
/* Row Selection */ NON EMPTY { [Product].[All Products] } ON ROWS /* Cube */ FROM [Sales] /*Comment*/
/*Background Selection */ WHERE ([Customer].[All Customers], [Currency].[Group Currency],[Category].[All Categories], [SalesOrg].[Pantara Holding], [Measure].[Margin2])
TM1 gives the error for above two MDX Statement.
Can you please suggest if the comments style "--" and "//" works with TM1 in MDX?
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].[Alle Jahre], [Time].[2014], [Time].[2015], [Time].[2016]} ON COLUMNS,
/* Row Selection */ NON EMPTY { [Product].[All Products] } ON ROWS
/* Cube */ FROM [Sales] /*Comment*/
/*Background Selection */ WHERE ([Customer].[All Customers], [Currency].[Group Currency],[Category].[All Categories], [SalesOrg].[Pantara Holding], [Measure].[Margin2])
This works fine. However if we try to add below two lines then TM1 server gives the error
// My Comment
/* Column Selection */SELECT NON EMPTY { [Time].[Alle Jahre], [Time].[2014], [Time].[2015], [Time].[2016]} ON COLUMNS,
/* Row Selection */ NON EMPTY { [Product].[All Products] } ON ROWS
/* Cube */ FROM [Sales] /*Comment*/ /*Background Selection */ WHERE ([Customer].[All Customers], [Currency].[Group Currency],[Category].[All Categories], [SalesOrg].[Pantara Holding], [Measure].[Margin2])
// My Comment 1
-- My Comment 2
/* Column Selection */SELECT NON EMPTY { [Time].[Alle Jahre], [Time].[2014], [Time].[2015], [Time].[2016]} ON COLUMNS,
/* Row Selection */ NON EMPTY { [Product].[All Products] } ON ROWS /* Cube */ FROM [Sales] /*Comment*/
/*Background Selection */ WHERE ([Customer].[All Customers], [Currency].[Group Currency],[Category].[All Categories], [SalesOrg].[Pantara Holding], [Measure].[Margin2])
TM1 gives the error for above two MDX Statement.
Can you please suggest if the comments style "--" and "//" works with TM1 in MDX?