Define Account Intelligence (Dimension Wizard)

  • Article

Use the Define Account Intelligence page to map account types defined on the Microsoft SQL Server 2005 Analysis Services (SSAS) instance to account types defined in the dimension attribute associated with the Account Type attribute type in the dimension.

Note

This page is displayed only if you selected Standard dimension on the Select the Dimension Type page and if you mapped a dimension attribute to the Account Type attribute type on the Specify Dimension Type page.

Options

  • Source Table Account Types
    Displays the values contained in the dimension attribute assigned to the Account Type attribute type in the Specify Dimension Key and Type page.

  • Built-In Account Types
    Select the account type defined on the Analysis Services instance that maps to the account types in the source table.

    The following table lists the account types that are defined on an Analysis Services instance.

    Value Description

    Asset

    Value of things owned at a specific time.

    Balance

    Count of something at a specific time.

    Expense

    Value of things spent.

    Flow

    Incremental count of things.

    Income

    Value of things received.

    Liability

    Value of things owed at a specific time.

    Statistical

    Calculated ratio of something, or count of something that does not aggregate.

See Also

Reference

Dimension Wizard F1 Help (SSAS)

Other Resources

Dimensions (Analysis Services)
Defining and Configuring Dimensions, Attributes, and Hierarchies

Help and Information

Getting SQL Server 2005 Assistance