Specifying Data Load Scaling

You can scale data as Essbase Studio loads it into an Essbase database. For example, you may want to scale the data if the values in the data source and the values in the database use different types of measurement, such as when the data source tracks sales in hundreds but the Essbase database tracks sales in single units. In this case, you would multiply incoming values by 100.

  To select data load scaling for a member:

  1. Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.

  2. Select the Accounts dimension.

  3. Select the member.

  4. Select the Account Info tab.

  5. Locate the Data load scaling group.

  6. Select the Enable scaling check box.

  7. In the Scaling factor text box, enter the scaling value to use; for example, enter 10 to multiply the incoming value by 10.

  8. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.