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
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
-
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
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.
0
Answers
-
HI @Billy Mak
Are you creating any report from FDI ? if yes are you using any Subject Area's to build the visualization report?
As per my understanding , you need to use the time series functions to calculate the values.
Regards,
Arjun
0