If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Local OLAP cubes in Excel/MS Query
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 |
#2
|
|||
|
|||
Local OLAP cubes in Excel/MS Query
|
#3
|
|||
|
|||
Local OLAP cubes in Excel/MS Query
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" wrote in message ... http://wang.se/en/CreateOLAPCube.html/ Ed Ferrero |
#4
|
|||
|
|||
Local OLAP cubes in Excel/MS Query
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" wrote in message ... http://wang.se/en/CreateOLAPCube.html/ Ed Ferrero |
Thread Tools | |
Display Modes | |
|
|