Local OLAP cubes in Excel/MS Query

IgorM · External Since: Sep 22, 2009 Posts: 2

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

Ed Ferrero · External Since: Mar 02, 2009 Posts: 5

http://wang.se/en/CreateOLAPCube.html/

Ed Ferrero

IgorM · External Since: Sep 22, 2009 Posts: 2

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.

"Ed Ferrero" <ed.RemoveThis@edferrero.com> wrote in message
news:OIkTPh8OKHA.4692@TK2MSFTNGP06.phx.gbl...
> http://wang.se/en/CreateOLAPCube.html/
>
> Ed Ferrero

Ed Ferrero · External Since: Mar 02, 2009 Posts: 5

I don't think show details on double-click works for cube files.

Ed Ferrero

> 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.
>
> "Ed Ferrero" <ed.TakeThisOut@edferrero.com> wrote in message
> news:OIkTPh8OKHA.4692@TK2MSFTNGP06.phx.gbl...
>> http://wang.se/en/CreateOLAPCube.html/
>>
>> Ed Ferrero
>