Manage cube structure changes

When moving a report to a new server or cube, there can be times when the structure of the cube changes. This can include changed dimension names, deleted members, and so on.

When you edit the connection, check the Manage structure changes on edit. This takes all the wrong items and puts them in the new structure.

If there are invalid dimensions or levels, there'll be separate tabs shown for each. Use the dropdown to map the dimension to the required dimension. If there's no valid dimension to map it to, then leave the selection empty and any references to the dimension will be removed from the report (no grids or slicers will be removed, so any slicers using that dimension will need to be removed manually).

After a dimension has been mapped, select Apply. All the levels and members are then tested and invalid items are displayed in the relevant tab.

A list of all the wrong members found in the report is shown. This doesn't include members that are referenced or stored in Excel ranges. You are required to correct these manually (either by selecting a slicer again, or by editing the cell/formula).

If it isn't possible to map a member, then leave it unmapped and any reference to that member will be removed from the grid/slicer.

There are two ways of working:

• Using the member selector.
• Using a member search.

When using the member selector, you can navigate the hierarchy and select the member to use.

Use the member search to do a search based on the member's caption. Select the box next to the member to use.