Patrick\’s Bytes

31, July 2007

Offline OLAP Cube browsing in Excel 2007

Filed under: Excel,Office,Office Business Application — patrickyong @ 3:59 am

Just realize today that I can actually download the whole OLAP cube and browse with Excel 2007 when you offline. Below are the steps:

1. Access the .ODC file online


2. When you click Open, you will fire up Excel and the Pivot Table Field List.


Construct you Excel Pivot Table view. For example I put Reason on Row Labels, Calendar Year, Quarter and Month on Column Labels and Incidents Count on Values.


To take the cube offline, click on Options –> OLAP Tools –> Offline OLAP


Because you don’t have a Offline data file,  on the Offline OLAP Settings window you will see Offline OLAP option is grayed out. Create the data file by click on Create Offline Data File.


 You will be presented by a wizard, click Next on the first screen


Because a real life data warehouse is huge and you might not want every data, you can choose the level of field you want to store in the offline data file. Then click Next.


Then specify the item within the level and click Next.


 Finally specify where you want to store the data file and click Finish


Now you see Offline OLAP option is enabled.



1 Comment »

  1. How did you create the ODQ file in 2007. In 2003 of Excel I could create such a file from any relational database, I can’t seem to figure out how to do this in Excel 2007. Help!

    Comment by Paul Z — 22, September 2007 @ 1:49 am | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at

%d bloggers like this: