Disabling Relational Source for Essbase Dimensions and Facts

Essbase Dimensions (Dim-Amount Type and Dim-Currency Type) and Facts (Fact-Fins-Essbase Balance), have BalancePVO as the source. This Logical Table Source (LTS) must be disabled so that querying the Fact queries the Essbase cube sources.

  To disable the BalancePVO source, perform the following steps:

  1. Double-click the BalancePVO LTS of Fact-Fins-Essbase Balance.

    This screenshot is an example of Fact – Fins – Essbase Balance selected.

  2. On the General tab, select Disabled and select OK. Disabled source BalancePVO is displayed as disabled.

    This is a screenshot of the Logical Table Source - BalancePVO window with the General Tab selected.

  3. Repeat previous steps for Dim-Amount Type and Dim-Currency Type to disable BalancePVO LTS as shown below.

Note:

In all of the Logical Facts and Dimensions where Essbase cubes are mapped, the priority of the database (cube) LTS should be set to 5. The dimensions and facts are shown in the following list: