Oracle Communities

Oracle Analytics and AI

Child Item

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.

Find more posts tagged with

Accepted answers

All comments

Robert Angel

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; -

K H S Sudheer

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

[Deleted User]

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?

Robert Angel

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.

K H S Sudheer

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.

[Deleted User]

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.

Robert Angel

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....

[Deleted User]

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.

Robert Angel

Amen to that, I hear you brother!

K H S Sudheer

Yes .Its a real time hierarchy and its having unique key at all levels.