Reports 2.0 Record retrieval limits compromising pivots
CS Reports & Dashboards
I have a report on an MDA table where I am looking to summarize data by quarter and pivot on that column
So these columns:
Product name
Client
Q1 2015 (date column pivoted and summarized by quarter to display Sum of Usage)
Q2 2015 (ditto)
Q3 2015 (ditto)
Q4 2015 (ditto)
Q1 2016 (ditto)
Q2 2016 (ditto)
The source table has millions of records in it as it stores daily usage records for each Product against each Client for each individual user
However when pivoted the table is incomplete because there is a limit on the number of records retrieved before it is summarised in the table.
This is then misleading as it shows that Client X's usage of Product Y stopped in Q3 2015 - not because there is no usage but because records after Q3 2015 were not retrieved in the first place
If I output to Excel/CSV I do get Usage for Q4-2015 onwards but would rather not have to train users to "always export"
I could potentially create new MDA objects where the base data is preaggregated to reduce the record count but there are maintenance complications around that.
I understand potential performance concerns but are there any plans to increase/remove the record retrieval limit ?
Thanks
So these columns:
Product name
Client
Q1 2015 (date column pivoted and summarized by quarter to display Sum of Usage)
Q2 2015 (ditto)
Q3 2015 (ditto)
Q4 2015 (ditto)
Q1 2016 (ditto)
Q2 2016 (ditto)
The source table has millions of records in it as it stores daily usage records for each Product against each Client for each individual user
However when pivoted the table is incomplete because there is a limit on the number of records retrieved before it is summarised in the table.
This is then misleading as it shows that Client X's usage of Product Y stopped in Q3 2015 - not because there is no usage but because records after Q3 2015 were not retrieved in the first place
If I output to Excel/CSV I do get Usage for Q4-2015 onwards but would rather not have to train users to "always export"
I could potentially create new MDA objects where the base data is preaggregated to reduce the record count but there are maintenance complications around that.
I understand potential performance concerns but are there any plans to increase/remove the record retrieval limit ?
Thanks
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Thanks for reaching out.
On our org we have 2 large MDA tables
Usage Data Details - giving total usage by user by day since Jan 1 2014 with 2.9mn records
System Usage by Search Type - breaking that user usage down by "System" or Product for the same time period which has 9.1 mn records in it
Its broken down like this to give the granular reporting where needed but also so we can easily aggregate and report by company, week, month, quarter etc
I could perform an archive of 2014 data, and/or create pre-aggregated tables to the summary reporting levels but aside from the maintenance overhead there would still be over whatever your current limits are I think of 100k or 200k for retrieval
Two other things to be aware of are:
Best regards
Ian
Coming back to this rather belatedly but do you have any availability next week Wed or Thurs 9-11 BST ? I'm in the UK
Ian
Previously, pivot on reports used to happen on the UI (on the already presented data). But, with this enhancement, Admins can now pivot reports on the entire dataset from the server-side.
Note: The maximum number of pivoted columns visible in a report are 53. In CSV exports, you can see the entire dataset without limits.
Please refer the release notes for more information.
Thanks for posting!