Detaching Jedox Views


Jedox OLAP views, as generated by the Paste View dialog, work by first generating a context of the view (i.e., the selected cubes, dimensions, elements, and options), and then fetching data from the Jedox OLAP Server 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).

In some scenarios, however, users simply create a View as a starting point for a customized report. In these scenarios, the user may want to change the layout of the View, the format of cells, positioning of parts of the View, and other aspects.

To enable this usage, Views can be detached by using the “Detach View” menu entry on the “View” ribbon icon (Excel Spreadsheet) or on the “Query” pulldown menu (Jedox Spreadsheet).

When a View is detached, the data is still fetched live from the Jedox OLAP Server, but the context of the View is not used anymore. Each request is made separate from others, which allows the user to use different formats for cells of the View, and to change the positioning of parts of the View on the spreadsheet.

Note: 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. The View context is not completely removed, however. If the option “Rebuild View” is used, the View will be restored at its old location, with the last-defined settings, and all features of Views can be used again.