Cognos Analytics

 View Only

  • 1.  Cannot see object tables and views for data modules

    Posted Sun December 15, 2019 05:33 AM
    Hi,

    What is the trigger to be able show/select table/view objects within Data Server from CA ?

    I have created a data-source to DB2 with the 'Allow web-based modeling' enabled.
    Creating a Framework Model and importing / testing / running objects is going fine.
    Trying to create a Data Module based on the same Data Source, the data source is shown in the Data Server list, but when i select the data Source, I can't see any tables/ views.

    What step am I missing  ?

    Found one post from IBM with the same issue for Oracle.
    But I have the DB2 jar file(s) in the ../driver directory, so that should be fine ?

    Thanks.

    IBM Cognos analytics 11 - cannot see object tables and views for data modules






    ------------------------------
    Chris Bos
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cannot see object tables and views for data modules

    Posted Mon December 16, 2019 12:20 AM
    Hi Chris

    Have you loaded the Metadata from the menu Manage - Data server connections?

    /JB

    ------------------------------
    Jesper Bjerre
    ------------------------------

    Original Message


  • 3.  RE: Cannot see object tables and views for data modules

    Posted Mon December 16, 2019 12:21 AM
    Hi Chris

    Are you able to see the Scemas in the Manage data connection sections? And have you loaded the metadata for the schema?

    /JB

    ------------------------------
    Jesper Bjerre
    ------------------------------

    Original Message


  • 4.  RE: Cannot see object tables and views for data modules

    Posted Mon December 16, 2019 04:56 AM

    The fact that you mention setting the allow web-based modelling suggests that you created the data source connection in the administration console rather than the new data server connection UI.   You will need to go into it and load the schemas that you want.



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

    Original Message


  • 5.  RE: Cannot see object tables and views for data modules

    Posted Mon December 16, 2019 07:09 AM
    Hi All,

    That was indeed the issue....
    I didn't know you had to load the metadata...….. 

    Right now it's working, thanks all.

    Chris

    ------------------------------
    Chris Bos
    ------------------------------

    Original Message