Creating Essbase Export Maps

Before transferring data with Essbase databases, you must create a map. The map file stores the database to which it connects. Map files have these filename extensions:

Export maps—*.mps
Import maps—*.mpr

Before you create maps, the Essbase cube and Strategic Finance file must have matching dimension and time structures.

To create import or export maps between Strategic Finance and Essbase:

Open a Strategic Finance file.
- For export maps, open the source file.
- For import maps, create and open an empty target file.
Perform an action:
- To create import maps, select File, then Import, then From Database, then Create New Map.
- To create export maps, select File, then Export, then Create New Map.
On Create New Map, select Analytic Services and click OK.
Select an Essbase server and database and click OK.
Edit mapping options:
- To assign dimensions, see Selecting Essbase Dimensions.
- To assign common dimensions, see Selecting Essbase Common Dimensions.
- To assign accounts, see Selecting Essbase Accounts.
- To assign time periods, see Selecting Essbase Time Periods.
Click OK.
On Save Map As, enter a name for the map file and click Save.