OLAP Creation in Excel / MS Query -- .cub files

P

piperbrian

I work for a Fortune 500 Company that has been using the OLAP functionality
available in Excel 2000 and 2003 for years to run a variety of large data
reports. We are considering migrating to Excel 2007; however, I noticed that
Excel 2007 does not allow users to create .cub files. I do not understand
why 2007 dropped this functionality. THE ABILITY TO CREATE OLAP CUBES FROM
RELATIONAL DATABASES WAS ONE OF THE BEST FEATURES IN EXCEL. Are there any
downloads available to enable this functionality in 2007, Perhaps you could
add an optional download to enable the feature in MS Query 12 or to downgrade
MS Query v12 to v11 in Excel 2007? Thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a-b4e688fd0aa2&dg=microsoft.public.excel.misc
 

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

Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
Excel 2003 SP3 - can't find the .cub files 2
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
cub and/or oqy files in 2007 0
Excel file with olap cube gets corrupted 1
Alternatives to MS Query for Pivot Tables & Cubes 0
Error in EXCEL OLAP Cub 0
Dashboards in Excel 0

Top