Blank fields displaying wrong in Excel using MDX

[patrickbachmann]

Hi folks,

We have a view that, when consumed in Excel via MDX connection, if there is a blank field instead of it appearing as blank or empty it appears like this;

[FieldName].[FieldName].&[]

In other words if the field name is KOSTL and there's a blank value it will appear like this in the excel cell;

[KOSTL].[KOSTL].&[]

Has anybody experienced this problem?  The HANA db is 55 as well as the excel client drivers.

Thanks,

-Patrick

[lbreddemann]

Hi Patrick,

what sort of blank value are you referring to?

NULL-blank?

Empty-String-blank?

Space-blank?

Did you enable the ODBO-driver tracing?

If so, you should have the complete MDX statement.

Have you tried running it in HANA Studio SQL editor? (works if the return structure is a table).

- Lars