Using Microsoft Excel to Define Advanced Data Maps

To simplify defining an advanced data map, use Microsoft Excel to define the data map.

1. Define the basic dimension mappings in the Data Maps page.
2. From the Actions menu, select Export Data Map, and then open the file with Microsoft Excel.
3. Update the Source and Target tabs if needed, and the detailed mappings in each tab of the Excel worksheet, and then save it.

4. In the Data Maps page, from the Actions menu, select Import Data Map, and then save the data map.

Videos

Your Goal	Watch This Video
Learn about importing data maps.	Importing Data Maps and Moving Data from Strategic Models to Planning Reporting Cubes Using Excel Data Maps for Moving Data between Planning Cubes and Strategic Models