| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Managing cube structure changes"
| Line 1: | Line 1: | ||
New in [[Version 7.5]]. When moving a report to a new server or cube there can be times when the structure of the cube has changed (dimension names changed, members deleted etc.) | New in [[Version 7.5]]. When moving a report to a new server or cube there can be times when the structure of the cube has changed (dimension names changed, members deleted etc.) | ||
| − | When editing the connection it is possible to check the "Manage structure changes on edit", to pick up all the invalid items and map them to the new structure | + | ==Usage== |
| + | |||
| + | When editing the connection it is possible to check the "Manage structure changes on edit", to pick up all the invalid items and map them to the new structure. Please note this is for members reference in grids and slicers only, not Excel formula | ||
[[File:validateconn.png|center|400px]] | [[File:validateconn.png|center|400px]] | ||
| − | =Invalid Dimensions and Levels= | + | ==Invalid Dimensions and Levels== |
| + | |||
| + | If there are invalid dimensions or levels there will be separate tabs shown for each. Use the drop-down to map the dimension to the required dimension. If there is 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, click Apply - all the levels and members will then be tested and invalid items displayed in the relevant tab. | ||
[[File:validatedim.png|center|400px]] | [[File:validatedim.png|center|400px]] | ||
| − | =Invalid Members= | + | ==Invalid Members== |
| + | |||
| + | A list of all the invalid members found in the report will be displayed, this doesn't include members referenced or stored in Excel ranges; they will need to be correct manually (either by re-selecting a slicer, or by editing the cell/formula) | ||
| + | |||
| + | If it is not possible to map a member, then leave it unmapped and any reference to that member will be removed from the grid/slicer | ||
[[File:validatemem.png|center|400px]] | [[File:validatemem.png|center|400px]] | ||
| + | There are 2 ways of working: | ||
| + | |||
| + | # Using the member selector | ||
| + | # Using a member search | ||
| + | |||
| + | |||
| + | ===Member Selector=== | ||
| − | + | When using the member selector - you can navigate the hierarchy and select the member to use | |
[[File:validatememsel.png|center|400px]] | [[File:validatememsel.png|center|400px]] | ||
| − | ==Member Search== | + | ===Member Search=== |
| + | |||
| + | Using the member search will do a search based on the member caption - check the box next to the member to use | ||
[[File:validatememsearch.png|center|400px]] | [[File:validatememsearch.png|center|400px]] | ||
Revision as of 16:01, 27 June 2013
New in Version 7.5. When moving a report to a new server or cube there can be times when the structure of the cube has changed (dimension names changed, members deleted etc.)
Contents
[hide]Usage
When editing the connection it is possible to check the "Manage structure changes on edit", to pick up all the invalid items and map them to the new structure. Please note this is for members reference in grids and slicers only, not Excel formula
Invalid Dimensions and Levels
If there are invalid dimensions or levels there will be separate tabs shown for each. Use the drop-down to map the dimension to the required dimension. If there is 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, click Apply - all the levels and members will then be tested and invalid items displayed in the relevant tab.
Invalid Members
A list of all the invalid members found in the report will be displayed, this doesn't include members referenced or stored in Excel ranges; they will need to be correct manually (either by re-selecting a slicer, or by editing the cell/formula)
If it is not possible to map a member, then leave it unmapped and any reference to that member will be removed from the grid/slicer
There are 2 ways of working:
- Using the member selector
- Using a member search
Member Selector
When using the member selector - you can navigate the hierarchy and select the member to use
Member Search
Using the member search will do a search based on the member caption - check the box next to the member to use
