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.  Not able to create new report.

    Posted 07/29/20 01:21 AM
    Hi All

     I am trying to create a report, but getting below error. Please let me know what needs to be done. Out of the same data module I have other reports which are working perfectly fine. 






    Thanks & Regards
    Mona Kedia
    GTS-Business Operations
    IBM India Pvt Limited,
    # 12 , Subramanya Arcade - 1,
    Block B, Bannerghatta Main Road,
    Bangalore - 560 029

    Handphone-+91 9916256765      
    E-mail ID - monakedi@in.ibm.com


    #CognosAnalyticswithWatson


  • 2.  RE: Not able to create new report.

    Posted 07/29/20 07:11 AM

    This is a governor set on your report, not in the module. 

    Whoever created your report has set the value for the maximum rows retrieved property to be 5000.

    You would need to contact him and a decision needs to be reached as to whether the limit is appropriate.

    Each report consists of 1 or more queries.

    Each query has properties. One property set is query hints. One of the properties of it is maximum rows retrieved. By default, it is not given a value. This means that there are no limits about how many rows are retrieved. If a value is entered then the query engine will attempt to prevent the report from rendering when rows over the limit are retrieved, as you have seen.



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