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.