Display currency in same column as key figure in Analysis for Office

[martin_chambers]

Hi,

We are using BW powered by HANA 7.5 SP 05 and Analysis for Office 2.4.

I want to display the currency in the same column as the key figure.

In the Eclipse query designer I have one characteristic in a row and one key figure in a column. I have 3 data records, two with currency = EUR and one with currency = GBP.

When both key figure values are 0, Analysis for Office Show two lines of data, one with EUR and one with GBP with the currency displayed in the same column next to the key figure. This is just what I want.

When the key figure for Euro is Changed to 10 and the GBP value remains 0 something strange happens.

The currency EUR is displayed in the column header.

Does anyone know how to prevent this display change. Any help will be appreciated.

[martin_chambers · Accepted solution]

I have found out that the setting for hiding or displaying the scaling factor can be made directly in Analysis for Office.

Select a crosstab cell Measures --> Show scaling factor.

Deactivating it in AfO gave the desired results. It seems the BEx Query settings are ignored in AfO.