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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SAP HANA calculation view as OLAP data source for Cognos 11

Started by GiovannniLucarelli, 13 Nov 2017 10:05:59 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