Can SQL 2005 be like Business Objects for Reporting/ Crearting Cubes ?

  • Table A

    Table B

    Table C

    Table D

     

    Cude_1

     

    The currecnt situation is that we have different servers sitting down holding various types of data, we have stored procedures that are scheduled as jobs that update Cube_1 eg do summary counts, sum(), sount(*) etc, If the jobs does not run, it means that Cube_1 will be out of date because there are a lot of records involved with a lot of IO/CPU resources, we are currently looking for a solution whereby there is a cube table which is automatically updated every time inserts/updates are made on the following tables:

     

    Table A

    Table B

    Table C

    Table D

     

    I am not sure if there is a feature in SQL 2005 which can take care of this problem ?

     

    Or maybe another smarter/sensible way of doing this ?

     

    NB: when i refer to cubes, I mean statistical summary information like that produced using Business Objects

     

     


    Kindest Regards,

    John Burchel (Trainee Developer)

  • Possible solution is use of ROLAP partitions for example. Than U have "online" cube. U have to gather all the tables ino one database (ROLAP requires possibility of indexed views creation)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply