Local OLAP cubes in Excel/MS Query

Discussion in 'Excel Beginners' started by IgorM, Sep 22, 2009.

  1. IgorM

    IgorM Guest

    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
     
    IgorM, Sep 22, 2009
    #1
    1. Advertisements

  2. IgorM

    Ed Ferrero Guest

    Ed Ferrero, Sep 22, 2009
    #2
    1. Advertisements

  3. IgorM

    IgorM Guest

    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
    news:...
    > http://wang.se/en/CreateOLAPCube.html/
    >
    > Ed Ferrero
     
    IgorM, Sep 23, 2009
    #3
  4. IgorM

    Ed Ferrero Guest

    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
    > news:...
    >> http://wang.se/en/CreateOLAPCube.html/
    >>
    >> Ed Ferrero

    >
     
    Ed Ferrero, Sep 23, 2009
    #4
  5. IgorM

    Guest

    On Tuesday, September 22, 2009 6:00:43 PM UTC+2, IgorM wrote:
    > 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


    http://www.olapcube.com
     
    , Dec 20, 2013
    #5
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.