Cognos Analytics

 View Only
  • 1.  Types of Source- Automation

    Posted Thu April 22, 2021 09:59 AM
    Hi,
    in the most demos/videos that I see the type of the source are .csv or .xls and are uploaded to Cognos Analytics.
    How can it be made in a automatic way in CA?
    How do you work daily in your projects: csv/exl files/data server?.

    Thanks.


    ------------------------------
    Eliseo Marcelo Zabala Aleman
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Types of Source- Automation

    IBM Champion
    Posted Thu April 22, 2021 01:42 PM

    In our data environment all external file uploads are deactivated. None of the CA users has the ability to upload data into the system. Instead we use a centralized data warehouse which covers all needed data of all subsidiaries. It also includes a consolidation mart where measures are unified into the company currency etc.

    The process behind this DWH is an ETL system which loads the data daily into the system. Monday to Saturday it's a delta load and each Sunday we load all data fresh into the system. We also integrate external files into the DWH via the ETL processes, but only a very few users can edit those files in the shared directory where the ETL process pulls the data from.

    Works perfectly and this consistent DWH has saved us lots of time in other projects where we rely on accurate data.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 3.  RE: Types of Source- Automation

    Posted Thu April 22, 2021 02:10 PM
    Hi,
    Robert thank you very much for your response! 

    Marcelo.


    ------------------------------
    Eliseo Marcelo Zabala Aleman
    ------------------------------