Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Year to Date and Previous year to date calculations
Hi All,
Oracle Business Intelligence 12.2.1.3.0
I have time dimension from Year --> Quarter --> Month --> date
Sale and target for the current year to date is working fine but Previous year to date are not working I have tried multiple formula functions including google search but fail
anyone please help me
regards
Answers
-
Hi,
What does "not working" mean? Do you have an error? Do you have no value? Do you have a number you don't like?
What are the formulas you tried already?
In case you had numbers back, where did that number came from? Isn't it that the formulas worked as expected but you wanted some other numbers (meaning that you don't really look for a standard to-date calculation) ?
0 -
Dear @Gianni Ceresa ,
No value return
Two methods used, both fail, Used the following functions
---> Method# 1
Fig.1, Applied filter in OBIEE where pV_year is equal to prompt selected year--- actually I wanted to show target of current year and target of the previous year for the same product
Method # 2
Fig.2, To get the first date of the last year
Fig.3, used below function to get the last year same date
Fig.4, Used Between filter in OBIEE
0 -
Dear @Gianni Ceresa
Can you please suggest the solution?
0 -
My suggestion would be to extend your time dimension and add 2 attributes to hold these first date last year and the same date last year values values. This should make your calculation a bit simpler.
0