Cognos Analytics

 View Only
  • 1.  Upgrade CAFE models from Cognos 10 to Cognos Analytics

    Posted Wed May 08, 2019 12:27 PM
    Is there a way to upgrade CAFE models from Cognos 10 to Cognos Analytics?
    We have a numbers of models with explorations built on a connetion to Cognos 10. Now with an upgrade to Cognos Analytics we would like to change the system reference to the new version so we don't need to redo all the models.

    ------------------------------
    Dagur Egonsson
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Upgrade CAFE models from Cognos 10 to Cognos Analytics

    Posted Wed May 08, 2019 03:34 PM
    ​hi,

    you can refer the below ibm link as first point

    https://www-01.ibm.com/support/docview.wss?uid=swg22015168

    ------------------------------
    Babu Periassamy
    ------------------------------



  • 3.  RE: Upgrade CAFE models from Cognos 10 to Cognos Analytics

    Posted Thu May 09, 2019 05:39 AM
    We are able to use CAFE with Cognos Analytics that is confirmed but would like to update the Excel model and connect to a different Cognos System.

    ------------------------------
    Dagur Egonsson
    ------------------------------



  • 4.  RE: Upgrade CAFE models from Cognos 10 to Cognos Analytics

    Posted Thu May 09, 2019 12:39 PM
    ​If your models use cell-based then it's easy to do a search and replace to change all the references. There is also a utility in the CAFE Options section that changes all the connection references for you.  Assuming the cube folder structure is the same as it was in the prior system then that is all you need to do.  If the cube location structure is different then you'll need to do the separate search/replace on the cube source too. 
    If you are using crosstab models then your only option is to rebuild the crosstabs as there is no utility available to change these pointers.  Crosstab models have all the connection information hidden within the workbook which makes it impossible to edit.
    Good luck.

    ------------------------------
    Scott Taylor
    Cognos Administrator
    Chelan County PUD
    Wenatchee WA
    ------------------------------



  • 5.  RE: Upgrade CAFE models from Cognos 10 to Cognos Analytics

    Posted Thu May 09, 2019 12:44 PM
    Thanks. We will work with this.

    ------------------------------
    Dagur Egonsson
    ------------------------------