Saving Your Work (.olt file)


At this point you can create/save a unique file (with an "olt" extension) that describes the Dimensions you just created (this will serve as a template that could be used over again without going through the steps that have been performed earlier.)

1.   Click Save button (found in the bottom right side of the Dimensions dialog).

2.   In the Save As dialog box, you will name the file—e.g., Northwind Definition—and save it where you choose. Once you have made these choices.

3.   Click Save in the Save As dialog box.

You are returned to the Dimensions dialog box. All current Dimensions are listed.

 

Tip


If you want to use these Dimensions in the creation of a Cube in another database (Note: OLT files cannot be used to create another Cube in the same database), you can do so as follows: within the Dimensions dialog box, click Load, then select the OLT file to "load in" the Dimension information. You can use this OLT file to test the Cube on another machine or if you are creating the same Cube numerous times, in different databases. Note, however, that once this OLT file is created, you cannot modify the Dimension definitions—they are fixed as they were saved originally in the OLT file.

 
 

Please see succeeding topic: