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

Bhasker Kumar

Dear Experts,

I am new in Oracle BI, i have encounter an issue where one fact table data was not showing in the report. later i have identified the issue which is associated with the FACT Aggr View , now Fact Aggr has been correct in database, but in Obiee its not reflecting.. my question is do  i need to refresh the entire Physical, business and presentation layer or only for the particular issue table/view.

if i need to refresh the obiee repository then how i can do (what are steps? i should follow) .

any help is highly appreciated!

Many Thanks,

Bhasker

Gianni Ceresa

Hi,

Not sure I got your question right, so here are the 2 scenarios:
a) If you are talking about data (tables/views content) in your database, you don't need to refresh anything in the RPD. If your data change OBIEE will automatically show you the changes as it queries the database and doesn't really store data. Only exception to this is if your have cache enabled, in that case you probably hit the cache and not your own database. Look at your logs and you will see if OBIEE is querying the DB or get results from the cache.

b) If the structure change, so your tables/views have new columns or totally new tables/views you will need to change the RPD to reflect the changes as required as OBIEE doesn't do anything automatically. The RPD contains the model and therefor it's up to you to adapt the RPD based on the structure changes in your database.

So ... pick A) or

Robert Angel

If the table already exists in the physical then you should be able to edit the columns changed manually; I find this faster unless you are talking a massive change; and then drag the columns onto their equivalents in the business model layer to effect the change on the BMM.

Presentation layer should not need touching.

You can query on the physical to the BMM objects linked to it to find everything that needs updating down the 'food chain'.

Robert Angel

Gianni beat me to the 'Add Reply' button - I was describing scenario B.

Bhasker Kumar

Hi,

Thanks for your response!

Can you please tell me where to look for the logs and how i will know OBIEE is querying the DB or get results from the cache.

Thanks,

Bhasker

Gianni Ceresa

You can start by looking in the front-end in the Administration page where you see the active sessions you see the various analysis executed and with their logs.

Robert Angel

See also the advanced tab in answers, there is a check box so you can ensure that it does not use cache, invaluable during testing!

Bhasker Kumar

Hi,

i have checked the log and found report is directly querying the DB and also checked the physical layer we are getting the data for the particluer view-"AGGR_FACT_DEP_ACT"  and alos check relationship/ join with other table which also seames fine, i cound not able to understand what's going wroung with it. . is there any way to view the data in BMM and presentation layer to know where is gap or any alternative to reslove this issue.

Many thanks

Bhasker

Bhasker Kumar

its not using useing the cache

[Deleted User]

So no use keeping StackOverflow up to date I guess?

https://stackoverflow.com/questions/53008205/does-it-require-to-refresh-the-physical-business-and-presentation-layer-in-obie

[Deleted User]

Bhasker Kumar wrote:i have checked the log and found report is directly querying the DB 

1.) Ok is it a BI Publisher "report"? Or is it an OBI "analysis"? It's two different object types from two different technologies. Be precise.

2.) So what does that statement mean? It is "directly querying the DB"? Is it a direct DB request analysis which just uses the connection pool definition and totally bypasses the RPD modelization? Because then your whole question becomes irrelevant as there is zero dependency on the RPD.