Cognos Analytics

 View Only
  • 1.  Not able to create new report.

    Posted Wed July 29, 2020 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 Wed July 29, 2020 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
    ------------------------------