Cognos Analytics

 View Only
  • 1.  How to download uploaded xls file

    Posted Tue April 28, 2020 04:40 AM
    Hi,

    Last year I have uploaded excel file and created Data module. Now I need that original .xls file, since I do not have it. Where I can find it on Cognos Anlytics and how to downloaded to desktop PC.

    Thanks.


    ------------------------------
    Veljko
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: How to download uploaded xls file

    Posted Tue April 28, 2020 05:36 AM

    This is a modified version of a response to an earlier, similar question.

    Method to recover the xls.

    1.  Create a module with the file.
    2.  Select the module and choose Create report from the context menu.
    3.  Create a list report.
    4.  Click on the run options button and choose run Excel.

    Data governance aspects 

    One very important best practice for working with files as a data source would be to put the files into a source control environment.   This will allow you to track what changes have taken place and to recover prior versions.  

    This, obviously, is helpful in cases like this but also will enable you prove to auditors etc. that you have that aspect of a data management system.

    In general, I am concerned about people  working with files as data sources without having a data management system in place.

    https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=03f3e641-f123-42d9-86f8-e1245fcb26aa&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer#bm03f3e641-f123-42d9-86f8-e1245fcb26aa



    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 3.  RE: How to download uploaded xls file

    Posted Tue April 28, 2020 06:22 AM
    @IAN HENDERSON Thank you for help.​​

    ------------------------------
    Veljko
    ------------------------------