Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
RPD join - results are multiplied
Hi,
Question related to RPD join setup.
We have table with Employees Performance reviews per employee per year.
It is joined with Dim_date: EXTRACT (YEAR from DimDate.ACTUALDATE)-1 = PerfReview.Rewiew Year.
Now when we try to create simple analysis:
Employee ID, Rating, Review Year
each Rating is multiplied 360 times.
If I will add Date filter, then I will receive single entry.
What I have did wrong that it is multiplied? Or based on join that is expected behavior and it will be working correctly only with Date filter?
Answers
-
Multiplied by 360? Sounds like it's multiplied by every single day ...
You are doing a join at a different level than the lowest granularity, so you have to model things right in the RPD telling the system how things are supposed to work.
So the join and OBIEE are just doing exactly what you asked! And it's quite impossible to tell you what you wanted to do instead based on a single join description (not enough info provided).
0 -
joining on EXTRACT (YEAR from DimDate.ACTUALDATE)-1 will still give you a row with a year number FOR EVERY detail row you have ... this is not the way to aggregate.
You need a proper calendar dimension with proper logical hierarchies set and (as been said) tell the system how those work by setting the appropriate content levels in both the logical table sources of dimensions and facts.
0 -
Amen to everything said before. Maybe have a look at what you are doing, how you are doing it and why you are doing it.
0
