As mentioned in my previous post that I installed the Sql Server 2008 Express and Sql Services Evaluation edition (180) days.
Today I would like to share my first hand knowledge of creating Analysis Services Project. Few words about Analysis Services and Role of Sql Server 2008. Sql Server is Business intelligence platform and analysis services 2008 is the multidimensional databases engine.
To begin designing analysis services database, I created a Analysis Services project. Just follow the steps to create a new Analysis Services project and name your project. After accomplishing that I created the Cube based on sample database AdventureWork DW 2008. You will find Data source, Data source views, cubes options under solution explorer Windsor of the Analysis project.
Steps
1- Create new data source by selecting data source folder
2- Create Data Source views by right clicking and it connected to the Adventure Works DW 2008 based on data source in step 1.
I will be writing more on this topic in coming posts.
[...] this post we will create a cube based on DSV already created in last post. You have to follow the wizard steps by using DSV created in our last post. [...]
[...] have created Adventure works cube in AnalysisServices 2008, you can find some information at this link for creating Adventureworks [...]