Categories
OAC filter latency (Use as filter option)
Hello,
We have workbook with 8 canvases and on each canvas there are at-least 10 visualizations.
When only canvas1 is placed on the workbook, the clicking of visualization results in a quick response. All other visualizations in the canvas refreshes within 2 seconds. I click on a Map view for example (with 'Use as filter' enabled) to chose a french departement on map.
When there are multiple canvases placed on the workbook, the clicking of visualization results in a delayed response. The refresh of all other visualizations in the canvas takes more than 30 seconds
The Dataset for visualization is based on the subject area from the Semantic Model. The Connection pool was created with max connection 200. Connection pointing to a On-Prem database using a VPN tunnel.
Can you tell me why I have this delay only when I have multiple canvases on workbook? The canvases must be independants.
I clicked on Map only after all the data are loaded. Normally I must have the same response time in the two cases.
Thanks for help!
Daniel
Answers
-
Hi,
My suggestion is to analyze the .har file from browser and also verify below -
How To Enable The Developer Option To Analyze Query Performance For A Data Visualization Workbook [Video Content] (Doc ID 2831471.1)
Regards,
Arjun
0 -
Hello,
There could be many reasons for the slow performance. Here are some general guidelines that could help you scope the issue:
As a quick test, disable Brushing at system level in the OAC console and check if performance improves.
Brushing can be disabled globally in System Settings, in workbook properties, or at canvas level.
This feature is enabled by default and can have very high cost on performance, even when it is not used.
Regards,
Ezequiel.
0 -
Thanks Ezequiel for response.
I already know the link for the best practices, it's interesting. I even tried some tricks from the guide. Our case is a simple star schema with 3 dimensions.
For exemple because initially we had 2 calculated columns with a case statement in the semantic model, I tried to replace that using indexCol function to improve performance. But I think that web Semantic Modeler didn't appreciate indexCol function. The calcul was valid but on deploy I got a strange erreur(first parameter is not un integer, it was really 0, 1 or 2). I created finally a physical column to avoid the case. Have you used indexCol in the semantic model in a calculated column?
The first think I made was disable Brushing on systeme level in OAC. No changes for my case.
Regards,
Daniel
0 -
Disabling system functionality without understanding the root cause of an issue is never a good proposition.
It may help to hide some symptoms, but first of all the system should work as designed when used correctly and second of all the underlying root cause will still be there and will still be unresolved.
The key question is why does this happen.
1 -
@Gianni Ceresa - It is difficult in a public forum to ascertain that in 'some' cases.
For example, in the case, the original post never mentioned awareness of the best practice guidelines, troubleshooting steps, or that they already tried X, Y, Z steps. (i.e. disable brushing for comparison).
If you have any constructive helpful advice (as you usually do, thank you for all your contributions), can you please share it with the Daniel.
@User_9YNXK - Daniel, it would be great if you update your profile with your name/org, etc., so we can get to know you in the community.
Can you tell me why I have this delay only when I have multiple canvases on workbook?
Daniel, I am not exactly clear from the post if this is related to only map Viz's.
It would be helpful to understand the full context of what is affected, the filters, the workbook in action, view the contents, view the logs /HAR, other deeper dives.
Have you opened a service request? If not, I recommend that in this case since you were already aware of the basic first steps presented to you.
0 -
@SteveF-Oracle , well ... not sure what the mention is for: I'm not part of this thread. I will need some extra hints to guess how to read that...
0 -
@SteveF-Oracle This use case is already open as an SR as this issue was reported back in July of this year.
1 -
@Gianni Ceresa , apologies, meant Christian.
We all appreciate your contributions to the community, as well!
0 -
Presumption from my side: Daniel's here because the SR doesn't advance and he doesn't know whom to ask anymore.
As stated this is an open issue since July.
0 -
@Christian Berg - Thanks for the additional context.
Also, I believe you are an Oracle employee (perhaps not always the case), would you mind updating your profile indicating as such.
When there are multiple canvases placed on the workbook, the clicking of visualization results in a delayed response. The refresh of all other visualizations in the canvas takes more than 30 seconds
Canvases are independent, and only the queries on that canvas should be firing, so this does seem odd.
Thinking out loud, and not knowing all the actions in the SR, I wonder if this could be reproduced in the public demo environment, so that a DVA export or some other method of reproducing is possible. I don't think we can get to much into here, but I am surprised about the time (since July) that has passed. It does sound like a 'potential/possiblel' bug to me.
There are escalation paths, if the service request is not progressing.
Other comments, welcomed.
0
![[Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
