Jedox Views work by first generating a context of the view (i.e., the selected cubes, dimensions, elements, and options) and then fetching data from the In-Memory DB in one efficient request. To generate this context, Views are restricted in terms of layout of the spreadsheet (positioning of cells and behavior during re-calculation).
To get around these restrictions while designing a report, you can “detach” a View, which allows you to use the View as a starting point for a customized report. By detaching the View, you can change the layout, format of cells, positioning of parts of the View, and other aspects.
When a View is detached, the data is still fetched live from the Jedox In-Memory DB, but the context of the View is not used anymore. Each request is made separately from others, allowing you to use different formats for cells in the View and to change the positioning of parts of the View on the spreadsheet.
In Jedox Web, you can detach an existing View by clicking the Detach button in the Query toolbar:
In Excel Add-in, you can detach an existing View by clicking Detach View in the Jedox Ribbon:
Rebuilding the View
Some of the context-dependent capabilities of Views are not possible in detached Views, such as expanding/collapsing on rows and columns, and multi-selection on header dimensions. To use these features again, you have to rebuild the view. To do this in Jedox Web, click the Detach button again; in Excel, click on Rebuild View. The View will be restored to its former location, with the last-defined settings.
Learn more about detached Views in this free online course from Jedox Academy! Just enter your email address when prompted, and the video will begin playing.