Limited to first 10 pages RRS feed

  • Question

  • Hello,

    When I do the "show details" from analytic grid, it would only return the first 10 pages. Can we increase so that it would show the first 15 or 20 pages? Thanks!

    Wednesday, August 12, 2009 11:30 PM

All replies

  • You will need to go into the Server Options and set the Row Limit for OLAP "Show Details" (Small) to a number like 1500 for 15 pages or 2000 for 20 pages (100 records per page).  The default is 1000, so you only get the first 10 pages.  Now on the export if you want to go more than 10000 records you will need to also modify the Row Limit for OLAP "Show Details" (Large) to an appropriate number.

    You can make this change through Dashboard Designer once you are connected to the server if you have the appropriate permissions.  You could modify the Value in the Settings table in the PPSMonitoring database too.  Once you do this you will need to recylce the Application Pool to make the change occur and be visible in the web site.

    Dan English's BI Blog
    Please mark posts as answer or helpful when they are.
    Thursday, August 13, 2009 4:57 PM