How to find data Type of Cell in TM1 MDX

[sachinvpatil26]

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

[lotsaram]

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.

The cell type in TM1 cubes is determined by the element type of the last dimension in the cube (typically the "measure" dimension). If the element type is "S" then the data is string, if the element type is "N" or "C" then the data is numeric.