Creating Extended Analytics

  To create Extended Analytics tables:

1. Select Databases

2. Double-click a database.

3. Select Database then Extended Analytics.

4. Optional: Under User-Defined Columns for Entity Table, create user-defined columns.

   Use User-Defined Dimensions tables to filter data, for client-defined field, or scalar accounts in Strategic Finance. See Uddim Tables 1-4.

   • In Column to Add, enter name.

   • In Column Data Type, select a data type.

     This must match the data type in the corresponding account inStrategic Finance.

   • To add the column, click >.

   • To remove a column, select one and click <.

   • Up to 20 user-defined columns

   • User-defined columns are in the Entity Table of the star schema database. See Entity Table.

   • After user-defined columns are created, Specifying AccountOptions includes an option for mapping accounts from the source Strategic Finance entity to the star schema database.

5. Optional: To enable users to export consolidation metadata, select Enable EA Consolidation Tables.

6. Click Create Tables.

7. Click OK.