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

    Unanswered: Pivot Tables from Non-OLAP Databases?

    Is it possible to create a Pivot Table while doing a webquery off of a Non-OLAP enabled MS SQL 2000 database? Here is the problem tho, I want the pivot tables to honor the Hierarchy (example, in the selection of the dimensions, if I pick USA I can expland USA and see all of the States, then pick PA and expland it and pick all of the Cities).

    I have only been able to do this multi-level when a pivot table is created off of an OLAP piece.. PLEASE tell me there is a work around for this.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    I've embedded pivot tables in web pages that link directly to views in the database. The view must supply all the dimensions required, but then you get functionality similar to (but not exactly the same as) pivot tables in MS Excel.


Posting Permissions

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