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

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.
Similar Threads
  1. Ching

    local cubes

    Ching, Feb 11, 2004, in forum: Excel Beginners
    Replies:
    0
    Views:
    106
    Ching
    Feb 11, 2004
  2. Eleanor
    Replies:
    2
    Views:
    189
    Jim Rech
    Feb 19, 2004
  3. Grega Jerkic

    Pivot table and OLAP excel 2000

    Grega Jerkic, Jul 11, 2004, in forum: Excel Beginners
    Replies:
    0
    Views:
    99
    Grega Jerkic
    Jul 11, 2004
  4. Ed

    Turn Off Auto Query on saved query

    Ed, Sep 29, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    103
  5. D

    Local elections

    D, Nov 13, 2005, in forum: Excel Beginners
    Replies:
    1
    Views:
    68
    Ken Puls
    Nov 13, 2005
  6. Samson Tang
    Replies:
    1
    Views:
    110
    toni.gee
    Jun 26, 2007
  7. Replies:
    0
    Views:
    85
Loading...