Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Data is mismatching when compared the current qtr vs next qtr ABR data in financial report in OBIEE
Hi Team,
When i select the year as 2018 and Quarter Q4 then current Qtr and Current Qtr Vs Next Qtr (ABR) values are not matching in below report but it is matching for all the Quarters but in case of quarters across years like 2018 Q4 and 2019 Q1 it is not giving the results as expected.
Could anyone provide me the inputs/suggestions only in this case.
Answers
-
You do not say; -
Your version of OBIEE
What your time dimension looks like in the subject area in question?
What logic you are using in answers to get the Current versus Next Qtr?
The more information you tell people on the boards the more chance you have of getting a useful answer.
Please give this a read; -
0 -
Please follow my comments as inline below
Your version of OBIEE - 12.2.1.3.0
What your time dimension looks like in the subject area in question?- Are you asking me about Time Dim structure?
What logic you are using in answers to get the Current versus Next Qtr?-Logic as below
0 -
Yes he is asking about your time dimension.
And looking at your formula makes me ask one single question: Are you purposefully ignoring the out-of-the-box functionality of time series? Why such a convoluted and complex formula instead of just a "Quarter AGO" measures?
0 -
Hi,
Really?! Yuk!!
Okay, one do yourself a favor and do this with a well formed time dimension then you can easily have Quarter Ago, Next Quarter functionality etc using Time Series functions.
Also split your logic down so you are not doing all of the heavy lifting in your analysis - i.e. create specialist measure for whatever type flag in F,B,A etc
Finally, if you must do it like this then isn't your Fiscal Year part of the filter logic the problem - I only see 2018 going in, there is no 2019 logic when the year wraps - i.e. there is no quarter 5 you need some kind of case logic to achieve it, but better as I said is to step back and do it right, then it works not just for this analysis but for the benefit of all users of your subject area in a much simpler manner.
0 -
Time Dimension structure is as below
\
We are not purposefully ignoring the out-of-the-box functionality of time series.But we are storing the Forecast,Actual,Budget,ABR,FBR data in one table.so if we want get the data we have to write complex formula as per revenue forecast dashboard functional design.
0 -
That's not the "sturcture". Those are the "columns".
How is the heirarchy built?
Is it a real time hierarhcy?
Do you have correct (CORRECT!) unique keys at all levels?
etc. etc. etc.
0 -
Thanks for stepping in - I lost the will to live when it was not what I asked for and does not even have business friendly names and all the keys were exposed....
0 -
The naming is godawful and I'd have rejected an RPD like that from the start and none of my clients would have been willing to pay a single cent for such a delivered "result".
The analytics world has a horrendous quality issue.
0 -
Amen to that, I hear you brother!
0 -
Yes .Its a real time hierarchy and its having unique key at all levels.
0