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

OBIEE 12.2.1.3 reports in a dashboard show old data

Received Response
71
Views
4
Comments
Joe_obieeoas
Joe_obieeoas Rank 5 - Community Champion
edited Aug 13, 2024 7:20PM in Oracle Analytics Forum

Hi Gurus,

We used to have one user who created lot of reports and put them in a dashboard.

All the reports/dashboard he created used to run fine and results were up to date. Once he left organization and his account got deactivated. And now users complain that those reports not showing latest data.

Is this because the ownership for those objects are still in the name of user who left company ?

Please share how to make these reports show latest data..


Thanks in advance.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Are they really reports? Or just analysis?

    You do have logs, don't you? You can see what the analysis does when you open the page, the logs tells you everything.

    A forum can't guess much while the logs tells you exactly what is going on, and as a direct consequence you can see what actions need to taken to change the behavior.

  • Joe_obieeoas
    Joe_obieeoas Rank 5 - Community Champion

    Thanks Gianni.

    These are analysis. As its production env, logging disabled.

    Possible option(s):

    Set CACHE Enable to NO in NQSConfig file (right now its YES)

    Please throw in some suggestions might help in getting latest data.


    Regards.

  • Gianni Ceresa
    Gianni Ceresa Mod

    As its production env, logging disabled.

    Sorry but what is this supposed to mean? What’s the theory of disabling logging in prod? Please don’t tell me it’s because you believe the myth that disabling logging improve performance.

    Exactly because it’s a prod environment you need logging, because guess what? How are you supposed to fix prod issues if you don’t know what’s going on?

    Of course you can guess, but while that isn’t too harmful in dev, I wouldn’t really bet everything on guessing on prod.

    It’s just so wrong that I don’t even want to try to guess what could be happening if everything has been done along that line…

    Enable logging, look at what is happening, fix exactly the issue without guessing what it could be.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    "As its production env, logging disabled."

    For what conceivable reason would logging be turned off in Production?

    That's the same as saying "As I'm driving 300km/h, air bags, breaks, and power steering are disabled."