OBIEE 11g analysis has query performance option to "Share query with multiple users" that improves performance after initial run. This option comes handy for reports that are used in the dashboard.
To enable this option, go to:
1. Analysis' Advanced tab
2. In the bottom of the page select "Share query with multiple users (may improve performance after initial run)
3. Click "Apply" and save your analysis.
Thank you for the feedback!
ReplyDeleteGood stuff Alex! Keep up the good work! =)
ReplyDeleteInteresting. Are there any good reasons to not share? I have a dashboard with approximately 20 analyses throughout...and I would like to enable this feature, but I am concerned it would perhaps have some drawbacks. Have you experienced any?
ReplyDeleteNot sure if it has any drawbacks, but I have noticed a slight improvement especially when you have multiple reports/analysis in the dashboard.
ReplyDeleteThe default option is set NOT TO SHARE.