Data Model Configuration
The Data Model Configuration controls which data models your Excel file connects to, based on the data models published in the connected Central Point. Instead of editing formulas or recreating connections, you map each data model used in your Excel file to the correct source model directly from the dialog.
This is especially useful when opening an Excel file in a different Central Point, where data model names or IDs may not match the ones originally used to build the file.
Access Data Model Configuration from the Add-ins tab.
When to remap a data model
- Opening an Excel file in a different Central Point where the data models do not match the ones originally used, so your formulas and connections continue to work without any manual edits.
- Redirecting connections after a data model is renamed or replaced in the Central Point, without touching any formula in the Excel file directly.
Dialog breakdown
| Panel | Description |
|---|---|
| Workbook Configuration | Lists the data models currently used in your Excel file, organized into two groups:
|
| Available Data Models | Lists all published data models provided by the connected Central Point. Each entry displays the data model name followed by a unique identifier in parentheses. The NA option is always available and removes any active mapping for the selected entry. |
Map a data model
- Open the Add-ins tab and select Data Model Configuration.
- In the Workbook's Configuration panel, select the data model you want to remap. Choose from Data Extraction / Pivot data model or Reference data model depending on which connection you need to update.
- In the Available Data Models panel, select the data model you want to map it to.
- Click Save to apply. Click Close when finished.
note
Mapped data models do not need to match by name. You can map any data model from your Excel file to any available data model in the list regardless of what they are called.