Menu
Download Free Trial

Report keeps loading

 Hello,
We are testing your component before buying. We have noticed an important issue. When we click on “Drill through”, the report keeps loading forever. The pop message shows: “Waiting for the response”. To reproduce this issue, go to this page http://www.flexmonster.com/demos/connect-msas/ and choose these fields:
Rows: Customer
Columns: Employee Department
Values: Internet Standard Product
When the report shows, choose a row and click “Drill through”.
 
Could you please give us more information about this issue? We would like to use it with high volume cube.
 
Thank you.
 

3 answers

Public
Ian Sadovy Flexmonster September 14, 2017

Hello Abdel,
 
Thank you for the question.
Actually, we are aware of some performance issues with drill through for specific slices.
The main cause of the issue that Analysis Services executes some DRILLTHROUGH queries very long.
We recommend you to try it with your specific data source. Also, there is an option to limit drill through result using drillthroughMaxRows property.

 
Please let us know if it helps.
 
Regards,
Ian

Public
Abdel Bens September 14, 2017

Hi,
Is there any other solution? Defaut max rows is 1000 which is a small number. We have high volume DB.
 
Thank you.

Public
Ian Sadovy Flexmonster September 14, 2017

Hello Abdel, 
 
I am afraid that there is no other solution.
We have tried to execute the same query in Excel (which is a more powerful desktop application) and saw the same result.
It seems that in this case the bottleneck is Analysis Services server and there is not much we can do as a client side component.
 
Please let me know if you have further questions.
 
Regards,
Ian

Please login or Register to Submit Answer