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

Top