Sdílet prostřednictvím

  • Článek

Prepare data linked to an attribute group table

Updated: 2009-04-30

In addition to sharing members that belong to other dimensions (linked dimensions), dimensions can also link to attributes. Attributes further define the dimension. For example, account type attribute values such as Asset or Cash help determine how an account is processed. The dimension references attributes according to their MemberIDs, which are located in a separate table with a prefix of AG_ in the application and staging databases.

When you populate a dimension that contains attributes, you must follow an order that will enable you to load correctly. The following is one example.

Example

The procedure in this example shows how to prepare data that is linked to an attribute group table. This same example would also apply to a dimension that is linked to another dimension.

Procedure

To load linked or shared dimensions

  1. Synchronize the Entity dimension (linked to the AG_AccountType attribute group table) to the staging database.

  2. Create the label-based dimension table by using the bsp_DI_CreateLabelTableForDimension stored procedure. Your table will resemble the following (not all columns are displayed):

    MemberID Label Name AccountTypeMemberId_Label BizSystemFlag

    -1

    NONE

    No Member

    Unit

    200

    5001

    990010

    Sold Units

    Unit

    200

    5002

    900100

    BALANCE SHEET

    Asset

    200

    5003

    100000

    Current Assets

    Asset

    200

  3. Populate the label-based table, D_Account_Label. Remember to populate the AccoutTypeMemberId_Label column with values that are derived from the Label field in the attribute group table, AG_AccountType.

  4. Convert the label-based D_Entity_Label table back to an ID-based table by running the bsp_DI_ConvertLabelColumnToMemberIdForDimension stored procedure.

  5. In Planning Business Modeler, load the Product dimension to update the table with the newly populated values. You can synchronize the Account dimension and check the staging database to see that the BizSystemFlag is set to 100 and data has been updated and loaded correctly.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for PerformancePoint Planning Server.