Creating an OLAP cube in Excel 2007?

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.
 
S

Shane Devenshire

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
 
Top