Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
21
Views
3
Comments
Ramakrishnan Sankaran
Ramakrishnan Sankaran Rank 1 - Community Starter
edited Aug 13, 2024 6:03PM in Oracle Analytics Forum

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

Answers

  • Chaitanya
    Chaitanya Rank 4 - Community Specialist

    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

  • Ramakrishnan Sankaran
    Ramakrishnan Sankaran Rank 1 - Community Starter

    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

  • FTisiot
    FTisiot Rank 6 - Analytics & AI Lead

    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