asked on September 14, 2017
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 https://www.flexmonster.com/demos/js/connect-ssas/ 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.
⋅ 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
⋅ 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.
⋅ 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
