How to find data Type of Cell in TM1 MDX
Posted: Mon Jul 30, 2018 11:28 am
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 command executed properly and returns one value as Value=68.765816621745813
However it might happen that the MDX command will be updated to sent the String values as well.
How we can identify the data type ( String / Double ) of the specific cell from the Cells. We build our application using C++ and OData Client library.
Thanks and Regards,
Sachin
Please post in the correct forum
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 command executed properly and returns one value as Value=68.765816621745813
However it might happen that the MDX command will be updated to sent the String values as well.
How we can identify the data type ( String / Double ) of the specific cell from the Cells. We build our application using C++ and OData Client library.
Thanks and Regards,
Sachin
Please post in the correct forum