Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Reports showing NULL values post migration from 11g to 12c
Hi,
I have recently migrated from OBIEE 11g (11.1.1.9.0) to 12c (12.2.1.3). Post migration, a report which showed correct values in 11g , is now showing NULL values in 12c. Not that all the cells are NULL, there are values in few cells.
I'm trying to develop a report with 2 fact tables and 5 dimension tables. Both the facts have joins to all the 5 dimensions. I ran a consistency check for the RPD and it showed 0 errors.
I'm not sure where I have gone wrong since I'm a newbie to OBIEE. I have also checked the following option in the 'Advanced' tab :
Please find the sample output of my report.
Answers
-
Have you compared the SQL generated by the BI server in 11g with the SQL in 12c? Any differences?
0 -
Does it really return you NULL?
NULL is different than no result, different than '' or anything along that line.
The RPD maybe doesn't give you any warning/error with the consistency check, but it probably means your model had some "shortcuts" which worked in 11g and have a different behaviour in your 12c.
So, as Joel said, look at the generated queries (physical queries) and look at the difference you have there. It will point you in the direction of what need to be changed in the RPD to get a model doing what you ask for.
0 -
No Joel, I haven't compared the queries. Let me do that and get back .
Thanks!!
0 -
Thanks @Gianni Ceresa .. Will do that!!
0
