Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

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

    Posted 12/15/19 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 12/16/19 12:20 AM
    Hi Chris

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

    /JB

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



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

    Posted 12/16/19 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
    ------------------------------



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

    Posted 12/16/19 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
    ------------------------------



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

    Posted 12/16/19 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


Related Content