Skip to Content
0
Mar 14, 2012 at 12:58 AM

How to use MDX in HANA Studio?

743 Views

I am having difficulty getting an MDX query in HANA studio to return results. I can fire an MDX query such as this

MDX SELECT {[MONTH].[MONTH].[All]} ON COLUMNS

FROM [FACT_DTD]

WHERE ([Measures].[AverageHc])

CELL PROPERTIES VALUE

But all it returns is a single cell with a GUID value.

Do I need to do something with this GUID value or does the MDX need to be written differently?