USERMANAGEDFEDFACT
The USERMANAGEDFEDFACT configuration setting enables you to choose the data storage management for your federated cube. By configuring it to FALSE, you can let Essbase manage the data storage in Autonomous AI Lakehouse.
Syntax
USERMANAGEDFEDFACT [appname] TRUE|FALSE -
appname—If you specify an application name, the setting applies to the cube within the application. If you do not specify an application name, the setting applies to all applications and cubes on the Essbase Server.
-
TRUE—You manage the data storage in Autonomous AI Lakehouse. You must create the fact table before you create the federated partition, and you must recreate the federated partition (and update the fact table) for nearly any kind of metadata changes. TRUE is the default when USERMANAGEDFEDFACT is left unconfigured.
-
FALSE—Essbase manages the data storage in Autonomous AI Lakehouse. Essbase automatically creates the fact table based on the specified pivot dimension during the federated partition creation and enables Essbase support for a specific set of metadata updates.
Description
- You manage—Set up your own fact table using SQL or Essbase data export, and then create the federated partition.
- Essbase managed—When you load data to your federated cube, you can let Essbase create and manage the data in Autonomous AI Lakehouse.
Example
USERMANAGEDFEDFACT [Sample] TRUE