Local OLAP cubes in Excel/MS Query

I

IgorM

Hi

Can someone please recommend some good book or web page about creating local
OLAP cubes using MS Query. I have some data in Access that I want to work
with using cubes.

Kind regards
IgorM
 
I

IgorM

Hi

Thanks for response. Unfortunately I still don't know if the
show-details-after-double-click feature is available in pivottables linked
to OLAP cubes.
I tried all three connection types. With the two first options (rebuild at
once and rebuild when needed) I still cannot make the pivot table to create
a sheet on the fly and provide details for the value being clicked.
 

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

OLAP Cubes 1
RBS and other custom fields are not in olap cubes 1
olap cubes in msps 2007 5
Alternatives to MS Query for Pivot Tables & Cubes 0
Pivot table on local cube 1
OLAP cubes - no task information 1
OLAP cubes with Time scale : only 6 months 3
Failed to build the OLAP cubes. Error: 0

Top