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
Answers
-
So if you create a new physical measure that contains all of the logic you had previously had, using case statements rather than function filters, then you can create a logical measure using the AGO functionality to get a prior quarter, and with AGO it will have no issue with going 2018 Q1 back to 2017 Q4.
https://gerardnico.com/dat/obiee/obis/logical_sql/function_time
0 -
Hi,
you can create AGO functionality in answers as well as in the repository, so if you need to do multiple period comparisons then you might want to just use the necessary syntax in answers.
What I was suggesting is that you might want to create a new measure for all of the non-time filtering that you were doing in answers, then you have an homogeneous measure that can be used by anyone in any report without the complexity of nesting X filters to get there.
I was also suggesting that you might also want to create one Quarter AGO (QAGO) measure that can also be utilised by anyone, its time frame would always be relative to the time frame of the row that it is in, so if you had;
2018Q1
2018Q2
2018Q3
2018Q4
2019Q1
In a report then just by using the QAGO measure you would get
2018Q1 vs 2017Q4
2018Q2 vs 2018Q1
2018Q3 vs 2018Q2
2018Q4 vs 2018Q3
2019Q1 vs 2018Q4
OBIEE is about the modelling in the rpd, create useful homogeneous units and you facilitate a highly flexible easy to use and simple BI solution for all of your BI users, not just the isolated few who have technical skills.
0 -
Finally after removing the filters- fiscal year,period and quarter from criteria pane and also i have modified the amount column formula in the report.
Now the data is coming as expected.
Thank you for each and everyone for their valuable suggestion and inputs.
0 -
Still that points to SEVERE deficiencies of your models and massive error potential. You may want to review your RPD and not just continue on with it.
0 -
Sure.Definitely I will discuss with my technical team and manager .
Thanks foe the inputs
0 -
Not to burst your bubble, but if your "technical team" implemented this they will most likely tell you there is no problem
0
