Scaling Data Values

You can use rules files to scale data values during data loads.

For example, assume that a Sales value of $5,460 is tracked as 5,460 in an Essbase database and as 54.6 in a data source (because the data source tracks values in hundreds). If you load the value from the data source to the Essbase database, you must scale it.

  To scale a data value while performing a data load:

1. Open or create a rules file.

2. Select a field.

3. Select Field, then Properties.

4. In the Field Properties dialog box, select the Data Load Properties tab.

5. Expand the Scale node.

6. Select Scale.

7. Enter the value by which to scale the data value; for example, by 10 or .01.

8. Click OK.

Related Information

Field Properties Dialog Box, Data Load Properties Tab