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

Is Scheduling possible in VA (OBIEE 12C)?

Received Response
66
Views
8
Comments
Ashu Eureka
Ashu Eureka Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    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
    FTisiot Rank 6 - Analytics Lead

    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
    FTisiot Rank 6 - Analytics Lead

    any valid reason not to use OBIEE's RPD?

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Ashu Eureka Rank 3 - Community Apprentice

    Yes and yes.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Ashu Eureka Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 7 - Analytics Coach

    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.