Hi,
I’ve created a Generic Inquiry titled “Project (Cost & Revenue),” and it runs smoothly. However, the pivot table takes a considerable amount of time to load.
Could anyone provide insights or assistance on how to improve the performance of the pivot table? I’ve attached the GI and pivot table XML for your reference.
Thanks
Best answer by pankaj65
Hi
Yes, I was able to find a solution to the issue.
I grouped the GI by project, project task, and the financial period of the project transaction, which reduced the number of transactions in the GI result grid. This resolved the issue with the pivot table loading.
Thank you.
Hi,
I’d like to highlight that I’ve created an attribute called PROJTYPE in the project screen and mapped in the generic inquiry screen.
+15How many records are outputted in the GI. We have seen this if the record count is large the pivot table can be very slow.
Hi
Thanks for your reply. records are around 40k. but GI is loading within few seconds. however, pivot is taking considerable amount to load.
Thanks 😐
+8
Hi
Hi
Yes, I was able to find a solution to the issue.
I grouped the GI by project, project task, and the financial period of the project transaction, which reduced the number of transactions in the GI result grid. This resolved the issue with the pivot table loading.
Thank you.
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
