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

image

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

image

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.

image

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

image

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.

image

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

image

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.

image

Then specify the item within the level and click Next.

image

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

image

Now you see Offline OLAP option is enabled.

image

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: