BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

Excel and OLAP Viewer: Not enough room for the Cube!

Submitted by on 2012-02-29 – 6:00 AM One Comment

When you use the OLAP Viewer in Microsoft Excel you may have run into the window borders – literally.  Your cube and analysis needs more space!  

Scroll, Scroll, and Scroll to See the Cube Data 

When you open the OLAP cube in the MS Excel OLAP Viewer the default cube size dictates the area used. You may get 20 rows by 20 columns or you might get 2 rows by 2 columns. So when you want to do some analysis, you expand a dimension and scroll, scroll this way and then scroll, scroll that way to see the coveted data!  We need space to do proper analysis!! Oh have the data gods forsaken us?!?

excel olap viewer cube not that much room

Answer to Your OLAP Prayers

Obviously I would not bring up this point if I did not have an answer. So here’s how you work yourself out of this tight spot. Trick is to turn on the MS Excel Developer Ribbon. It may already be turned on – for instance, in the figure below you can see the Developer menu between the View and Excellent Analytics menus in my MS Excel menu.   If you have the Developer menu – then skip to the next step.  Otherwise, do this: 

  1. Right-click on the ribbon and select Customize the Ribbon.
  2. In the Main Tabs ensure the check box for Developer is checked. Click Ok to return.
  3. Now you have the Developer menu and you can enter Design Mode. The keys to the castle.

excel olap viewer turn on default mode


Now the magic …

  1. Click the Design Mode icon so you can make edits to the cube size.
  2. Drag and drop the right, lower corner to the desired size.
  3. Click the Design Mode icon again to exit the mode.

add-in excel olap cube viewer more space

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

SAS Consultant at Zencos
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has over 10 years of SAS programming experience. Contact her for assistance with your next project.

Tags: ,

One Comment »

  • Thomas G says:

    Great article! Thanks for all the data! This is the information I was looking for.