Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS - Cube - Startup Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 2:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 3:49 AM
Points: 9, Visits: 212
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
Post #1386751
Posted Tuesday, November 20, 2012 6:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 1,163, Visits: 1,189
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
Post #1386875
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse