Alternatives to MS Query for Pivot Tables & Cubes

Domenick

Guest

Posts: n/a

14th Jan 2010

I am using Excel 2003. I would like to know if there is an add-in or other
(preferably free) tool out there that I could use to create OLAP cubes for
Excel pivot tables that would have better functionality than MS Query. I find
MS Query very difficult to use and almost impossible for creating calculated
fields that can then be built into a cube. (Note: I thought I could just make
calculated fields in the pivot table itself, but now I see that Excel will
not let you do that when using an OLAP cube as a source.)

Any suggestions would be greatly appreciated.

« Is there a way to type in text and not have it print? | Calculated Fields in Pivot Tables using Existing aggregates »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Alternatives to Excel VBA (Query Tables returning more than a million rows)	gotesman@gmail.com	Microsoft Excel Programming	3	28th Apr 2007 01:08 AM
Expert Needed: Query behind (Pivot Charts/ Pivot Tables)	chuck.streb@gm.com	Microsoft Access	0	6th Feb 2007 02:23 PM
Accessing Cubes -- Pivot Tables vs. Cube Analysis Add-In?	Alan Whitehouse	Microsoft Excel Discussion	1	29th Aug 2006 08:25 PM
Data Cubes and Pivot Tables	=?Utf-8?B?dmVuZXRpYW5qaWdzYXc=?=	Microsoft Excel Worksheet Functions	0	10th Feb 2006 07:48 PM
mimic Pivot Tables with external data cubes	Andy S.	Microsoft Access Reports	0	18th Oct 2004 08:38 PM