Issue after 12C upgrade

1043392

Hi Experts,

Recently we have upgraded our environment from OBIEE 11g to OBIEE 12C, So here we are facing issues with data validation.

For Ex: we have a report in 11g showing some 20 records then the 12C report is showing more/less  no of records.

We analysed and found query mismatch happening, so can you please let us know what would be the root cause and any work around or suggestions.

Regards,

Prakash.

Gianni Ceresa

Hi,

But which one of the 2 is right based on the model?

Isn't the 11g one which maybe worked "by mistake" ?

There isn't a magical flag that make things the same (ok, there is one but what is the point to move to 12c if you force OBIEE to act as an 11g?), so look at the query, look at the model and define if the tool is acting correctly or not (and I'm not saying based on what you expect to see, but based on the model and the info you gave to your OBIEE environment).

[Deleted User]

1.) Which exact "11g" and which "12c"?

2.) HOW does the query differ?

3.) 90% of the cases of changed queries seen so far in "12c" were due to bad development done in the old version which the new version now interprets more correctly and to the point. Bad old RPDs are legion. Hardly anyone bothers to comprehend how and RPD really works.

4.) Have you already looked at the MOS documents relating to your query change? There are several factors influencing query generation and without any indication from you as to what and how things behave or change there is no way at all to help you

1043392

Hi Gianni,

Actually 11g and 12c both are the right models. In fact some of the 12c reports are working fine, But only few are deviating from the actual result set.So I was clueless to find the root cause.

Please suggest for trouble shooting steps.

Also can we make any changes in query generated by BI server and reapply the same on the report.

Regards,

Prakash.

Gianni Ceresa

1043392 wrote:Hi Gianni,Actually 11g and 12c both are the right models.

I disagree ...

If the model is right (really right) OBIEE would generate either the same query or one returning the same data (except if you played with DB features etc.).

If the 2 environments return different results it's because your model isn't that right.

So look at the generated query, find what is different, what is missing to get you what you expect and then adapt/fix the model so that OBIEE will generate the appropriate query.

[Deleted User]

Couldn't have said it better and I also completely disagree with the "correct" part.