Hi guys, someone knows if it is possible use SAP HANA calculation view as OLAP data source for Cognos 11? better... Currently, in my case Cognos queries Hana Views via standard SQL. Therefore, Hana views are seen as linear relational tables. What we would like to do is to enable Cognos querying the same views, but treating them as multidimensional cubes rather than plain tables. Instead of using SQL it would use MDX, as it must do in querying multidimensional structures. In this way, the current MDX procedures, implemented in Microsoft analysis service cubes, would be transferred directly to Cognos, and the global architecture would stay the same, without the addition of other tools.
Best regards
There is no support of MDX to SAP Hana only SQL.
Thanks. Do u think there is a way to achive this result using Dynamic Cube? Regards
Dynamic Cubes is a dimensional model/engine that sits on top of Dynamic Query. Hence, while it offers a dimensional engine etc, it uses SQL and not MDX to source data.