How to find data Type of Cell in TM1 MDX

Post Reply
sachinvpatil26
Posts: 1
Joined: Mon Jul 30, 2018 8:53 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

How to find data Type of Cell in TM1 MDX

Post by sachinvpatil26 » 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

lotsaram
MVP
Posts: 3126
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How to find data Type of Cell in TM1 MDX

Post by lotsaram » Tue Jul 31, 2018 12:32 pm

sachinvpatil26 wrote:
Mon Jul 30, 2018 11:28 am
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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply