Wednesday, July 01, 2009 1:14 PMis obligatory to have a data warehouse to build, design & develop a cube?
can i build a cube on a sample database.
what is the importance to have a data warehouse? why we need it?
- Moved by Jinchun ChenMicrosoft Employee, Moderator Wednesday, July 01, 2009 2:07 PM Move to appropriate forum. (From:SQL Server Reporting Services)
Wednesday, July 01, 2009 2:05 PMModeratorHi RajiAoun,
The question seems to be a Analysis Services's question.
I will help to move to Analysis Services forun.
Jin Chen - MSFT
Friday, July 03, 2009 7:53 AMModerator
Every SSAS project needs a data source. If It’s not a data warehouse, you will find it’s really hard to design/create cube, because the data are not well organized。 Of cause, there is no such limitation. You don’t need to make sure the data source is base on a data warehouse. But a data warehouse is often a core component of a BI infrastructure within an organization.
What is the importance to have a data warehouse？ Data in a data warehouse is organized to support analysis rather than to process real-time transactions as in online transaction processing systems (OLTP). I mean the structure and organization. Actually, the OLAP technology is designed for handling data warehouse, see:
A data warehouse is a general structure for storing the data needed for good BI.
Hope this helps.