Local OLAP cubes in Excel/MS Query

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

  1. IgorM

    IgorM Guest


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

  2. IgorM

    Ed Ferrero Guest

    Ed Ferrero, Sep 22, 2009
    1. Advertisements

  3. IgorM

    IgorM Guest


    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.
    IgorM, Sep 23, 2009
  4. IgorM

    Ed Ferrero Guest

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

    Ed Ferrero
    Ed Ferrero, Sep 23, 2009
  5. IgorM


    , Dec 20, 2013
    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.