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