Forums Ignite UI for jQuery
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Arthur Butler
2035
igPivotGrid with large datasets
posted

I have an Excel app that I am attempting to convert to a web app using igPivotGrid.  There are 700,000 rows in the database table.  It seems that I need to send all the rows to the igPivotGrid and not just some subset based on the filtering that the user sets.  Is this true or am I missing something?  None of the examples that I found filter on the datasource.

Thanks,

Arthur

Parents
  • 23953
    Verified Answer
    Offline posted

    Hello Arthur,

     

    The igPivotGrid has two options to connect to data:

    1. Local data in JSON format
    2. Remote data that is requested from Microsoft® SQL Server Analysis Services (SSAS) server configured with the msmdpump.dll HTTP data provider

     

    Given the volume of data that you have the only option I can suggest is that you move your data to a Microsoft® SQL Server Analysis Services cube and request it from there.

     

    Best regards,
    Martin Pavlov
    Infragistics, Inc.

Reply Children
No Data