If you want to install SSAS AdventureWorks 2012 Multi-Dimensional database and don't have enough information on how to proceed for the same then this post is designed for you.
1. Open CodePlex and download AdventureWorksDW2012 Data File (DirectLinkToDownload) mdf.
2. Open SQL Server 2012 Database Engine and you can create a relational database using downloaded mdf file. For step-by-step instructions and more details on How-to-attach, you can have a look at technet article.
3. After successful procedure from step2, check whether your relational database instance is showing you the appropriate database named "AdventureWorksDW2012" under database folder.
4. Go to the CodePlex site and download "AdventureWorks Multidimensional Models SQL Server 2012" (DirectlinktoDownload).
5. After successful download, you will get a zip file named "AdventureWorks Multidimensional Models SQL Server 2012", extract the file and go under "Enterprise" folder. Open Solution file.
6. Check the analysis server name under deployment properties and start deployment. After successful completion of deployment, you will be able to access your 2012 Multi-dimensional cube db.
1. Open CodePlex and download AdventureWorksDW2012 Data File (DirectLinkToDownload) mdf.
2. Open SQL Server 2012 Database Engine and you can create a relational database using downloaded mdf file. For step-by-step instructions and more details on How-to-attach, you can have a look at technet article.
3. After successful procedure from step2, check whether your relational database instance is showing you the appropriate database named "AdventureWorksDW2012" under database folder.
4. Go to the CodePlex site and download "AdventureWorks Multidimensional Models SQL Server 2012" (DirectlinktoDownload).
5. After successful download, you will get a zip file named "AdventureWorks Multidimensional Models SQL Server 2012", extract the file and go under "Enterprise" folder. Open Solution file.
6. Check the analysis server name under deployment properties and start deployment. After successful completion of deployment, you will be able to access your 2012 Multi-dimensional cube db.
thank you so much!!
ReplyDeleteThanks, this article made me realize that the adventure works cube database is linked to the DW database in the default database engine.
ReplyDeleteWell done.
Can you explain in detail on "Check the analysis server name under deployment properties"
ReplyDeleteI just opened the solution file, then built(succeed), then deployed. But I always failed at deploy. Error message is " "Errors related to feature availability and configuration. The "Perspectives" feature is not included in the "Standard" edition of Analysis Services."
Add additional info. The above post is for "Enterprise" solution.
ReplyDeleteI can deploy the standard solution no problem.
thanks
ReplyDeleteNice blog.
ReplyDeleteDatabase Development Services
Software Development Company
Thank you for sharing this info. it will be helpful for our Database Development Services.
ReplyDeleteDatabase Development Services
Database Development
Nice Blog.
ReplyDeleteDatabase Development in India
Best blog for database development services.
ReplyDeleteDatabase Development Services
This post is very useful for me...Nice Blog.
ReplyDeleteDatabase Development Services in India
Thanks For sharing nice article about database development services.
ReplyDeleteDatabase Development Services in India
Thanks For sharing nice article about database development services.
ReplyDeleteDatabase Development Services in India
Nice post .Keep updating Cognos TM1 online training Bangalore
ReplyDeleteI have learnt something new which is more interesting big data training in chennai
ReplyDeletePretty article! I found some useful information in your blog, cognos training it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
ReplyDeleteAdvencherworkcune dawonlad
ReplyDelete