Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    74

    Suggestions on products for DW and BI

    I'd appreciate some advice on the products I need to consider when I am recommending products for a Data Warehouse strategy.

    I think I need Business Objects for the BI and the front-end, with Cognos for Cubes and OLAP.

    Do I also need something like SAS to create a Star-Schema Data Warehouse or could I run Cognos against a conventional Oracle Database, or something else ?

    I'd be grateful for any positive responses.

    B.Dimple
    Senior DBA

  2. #2
    Join Date
    May 2005
    Posts
    2
    You haven't mentioned what sort of application it's for, or data volumes.

    If it's a huge application with terrabytes of data, then I'd recommend using Oracle as the back end, with Microsoft AS for your cubes. You can create your star-schema within Oracle. If it's not quite that size, just go with a purely Microsoft backend for the database and cubes.

    If it's mostly a financial application and you want budgeting and planning capabilities, then I'd recommend Essbase. It's the best OLAP tool for financial applications, but is not as good as Microsoft AS when it comes to storing data in the cubes. Essbase suffers from "data-explosion" whereas Microsoft AS does not.
    Last edited by JSimon; 10-11-05 at 22:37.

  3. #3
    Join Date
    Jul 2003
    Posts
    74

    Thanks a lot

    for your suggestions which sound very good.

    B.Dimple

Posting Permissions

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