Cognos Analytics

 View Only
  • 1.  Data server connection not showing all tables

    Posted Mon August 19, 2019 10:03 AM
    I have a data server connection with 23 tables loaded but when I try to use the connection as a data source only 2 of the tables show up. This worked to start with but once I tried to add more tables to the connection others disappeared.

    To add tables to the connection I use Data server connections > Connections > Schemas > Load metadata (for the schema in question) > Load options > Tables.

    Is there a different way to accomplish this or am I doing something wrong?



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

    #CognosAnalyticswithWatson


  • 2.  RE: Data server connection not showing all tables

    Posted Mon August 19, 2019 10:15 AM
    Hi Dagur,
    When you select tables, only those will be imported/refreshed. The action is not additive.
    Thus if the first time you select tables A, B and then later want to add tables C and D then you would need to select A,B,C,D.
    If that is the way you did things and it doesn't work, then there is an issue that needs to be logged.
    Best regards,
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Data server connection not showing all tables

    Posted Tue August 20, 2019 05:35 AM
    Hi Henk,
    I ended up loading the entire metadata (over 800 tables) then all tables became available in the data server connection.
    Having to pick a long list of tables every time you need to add one does not seems right.
    If we only want a part of the tables to be available through the data server connection is there another way?

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