Using Microsoft Excel to Define Advanced Data Maps
To simplify defining an advanced data map, use Microsoft Excel to define the data map.
- Define the basic dimension mappings in the Data Maps page.
- From the Actions menu, select Export Data Map, and then open the file with Microsoft Excel.
- Update the Source and Target tabs if needed, and the detailed mappings in each tab of the Excel worksheet, and then save it.
-
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 |