SSAS - Cube - Startup

  • Hi,

    Is it mandatory to have a data warehouse in dimensional model to build a SSAS cubes above?

    I'm trying to see if there is any scope to address few reporting needs without the need to build a traditional Data Warehouse first and then build cubes on top of the data warehouse, instead build cubes to do Financial monthly aggregated reporting needs sourcing from backup copy of the Transaction systems.

    Appreciate, if somebody can point me to right direction, I'm still learning and hence this silly query.

    Regards,

    KK

  • kamal_ece (11/20/2012)


    Hi,

    Is it mandatory to have a data warehouse in dimensional model to build a SSAS cubes above?

    I'm trying to see if there is any scope to address few reporting needs without the need to build a traditional Data Warehouse first and then build cubes on top of the data warehouse, instead build cubes to do Financial monthly aggregated reporting needs sourcing from backup copy of the Transaction systems.

    Appreciate, if somebody can point me to right direction, I'm still learning and hence this silly query.

    It's my understanding that you can build a SSAS cube off of regular 3NF relational db - though I've never done that. I've always used a dimensionally modeled DW.

    HTH,

    Rob

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

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