How to display master data without transaction data in Query Designer in Hana Studio?

[Victor_Arroyo]

Hi,

I created an input query for my Rates infocube and I want to show all currencies so user can input and save rates, but when I execute the query it shows without columns/rows because infocube is without transactional data.

I know that in other version of Query Designer it exists the option to achieve this.

Thank you

[gregor_dieckmann · Accepted solution]

Hi,

the same setting 'Access Mode for Result Values' is also available in the BW Modeling Tools, you can set this in properties of a characteristic, expand the 'Extended' section.

Regards,

Gregor

[Victor_Arroyo]

Thank you Gregor.

I had to choose the option 'Toogle Full Screen' to see that option.

Thank you