Report is not showing the results properly for few columns eventhough the physical sql generated by

Question

Hi,

We have an old instance of OBIEE10g, where customer has generated one report with tabular view, the row level results are not displayed correctly(shown as null) but the SQL generated is correct and giving the right results in the DB. And also, the grand Totals also showing the correct results. I have checked the report criteria, didn't got any problem with it and tried also by changing the aggregation rule from default to SUM/server complex aggregate/server determined also. Can anyone please help me in resolving this issue.

Regards

Pavan Korandla

FTisiot · Answer

It may be due to Logical Table Source Levels set up incorrectly like other 100 reasons... but is hard to tell with almost 0 informations

Ramakrishnan Sankaran · Answer

Thanks for the suggestion Chaitanya,

One point here is, we have not migrated the instance to 11g as of now. And these joins are given recently only.

Regards

Pavan Korandla

Chaitanya · Answer

Hi..

Try to give joins again in both Physical and BMM Layer and clear the cache once again. Since, it is the old instance and you are migrated from 10g to 11g, the server might not recognize the joins properly...

Regards,

Chaitanya.P