Snapshot and OLAP Snapshot

image_pdfimage_print

In the Jedox Ribbon you will find the button “Save as Snapshot”. A Snapshot shows the state of a report at a particular point in time. It provides a static, read-only view of a cube or database.

When you save a workbook as a Snapshot, all formulas in the Snapshot copy are replaced by values and have no connection to the OLAP server. This feature makes it possible to forward the worksheet to people who do not have access to the database. Snapshots can be used for reporting purposes.

If you click on the little arrow on the right side of the Save as Snapshot button, you get the additional option “Save as OLAP Snapshot”.

When you save a workbook as an OLAP Snapshot,  the formulas in the Snapshot copy are also replaced by values and have no connection to the OLAP server, as above. However, in this case, only the PALO functions are replaced by their current values. All other functions in Excel are still available.

image_pdfimage_print
Was this post helpful?
NoYes (-2 rating, 4 votes)
Loading...