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

Is Scheduling possible in VA (OBIEE 12C)?

Ashu Eureka

Summary

Is Scheduling possible in VA (OBIEE 12C)?

Content

Hello All,

We are using on-premise VA (through OBIEE 12C). Though I could not find anything on the "Schedule" option for VA projects, is there a way to schedule the VA projects so that the data gets refreshed everyday before the users log-in to check the project dashboard?

Thanks,

Ashish

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

ashu_eureka wrote:...data gets refreshed everyday ...

Well ... depends what data you used? If you use a DB or any other "external" source data is refreshed when you load it, not when you open or not your VA report.

Or did you build your VA report on Excel data you uploaded and you want to automate the refresh of that data?

If that Excel is something which change every day and you have the new data somewhere why isn't it in a DB?

FTisiot

Hi,

If you're using VA against OBIEE's subject areas then query caching is

"shared" with OBIEE. Don't think there is a way to schedule VA projects

however you could create an analysis or dashboard with the same data points

(kind of the same analysis) and run it with an agent. This will create the

related cache entries (if you enabled caching) that could then be used by

VA too.

On Mon, Jan 16, 2017 at 1:23 PM, community-admin <

FTisiot

any valid reason not to use OBIEE's RPD?

Gianni Ceresa

As far as I know there isn't a caching like the one you look for in VA, if you were using OBIEE as a source (the RPD, not some direct db request thing etc.) you could use the OBIEE cache in theory (so using agents on the OBIEE side to populate the cache in the morning).

Ashu Eureka

Yes and yes.

Gianni Ceresa

So you look for caching, as retrieving the data is slow you would like to cache it so the users will not have to go down to the DB but VA find the required in the cache (=> faster). Right?

(Just making sure to focus on the right piece)

Your source is the database directly (so using a datasource pointing to the DB) and not using an OBIEE analysis / Logical SQL source?

Ashu Eureka

It's Oracle DB and VA projects have daily reports. So the DB is refreshed/loaded daily and that's not what I am concerned about.

Even after DB table gets refreshed, the VA project based on this table takes a long time to fetch the data and show visualization. Something which irritates the business user. So if we can schedule the VA projects to refresh the data in the views and when user opens the VA project, the visualization should be ready and cached.

Any option?

Thanks!

[Deleted User]

VA (the component) does not have a cache.

There is an XSA cache which concerns uploaded files.

If you point VA directly to a DB then you are circumventing the actual architecture just like when you are doing direct database requests in OBI.