Skip to Content
Former Member
Jul 09, 2012 at 04:51 PM

Multiple options disabled in Advanced Analysis for Office using HANA as Source


Hi Everyone,

I believe everyone is having fun with SAP HANA. I guess if you want SPEED you have to go through GRIEF!!

Anyways jokes apart.

I have a question on Advanced Analysis for Office using SAP HANA as source.

I am trying to create a report on Advanced Analysis for Office using an Analytic view created on SAP HANA. I am able to access the Analytic view using the HANA connection but I can see many options like conditional formatting; Hierarchies; Ranking etc. are disabled in Advanced Analysis, but the same options are available while working with a BEx query. The only difference I am aware of is when going against BEx query we use OLAP/BICS connection and against HANA it is ODBC connection. Can this create such problems?

Has anyone faced this issue?

Any comments or suggestions will be greatly appreciated.