Cognos Analytics

 View Only

Setting up a Data Source in IBM CA 11.2.0 to Oracle EPM Cloud Hyperion Cube

  • 1.  Setting up a Data Source in IBM CA 11.2.0 to Oracle EPM Cloud Hyperion Cube

    Posted Thu March 16, 2023 06:06 PM

    We have a business user requirement to report the data in Cognos Analytics 11.2.0 from the Data Source on Oracle EPM Cloud based on the Hyperion Cubes developed within the Oracle EPM Cloud environment. I would like to know whether creating a Cognos report out of Oracle EPM Cloud Hyperion Cube as the Data Source is possible.  If so, please let me know the steps to achieve that. What parameters are required to establish the data source to Hyperion Cubes sitting in Oracle EPM Cloud? We have the URL and the credentials to access that cube thru the Oracle EPM Cloud Web Portal. But the requirement is to create a report from the data in those Hyperion Cubes available in the Oracle EPM cloud environment and show it in Cognos Reports. Please let me know your thoughts on this. 

    Appreciate your help on this in advance. 

    Thank you.

    Ram



    ------------------------------
    Athmaram Shankaranarayana
    ------------------------------