Creating an OLAP cube in Excel 2007?

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Is this no longer possible? I can do it in Excel 2003, but I don't see this
functionality in 2007. Thanks for a final word on this.
 
Hi,

This feature was removed in 2007. You can reach MS Query but the cube file
option in the last step is gone. Excel 2007 can still build pivot tables
from CUBE files.

One alternative is to keep Excel 2003 around for creating the CUBE files.

Take a look at this microsoft blog - part way down the page it discusses the
CUBE files.

http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel file with olap cube gets corrupted 1
Excel Error while connecting to OLAP cube 0
ODC properties: OLAP Server Formatting 0
OLAP Cubes 1
OLAP Creation in Excel / MS Query -- .cub files 1
Creating OLAP cubes in Excel 2007 4
Filter list not correctly refreshed 3
OLAP Cubes 1

Back
Top