If you are unable to create a new account, please email support@bspsoftware.com

 

SAP HANA calculation view as OLAP data source for Cognos 11

Started by GiovannniLucarelli, 13 Nov 2017 10:02:32 AM

Previous topic - Next topic

GiovannniLucarelli

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

the6campbells


GiovannniLucarelli

Thanks. Do u think there is a way to achive this result using Dynamic Cube? Regards

the6campbells

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.