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 screen shot 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 screen shot 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:

In all dimensions where there are both VO sources and Essbase sources, the VO source should be placed first among the Transactional Business Intelligence LTS(s) followed by the Essbase cube LTS(s). This ensures that, in a dimension-only query, values are pulled from the VO source.

This guideline is applicable to the following dimensions: