Snapshot and OLAP Snapshot

OLAP 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. In the Jedox Ribbon, you will find the button “Save as Snapshot”.

When you save a workbook as a Snapshot, all formulas in the Snapshot copy are replaced by values and have no connection to the Jedox In-Memory Database Server. This feature allows you to send the worksheet to people who do not have access to the database. Snapshots can be used for reporting purposes.

When you click on the dropdown on the right side of the Save as Snapshot button, you will see the additional option Save as OLAP Snapshot.

If 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 described above. However, in this case only the PALO functions are replaced by their current values. All other functions in Excel are still available.

Updated March 27, 2024