Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Integration with Microsoft Office

    Posted Wed June 19, 2019 09:21 AM
    Hi guys, I have two doubts

    First, I discovered these days the IBM Planning Analytics, so what the diference beetween Cognos Analytics and Planning Analytics?

    Second, can I integrate Cognos Analytics 11.1 with Microsoft Excel? If yes, how I can do it?

    Thak you.


    ------------------------------
    Diego Rodrigues Lima
    Mainframe Capacity & Performance - Technical Support Specialist
    São Paulo - Brazil
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Integration with Microsoft Office

    Posted Wed June 19, 2019 02:32 PM
    Hi Diego, 
    The answer for your first question is associated with the Analytics Cycle. The Analytics Cycle try to answer five questions about the data that the companies have. Planning Analytics is the solution for the first stage of the cycle answering the question "What is our plan?" this stage is focused on future, building plans, budgets and forecasts. Cognos Analytics answer the second question of the cycle "What happened?" at this stage we build reports, dashboards and try to monitor our data with trust. Cognos and Planning can integrate each other with no problem, some tech professionals like to call them brothers.

    About your second question. Yes, you can integrate both, the name of this feature is CAFE (Cognos Analytics for Excel), you have to install it at your environment and after you do that, you'll see a new tab in your Excel named IBM Cognos.

    ------------------------------
    Gabriel Bonpam
    ------------------------------



  • 3.  RE: Integration with Microsoft Office

    Posted Wed June 19, 2019 02:32 PM
    Hi Diego, 
    The answer for your first question is associated with the Analytics Cycle. The Analytics Cycle try to answer five questions about the data that the companies have. Planning Analytics is the solution for the first stage of the cycle answering the question "What is our plan?" this stage is focused on future, building plans, budgets and forecasts. Cognos Analytics answer the second question of the cycle "What happened?" at this stage we build reports, dashboards and try to monitor our data with trust. Cognos and Planning can integrate each other with no problem, some tech professionals like to call them brothers.

    About your second question. Yes, you can integrate both, the name of this feature is CAFE (Cognos Analytics for Excel), you have to install it at your environment and after you do that, you'll see a new tab in your Excel named IBM Cognos.

    ------------------------------
    Gabriel Bonpam
    Data & AI Tech Sales
    gabriel.bonpam@ibm.com
    ------------------------------



  • 4.  RE: Integration with Microsoft Office

    Posted Wed June 19, 2019 04:15 PM
    Hi Gabriel,  

    I'll research about this Analytics Cycle, I never heard about this. Do you know where I can find the tutorial to install the CAFE?

    Thank you for the answers.

    ------------------------------
    Diego Rodrigues
    Technical Support Specialist
    São Paulo - Brazil
    ------------------------------



  • 5.  RE: Integration with Microsoft Office

    Posted Wed June 19, 2019 05:11 PM
      |   view attached
    Check the upload file at this comment and you'll see how the analytics cycle looks like.

    Here you could find an explanation about the installation process of Cognos Analytics for Excel.
    https://www.youtube.com/watch?v=N9BYwaTrvPw

    Regards,

    ------------------------------
    Gabriel Bonpam
    ------------------------------



  • 6.  RE: Integration with Microsoft Office

    Posted Fri June 21, 2019 11:58 AM
    Edited by System Admin Fri January 20, 2023 04:44 PM
    Thank you very much for the information.

    ------------------------------
    Diego Rodrigues
    Technical Support Specialist
    São Paulo - Brazil
    ------------------------------



  • 7.  RE: Integration with Microsoft Office

    Posted Fri June 21, 2019 05:21 PM
    I tried to install CAFE, but in the vídeo appears the Welcome Kit, I don't know what is this. 

    1. Go to the location where the installation files were downloaded. The Welcome page appears in a new window.

    I use Cognos Analytics 11.1 cloud version, I don't know if is possible to use CAFE in this case.


    ------------------------------
    Diego Rodrigues
    Technical Support Specialist
    São Paulo - Brazil
    ------------------------------