Reports showing NULL values post migration from 11g to 12c

Bhuvaneswari Duraiswamy

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 : Show Total value for all measures on unrelated dimensions.

Please find the sample output of my report.

Joel Acha

Have you compared the SQL generated by the BI server in 11g with the SQL in 12c? Any differences?

Gianni Ceresa

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.

Bhuvaneswari Duraiswamy

No Joel, I haven't compared the queries. Let me do that and get back .

Thanks!!

Bhuvaneswari Duraiswamy

Thanks @Gianni Ceresa .. Will do that!!