Importing Level Zero Data from an ASO Cube

To import level zero data from an ASO cube:

1. In System View, click .
2. In Enterprise View, in the Database Properties tab, expand an aggregate storage application.
3. Right-click an ASO cube, and then select Import Level Zero Data.
4. In the Import Level Zero Data in Cube dialog box, enter the following information, and then click OK:
   • Zip File Name—Zip file name for the imported data.
   • Duplicate Aggregation Method—Define how to combine multiple values for the same cell.
     • Add duplicate values—Add values when the buffer contains multiple values for the same cell.
     • Assume values equal—Verify that multiple values for the same cells are identical; if they are, ignore the duplicate values. If the values for the same cell differ, stop the data load with an error message.
     • Use last value—Combines duplicate cells by using the value of the cell that was loaded last into the load buffer. This option is intended for relatively small data loads of up to 10,000s of cells. When using this option, data loads are significantly slower, even if there are not any duplicate values.
   • Options—You can select the following options if desired:
     • Ignore missing values—Ignore #MISSING values in the incoming data stream.
     • Ignore zero values—Ignore zeros in the incoming data stream.

5. In the Level Zero Data Import Status dialog box, click Show Details to show the details of the import, and then click OK.

   Once you have imported the data, you can use Planning forms to see the data, or you can look at the cube statistics to see how the values changed.

Note:

If the imported data contains Planning Textual values, Smart list values, or currency values from a source other than where the data is being imported, the data may be corrupted.