December 2, 2015 at 1:43 pm
I want to install SSAS AdventureWorks 2012 Multi-Dimensional database.
I have SQL Server Management Studio 2014 with an instance of the Database Engine installed and a 2014 instance of Analysis Services (Multidimensional).
From codeplex I downloaded AdventureWorksDW2012 Multidimensional solution file and have opened and tried deploying with Visual Studio 2014 to Analysis Server Instance.
Deployment fails.
I can't find a link anywhere to help me with instructions for installing the Multi Dim database. Will someone tell me whether this should work in 2014 and share any ideas?
--Quote me
December 2, 2015 at 1:55 pm
What error message(s) are you getting? And did you change the data source and deployment properties to reflect your settings?
December 2, 2015 at 2:30 pm
one of 50 error messages I am getting is Cannot open database "AdventureWorksDW2012" requested by the login. The login failed.
I don't have AdventureWorksDW2012 installed on the Database Engine instance. Do I need the DW to be installed in order for the Multidimensional Analysis solution to deploy to Analysis services?
--Quote me
December 2, 2015 at 2:49 pm
polkadot (12/2/2015)
Do I need the DW to be installed in order for the Multidimensional Analysis solution to deploy to Analysis services?
Yes, because deploying from the Visual Studio solution means that the cube will have to be processed...and it needs the source database in order to accomplish that.
If you only want the cube with all of it's data already included, see if you can get a backup of the SSAS database. I'm not sure if that is available on Codeplex as well. Note that you wouldn't be able to make any changes to the cube(s) without reprocessing it, so you may need the source database at some point and in any event.
December 2, 2015 at 3:38 pm
OK. Then, since I'm using SQL Server 2014 and already have AdventureWorks2014 DW installed on the Database Engine, I've decided to download AdventureWorks 2014 Multidimensional Models from codeplex.
Surprise though.....When I extract the files, I find two folders: Enterprise and Standard (like before), and inside Enterprise is a file called AdventureWorksDW2014Multidimensional-EE.abf. Different!
in multidimensionalmodels2012 the file extention for the cube was .sln and I could open it with Visual Studio. How do I open an .abf file and deploy THAT to Analysis Services????
--Quote me
December 2, 2015 at 3:58 pm
polkadot (12/2/2015)
How do I open an .abf file and deploy THAT to Analysis Services????
The .abf file is a backup of the SSAS database. You can restore that to your SSAS instance like any other database. The cube and data will be available, but if you want to make changes and redeploy you will need to get the relational source database as well.
December 2, 2015 at 5:27 pm
Hey thanks a lot. Now I have AdventureWorks DW 2014 on the Database engine and Multidimensionalmodel backup restored to Analysis Services engine.
--Quote me
December 2, 2015 at 5:48 pm
one last question:
So how to I process the 2014 cube so it can be edited? Is there an .sln version of it somewhere?
--Quote me
December 3, 2015 at 2:07 am
Hi,
I think you may be able to create a solution file by doing the following:
Opening VS.
New Project.
Make sure that Analysis Services is selected in the Installed Templates.
Import from Server (Multidimensional and Data Mining) option, then selecting the appropriate cube.
Thanks,
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply