![]() ![]() This article assumes you already have a data warehouse and uses AdventureWorksDW2012 as an example. It is safe to say that most of the work needs to be done in a traditional SQL Server database engine / SSIS environment from creating the data warehouse model to keeping it fed with ETL packages. This is a great pity because it is, in reality, not very difficult at all to create an OLAP cube. Often cube work is passed on to developers because of their comfort with using Visual Studio. From experience I have seen even veteran DBAs avoid the subject of cubes completely because it is too much of an unknown area for them. Multidimensional cubes and transactional databases are two very different things.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |