1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. FEDERATEDAVCALC

FEDERATEDAVCALC

This Essbase configuration setting enables or disables calculation and data load to be performed in Autonomous Data Warehouse for federated partition cubes. This functionality is new with Essbase 21.5.

Syntax

FEDERATEDAVCALC TRUE|FALSE

  • TRUE—Calculation and data load operations for federated partition cubes are enabled. TRUE is the default behavior for federated partition cubes.

  • FALSE—Users can only query on federated partition cubes. Calculation and data load operations are not permitted through Essbase.

Description

FEDERATEDAVCALC is an application level configuration setting applicable only for Essbase federated partition cubes.

FEDERATEDAVCALC TRUE is the default behavior for federated partition cubes, even if this configuration is not explicitly set.

When FEDERATEDAVCALC is (explicitly or implicitly) set to TRUE, it enables Essbase data loads and block storage calculations to be performed against data in Autonomous Data Warehouse, whenever possible. Exceptions, where Essbase compensates, are listed in Calculate and Query Federated Cubes and in Restrictions for Federated Partitions.

When set to FALSE, calculation and data load operations on federated partition cubes are not permitted through Essbase, but queries are. For example, Essbase block storage (BSO) calculation scripts and data load jobs may not be performed, but queries from Smart View can be made, and the query results reflect the data that is in Autonomous Data Warehouse. The logic for query processing is pushed to Autonomous Data Warehouse whenever possible, as SQL statements. Otherwise, Essbase compensates to process the query.

Only set FEDERATEDAVCALC to FALSE if you have a reason to disallow calculation scripts and data load to be performed through Essbase to Autonomous Data Warehouse.

Though this setting affects whether block-storage (BSO) calculation is enabled for federated partition cubes, it does not affect how Essbase processes aggregate storage (ASO) custom calculations and allocations for federated partition cubes. Essbase Server always processes the ASO calculations and pushes the results to Autonomous Data Warehouse.

Example

FEDERATEDAVCALC TRUE