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?