How does Quickview decide on page breaks?
I just had a call from an Excel user who uses the OneStream addin.
He has a number of reports that he's been using, but they're working differently today, and we don't know why. Instead of retrievi...
Forum Discussion
Please tell me more about how Maximum Number of Seconds affects the page breaks.
It seems unlikely that the problem rests with Maximum number of rows, unless I don't understand the concept. The entire report isn't very large and each page has less than 75 records retrieved. He tells me that this problem just started happening -- that just suddenly on Tuesday, the report he's been using began being split across multiple pages. I've asked for a copy of the report so I can compare it with the dimensional hierarchies and see if I can spot a pattern for page breaks in the data.
These are the 2 settings which impact Quick View Paging. If you search "Quick View Paging" in the reference guide it will go into detail on these 2 settings. You can get to a copy of the reference guide by clicking the "?" in the upper right corner when inside the application.
You can have him up the Maximum Number of Seconds on the QV settings. That should allow the server to process longer before it begins to page.
Also, make sure the user has Sparse Row Suppression as True, this should help with processing time depending on what how his Quick View is setup.