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

Bhasker Kumar

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]

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

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]

He said 2 days ago that it isnt using cache.

Robert Angel

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?