How can i autorefresh data in my dashboard ? - Page 3 — Oracle Analytics

Oracle Analytics Cloud and Server

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

How can i autorefresh data in my dashboard ?

Received Response
771
Views
38
Comments
13

Answers

  • John305
    John305 Rank 5 - Community Champion

    Yes Gianni ,

    Sorry my question wasn't that clear , i just want the last data when i Execute my dashboard ( when i open it ) , i dont want it to refresh autmatically while open .

    I just want the OBIEE to retrieve the last data when i execute the dashboard

    thank you !

  • John305 wrote:I just want the OBIEE to retrieve the last data when i execute the dashboard

    Good news: that's just the normal behaviour ....

    As long as you don't have a filter in your analysis keeping the analysis to an older period (so worth looking for repository variables with scheduled refresh) and that your cache is under control (turned off or if on you have a proper logic in place to expire and refresh it once your ETL loaded the new data).

    So if you ask I assume you aren't having that "normal" behaviour right now.

    Can you look a bit more in detail in your dashboard to see what does the logs say when you open it? Do you see the queries executed against the biserver? Do you see the queries going down to the source? Do you see the queries hitting cache?

  • John305
    John305 Rank 5 - Community Champion

    i am sorry gianni , how can i see if the queries are executed against the biserver , or going down to source ?

  • In "Administration" > "Manage sessions" you can see the logs (assuming nobody thought it was a smart idea to turn off logging to increase performance (could actually be the case and they did that right after turning on the cache ... that would be for @Christian Berg ).

    Or the log files directly on the server.

  • John305
    John305 Rank 5 - Community Champion

    I think its hitting the DB ( see picture ) , can i enable the cache from this menu also ?

    pastedImage_0.png

  • Based on this screenshot you can only say that when you opened the "TDB - préavis" dashboard there were 3 analysis which has been executed ("Nombre de préavis", "Nombre de conteneurs" and "Nombre e préavis par type de transport").

    The page like that doesn't really tell you a lot more.

    To see if the query has been sent to the physical source or hit the cache instead you need to look into "Visualiser le journal". There inside you will find all the details.

  • John305
    John305 Rank 5 - Community Champion

    Good morning Gianni ( thank you for your time ) ,

    When i try to open "Visualiser le journal" , i find a white page with "Historic not found" , and when i try to modify the "level of journalisation" it gave me an error . or i have the admin account normaly

    pastedImage_0.png

  • An out of topic question:

    Do you really manage to understand OBIEE with the shitty French translation it has?

    "Niveau de journalisation pour ce locataire" : I hope the "locataire" pay you a good rent ...

    A "tenant" in that page isn't a "locataire" at all, even if that's the literal translation.

    Did you never try to use OBIEE in English? Also because the doc is in English and almost any resource you find around is in English, so at least it would make it easier for you to match things instead of trying to guess what weird translation they thought about ... (I just mean switching the UI in English for your session, not to force all the users etc.)

  • John305
    John305 Rank 5 - Community Champion

    hahahahaha , i hope that the "locataire" pay you a good rent im dead,

    okey , i changed the language , now its "no log found" and when i try to change the log level for this tenant its :

    now its pastedImage_0.png

  • John305
    John305 Rank 5 - Community Champion

    hahahahaha , i hope that the "locataire" pay you a good rent im dead,

    okey , i changed the language , now its "no log found" and when i try to change the log level for this tenant its :

    now its

    pastedImage_0.png