Creating Slices with OLAPTable and OLAPReadWrite

There are two other ways to create a slice in Excel: OLAPTable and OLAPReadWrite.

Creating a slice with OLAPTable

OLAPTable is the optimal setting when working with an array (i.e., an unbroken block of rows and columns that make up a table). The OLAPTable setting means that when updating your worksheet, proCube updates the data in table form (i.e., as a block of data), as opposed to cell-by-cell.

To create a slice with OLAPTable:

  1. Go to To create a slice using the Slice Wizard: and perform those steps until you reach Click the Slice Type tab. This will bring you to the Specify Slice Type and Location dialog where you can select Table (OLAPTable).

specifyslicetype.png

Figure 1.    Specify Slice Type and Location

  1. Under Slice Range Formula, select Table and click Next.

  2. Click Finish to display data directly in your Excel Workbook, as shown in OLAPTable Data Slice in Excel.

olaptableexceldata.png

Figure 2.    OLAPTable Data Slice in Excel

Creating a slice with OLAPReadWrite

The OLAPReadWrite function creates a bi-directional connection between the Excel worksheet and proCube database on a cell-by-cell basis. When the Excel worksheet is created from a slice, formulas are written to each individual cell within a table on the worksheet. This means that with each recalculation, the proCube database reads and writes data updates back and forth between each cell in the worksheet and the database.

Use OLAPReadWrite when you want to:

  • Move cells, rows, and columns to different locations on the worksheet.

  • Insert rows and columns into the table.

Consider the following when using OLAPReadWrite:

  • Because of the constant cell-by-cell recalculations, OLAPReadWrite may slow performance if your table is very large.

  • Although database reference formulas remain intact in worksheet cells (even when data is typed over them), if you delete the cell contents, the reference formulas in the cells are also deleted (unless you have placed security over the cells).

  • Typed values do not overwrite the database reference formulas.

In general, if you need full manipulative powers over the data in the Excel spreadsheet, and can sacrifice some speed and performance, OLAPReadWrite is the appropriate setting.

To create a slice using OLAPReadWrite:

  1. Go to To create a slice using the Slice Wizard: and perform those steps until you reach Click the Slice Type tab. This will bring you to the Specify Slice Type and Location dialog where you can select OLAPReadWrite (go to Specify Slice Type and Location to view this dialog).

  1. Under Slice Range Formula, select ReadWrite and click Next.

  2. Click Finish to display data directly in your Excel Workbook, as shown in OLAPReadWrite Data Slice in Excel.

 olapreadwriteexceldata.png

Figure 3.    OLAPReadWrite Data Slice in Excel

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk