Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Question Unanswered: Can data be queried in OLAP cubes as in Views??

    This question may appear a bit pedestrian but nonetheless.

    We are in the process of building OLAP cubes for data analysis purposes. The question that we have is simply can we access the data stored in the OLAP cube in the same way that we would a View. We utilise a simple VB reporting tool that allows us to dynamically interrogate views in our SQL databases. Would this functionality apply also to OLAP.

    Regards

    Repoman

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You can build a cube off of a single table or from a view.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Can data be queried in OLAP cubes as in Views??

    I didn't try it yet, but I know that SQL Server has a different OLE DB provider for it's analytical services. You will need to use it to connect to your cube.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  4. #4
    Join Date
    Aug 2003
    Posts
    2
    After further research it appears that we cannot just plug directly in. I think we need to use MDX to call the Cube. The resultant data can then be passed to our report builder.

    Many thanks for the answers nonetheless.

    Regards

    Repoman

  5. #5
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Guess I'm not clear on what you are asking. If you build your cubes with ROLAP (relational - OLAP) the cube will build/store your cube in a relational matter. MDX you can use to build calculated members on a cube, what is it you are trying to do?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •