How to create Row Structure in HANA as we do in SAP BEx

[Former Member]

Hi Experts,

I would like to know how can we create row structure in HANA just like what we do in SAP BEx query designer for reporting purpose ?

Thanks & regards,

Jomy

[pradeep_gupta]

Hello Jomy,

Were you able to achieve this somehow ? If yes, can you please share some ideas.

Thanks,

Pradeep

[patrickbachmann]

You can do similarly by using excel MDX data connection.   First you need to download and install the HANA MDX Driver from SAP.  Then in excel choose DATA/FROM OTHER SOURCES/FROM DATA CONNECTION WIZARD/OTHER ADVANCED and choose HANA MDX Provider option.

-Patrick

[Former Member]

Hello Patrick,

Maybe I didnt get you completely.

a) My question was, in BEx, we used to create a predefined Row and Col structure especially for FI reports with some restrictions on some attribute liek G/L account and so on.

How can we replicate the same in HANA studio?

b) How can we emulate teh behavior of cell restrictions as we used to do in BEx Query Designer ?

Thanks & regards,

Jomy