Refreshing repository variables on demand

DeepaliG-Oracle

Does anyone know if there's a way to refresh a Repository variable on demand? There is an option to define the refresh frequency, but I couldn't find a way to refresh it manually.

Henry Cabrera

Hello,

In Oracle Analytics Cloud (OAC), the "Reload Files and Metadata" action is the standard administrative operation used to refresh the RPD (repository) in online mode and applies any changes, including updates to repository variables.

SteveF-Oracle

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/classic-administration-page.html

RVohra

@DeepaliG-Oracle , I do not think we can refresh it manually.

If it is a static repository variable, it's value is initialized in the Variable dialog.

The value of the static repository variable persists and doesn't change until an administrator decides to change it. For example, suppose you want to create an expression to group times of day into different day segments. If Prime Time were one of those segments and corresponded to the hours between 5:00 PM and 10:00 PM, you could create a CASE statement like the following:

CASE WHEN "Hour" >= 17 AND "Hour" < 23 THEN 'Prime Time' WHEN... ELSE...END

If it is a dynamic repository variable, it can be initialized in the same way as static variables, but the values are refreshed by data returned from queries.

When defining a dynamic repository variable, you create an initialization block or use a preexisting one that contains a SQL query. You also set up a schedule that the Oracle BI Server uses to run the query and periodically refresh the value of the variable. When the value of a dynamic repository variable changes, all cache entries associated with a business model that reference the value of that variable are purged automatically.

Each query can refresh several variables, one variable for each column in the query. In Oracle BI Server, create a schedule to run the queries.

Please refer this doc for more details. Hope it helps!