Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Does it require to Refresh the Physical, Business and presentation layer after any changes in Databa

Received Response
261
Views
15
Comments
2»

Answers

  • Bhasker Kumar
    Bhasker Kumar Rank 2 - Community Beginner

    Hi,

    1. its not a BI Publisher Report- its an OBI Analaysis Report.

    2. "directly querying the DB " mean that report Query doesnt uses any cache, its querying the Presentation layer subject area tables.

    i have a simple problem that i could not able to get the data from one table- "OBI Analaysis Report" where i have checked in Phyical layer it has the data but i am not shure how to check the data in BMM Layer.

    Can you please help ??

    Regards,

    Bhasker

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Bhasker Kumar wrote:OBI Analaysis Report.

    No, it's an "analysis". There is no such thing as an "analysis report". The correct wording is important since it allows to distinguish between technologies and also to know what you're talking about. If you tell your doctor your "foot arm" hurts then he won't know what you mean just because both are extremities of your body. And if you keep insisting of your "arm" even though you mean "foot" then he will analyze the WRONG extremity and you will be frustrated and think the doctor is useless even though the problem comes from your utilization of the wrong word.

    Bhasker Kumar wrote:i have a simple problem that i could not able to get the data from one table- "OBI Analaysis Report" where i have checked in Phyical layer it has the data but i am not shure how to check the data in BMM Layer.

    You do not "check the data in the BMM layer". Physically - meaning in the physical layer of the RPD - you can check the data by choosing "View Data" on any table object.

    Logically - meaning in the BMM Layer - you construct the logical model and then expose it through the Subject Areas of the presentation layer.

    From the front-end, if you push the log level for queries to level 7, you can see the query moving across all layers: presentation, logical, physical. You can see which LTS is chosen and how the actual physical SQL looks like when it is sent to the database.

    You have to be precise and careful what you look at.

    Strip the analysis down to its core. Don't keep 50 attribute useless columns  which clutter things. Get the full log - as I said level 7 - and look at it in detail. Post it here and point out exactly where the issue is.

    Be. Precise!

    Badly written questions without sufficient information and detail help nobody. Again: think about how you explain a physiological problem to your doctor. "I feel bad." won't help. "I have an ache on my arm" when it's on your "foot" won't help.

  • Bose Pandian
    Bose Pandian Rank 3 - Community Apprentice

    Hi Bhasker,

    Sometimes, in Physical layer, If cache is enabled for table/view it will pick the data from query result. Uncheck the cacheable or cache persistence in physical layer properties of a table.

    No need to refresh any layer everytime if the structure of the table/view is going to be same.

    Hope it helps!

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

    He said 2 days ago that it isnt using cache.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    You might want to double check the detail level on the LTS and exactly which fields must be present in the target analysis for it to use your aggregation table, is the physical sql showing your table when you look at the logs?