nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12C automate update row counts and check out in repository

vfan

Hi,

I am currently running OBIEE 12C in Windows 10. I am wondering if there is a way I could automate the "Update Row Count" in the Physical layer and then also "Check Out" at the Business Model and Mapping and Presentation layer?

I am connecting to a database that get refreshed every minute, and I need to run reports out of it.

What is the best way to do this? Thank you.

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Hi,

Sorry to ask something instead of giving you a reply ....

What's the link between "connecting to a database refreshed every minute", "run reports out of it" and the 2 things you asking?

The ability to do analysis on a database refreshed every minute doesn't depend on an updated row count or check in/check out ...

So I'm not sure of what you really want to do.

vfan

Hi,

Thank you for helping out.

I have a database that has new data coming in constantly throughout the day. I am connecting to it so that I could run hourly reports. I guess I need to get the latest row count to give me the latest data. Or if I was missing something?

Thanks

Gianni Ceresa

Ok, good that you answered that as I was hoping for it

Good news: there is no link at all between these 2 things. The "row count" is just inside the RPD for your information, when you build a model it's good to know the size of tables because it can impact how you define joins, driving tables etc.

But it has no impact at all on the analysis you execute.

Your analysis will always get the most fresh data from the database. Except in one unique case: cache. If cache is enabled then your analysis will often just take results from the cache without asking the database.

So in your case with a database with new data all the time you will generally turn off cache on all the analysis going on that source because you always want to get the most recent data.

So, based on your initial question and need, I guess right now you don't see the most recent data in your analysis and that's why you looked for these solutions?

Can you check in your logs if your analysis is querying the database or just stay on the cache?

Look in that direction ...

[Deleted User]

Gianni makes excellent points as usual. The metadata in the RPD will have no impact at all on whether you see current data or not. The cache does that.

If you are not sure or not in charge of caching - most companies unfortunately implement it haphazardly - you may want to add the followin to the prefix section of you analysis in the advanced tab in answers:

set variable DISABLE_CACHE_HIT=1;

this will bypass the cache and force retrieval of data from the source.

Also: if you have hourly refreshs the you MUST make sure that you have a good and solid caching strategy since otherwise run the risk of retrieving stale data!

vfan

Hi Gianni and Christian,

Thank you for your pointers. It seems like my analysis was querying on the cache.

I am at the Cache Manager inside the opened Online Repository. I could see 5 cache entries, but how to do I turn that off? Is this where I should be looking for?

Also, Christian,

Where do I set the variable DISABLE_CACHE_HIT=1;

I am fairly new to OBIEE. Thank you very much for your help.

Gianni Ceresa

A picture is worth a thousand words...

There are other ways like disabling cache globally if you didn't want it (or don't need it), there is a setting in Enterprise Manager. You can also disable it on some sources (tables) in the physical layer in the RPD (there is a checkbox when you look at the properties for the table).

vfan

Hi Gianni,

Thanks for the detail explanation. I was able to add this SQL and also disabled the cache in the physical layer in the RDP. However, my analysis is still not showing the latest results.

I checked the database and there were new data.

I checked the cache in the RDP and no cache was built up

I refreshed the page, cleared browser cache, logged out and logged back in, closed the browser and all that

Do you know what else might I be missing? Thank you very much.

Gianni Ceresa

Well ...

Difficult to say like that.

It must definitely work, so what you have to do is to track all the things.

So open the analysis, check what the server does (if it generate the query, if the query is sent to the DB, if the query is supposed to return the new records) etc.

Logs right now are the best (and only way) to know exactly what's happening ...

vfan

Since the data did not get refreshed after the page reloaded, I went into each "section" of the page in which my page was built upon 4 sections together. Each section has a "Edit - Refresh - Print - Export - Add to Briefing Book - " link at the very end. I clicked the Refresh link from there and voila, the data refreshed and I could see the new data.

Is there a way to skip this part? The manual "refresh" does not show in my analysis page but in each section only. Thank you.

Gianni Ceresa

Those links are at the analysis level, they can configures at the dashboard, page and analysis level. When you open the analysis in "view" mode you will also see them in general.

You have a global refresh on the top-right if you click on your account name.

As it's a browser you need to keep in mind there is a browser cache and presentation service cache, so without clicking on "refresh" you get will get cached result even if you reload the page. (page reload doesn't mean data reload)