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.  Source Metadata Not Available when Editing Reports

    Posted 08/29/19 09:55 AM
    A user recently reported that metadata was not available when editing a report in Cognos Connection (v11.0.13.1). The report is still correctly running, but there is no availability to add in new items from the original source data when editing. This message appears for all users including administrators. The images attached show the Metadata not available message and the data tab where the current report items are still available. We have a temp workaround where we can add a new query and use SQL to pull in data, but we'd like to know if anyone else has had this issue, how it was resolved, and causes if known. 

    Additional info:
    Windows server & Cognos services were restarted after issue reported with no change.
    No known changes to the source tables/data.
    No changes to server or Cognos configuration.
    Have not attempted to re-publish FM packages in production.
    Development server is not having same issues on identified reports/packages. However, a new package was published today and the admin who published can see source metadata as expected. The other admin gets the Metadata not available message when attempting to create a new report on the new package. Both admin user access is the same and model security is set to Full for these users. 


    #CognosAnalyticswithWatson


  • 2.  RE: Source Metadata Not Available when Editing Reports

    Posted 08/29/19 10:44 AM
    Have you attempted to create a new report from the existing Package?

    ------------------------------
    NORBERT Bracke
    ------------------------------



  • 3.  RE: Source Metadata Not Available when Editing Reports

    Posted 08/29/19 11:59 AM
    Yes - great point that I left out. New reports from the package also provide the same Metadata not available message.

    ------------------------------
    Sunny Padgett
    ------------------------------

    Original Message


  • 4.  RE: Source Metadata Not Available when Editing Reports

    Posted 08/29/19 03:16 PM
    Could you try taking a copy of the package and see if the copy works?

    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Original Message


  • 5.  RE: Source Metadata Not Available when Editing Reports

    Posted 08/30/19 03:32 AM
    Hi,
       I have a message out there too regarding this problem.  I can duplicate exactly, as you stated, however, if I build a new package, with the same meta data with different name, it works fine. If I attempt to modify the package that is having problem, and republish it, still get same message.  This is only in reporting, everything else works fine, I can even enhance the package.  HELP!!​

    ------------------------------
    Kurt Blevins
    ------------------------------



  • 6.  RE: Source Metadata Not Available when Editing Reports

    Posted 11/18/19 11:34 AM

    Good morning Kurt, 

    Some users are experiencing the same issue with New Reports.  We are on (11.0.13.1).  Others can duplicate the issue but I have no problems on my workstation.  Even different users using my workstation do not have the issue.  

    The workaround I found for others is here: 

    https://www-01.ibm.com/support/docview.wss?uid=swg1PI89033



    ------------------------------
    Joseph Bankston
    ------------------------------

    Original Message


  • 7.  RE: Source Metadata Not Available when Editing Reports

    Posted 11/22/19 01:18 PM
    try Save to my content & see if you are able to link /re import package ?

    report is upgraded ?

    Thanks
    Veera

    ------------------------------
    Veera Kamma
    ------------------------------



Related Content