Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

dynamic cals in the dashboard.

Received Response
1
Views
4
Comments
3193829
3193829 Rank 5 - Community Champion
edited Aug 13, 2024 6:17PM in Oracle Analytics Cloud and Server

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

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    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,

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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...

  • SPowell42
    SPowell42 Rank 5 - Community Champion

    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

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Yes cristhian is right, sorry i forgot about the Request Variables,