Skip to Content
0
May 10, 2013 at 07:35 PM

Blank fields displaying wrong in Excel using MDX

22 Views

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