OLAP Cube Wizard in Office 2007

S

SoftServ Guy

Does anyone know why on Earth this has been removed? I have customers who
used to use this very upset that they appear to have "downgraded" to Excel
2007.
Are there any other ways to create cubes?
 
B

Bob I

The following is copies from Excel Help.

The OLAP Cube Wizard is no longer available. To create PivotTable
reports that are based on relational data, you can connect to the
relational data directly, or you can import the relational data into an
Excel workbook.
For more information, see:

Connect to (Import) an OLAP database
Connect to (Import) external data
 
B

Bob Buckland ?:-\)

Hi SoftServ Guy,


You may want to follow-up in the MS Excel 2007 discussion group on this through the link below for details on using the Excel 2007
version OLAP/PivotTable Report features. The Offline Cube Wizard is still in Excel 2007 but the OLAP Cube Wizard is not. The
capability to create and work with cubes is still in Excel 2007, but handled a bit differently.

===============
Does anyone know why on Earth this has been removed? I have customers who
used to use this very upset that they appear to have "downgraded" to Excel
2007.
Are there any other ways to create cubes?


SoftServ Guy>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
Top