Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

prior year-to-date metric

Accepted answer
37
Views
2
Comments

Hi,

I'm trying put together a financial statement with one single visualization that has the following columns:

Current year Actuals, Current Year Original Budget, Current year Adjusted Budget, YTD Actuals + [Prior Year YTD Actual] + [Prior Year Full year Actuals]

The challenge that I run into is not being able to pull in prior year YTD Actual and Prior year Full Year Actuals. Would like to request [Prior Year] metrics

This will be best displayed in a pivot table format.

Anyone has success doing this?

Use Case and Business Need: To provide standard financial statement.

Best Answer

  • Rajesh L-Oracle
    Answer ✓

    Hi Billy,

    Please review following content for Prior Year comparison.

    https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/run-workshop?p210_wid=3258&session=100775537991511

    https://blogs.oracle.com/analytics/post/oracle-analytics-performance-tuning-times-series

    Times series functions Ago and Todate offer a simple way to create metrics to calculate year-ago, year-to-date, and so on, and this method works well for business user reports. However, these functions generate complex queries that have a significant cost on performance. Also, each time that one of these functions is used in a report, an additional sub-query is generated using even more resources on the database.

    Please note using AGO fution is not suggested for large data-size as it can have a performance impact.

Answers