Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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.
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
