Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
dynamic cals in the dashboard.
Hi,
I need to caluculate some metrics, based on the date user selects on the dashboard. I am doing this with presentation variables but the performance is not good.can this be done in using anyother way like with session variables/request variables.sending the data back to rpd etc. if so, please provide me the pointers to the right document.
Regards,
K
Answers
-
Hello,
Based on the select of the user you have an only way which is Presentation variables, what is so low in perfomance way, maybe you could use an EVALUATE FUNCTION, and create your custom function to make all the logical calculated in the database, it could improve in the performance.
Kind Regards,
0 -
Yes. Request variables + RPD is definitely a more proper way to go since you create reusable objects rather than hacking things in the presentation catalog.
So basically presentation variables are NOT the only way you have...
0 -
I'm not sure I understand the issue. Would you not simply create the metrics in the RPD, and then display them on the dashboard? And whatever date the user picks, the metrics would automatically calculate? Feel like I'm missing something.
Thanks,
Scott
0 -
Yes cristhian is right, sorry i forgot about the Request Variables,
0