Pivoting/Zoom in Smart View Creating Blank Cells/Rows (Doc ID 1490082.1)

Last updated on JULY 26, 2022

Applies to:

Symptoms

When zooming out on a member, Excel is keeping the extra rows, i.e. they remain blank and cause Excel spreadsheet to considerably increase in size.

Steps that show the issue:

1.  Connect to Sample/Basic via Smart View.
2.  Create a sheet in the following layout:

3.  Save the file.  The size of the file on disk should be 16kb.
4.  Note the scroll bar on the side.
5.  In Smart View Options, set the "Zoom in Level" to Bottom level.
6.  Zoom in one member at a time using Essbase node of Smart View.  This creates 1262 Rows.
7.  Zoom out on any of the members, note Excel is keeping the rows, they remain blank.

This causes the Excel spreadsheet to considerably increase in size. When saved, the Excel workbook size increases.  This behavior may affect the refresh performance.


 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.