October 14, 2016 at 11:52 am
Hello,
I Remote to a Windows 12 Server, that has SQL Server 2014 install, Visual 2013, SSDT, and Attunity 3.0 for Teradata. I'm new to this existing platform where there are production cubes and their SSIS packages.
I need to copy an existing cube, and make a new one from it, where I plan to make some a number of one off changes. I have already copy/renamed some of the views on the SQL Server that I plan to use in this V2 one-off cube as the data source of Facts and Dimensions. I do not need to alter the source to SQL Server tables at this time.
I open VS, go to File, Open, and go to Analysis Services, and give it the proper server/instance/database, but it doesn't connect. I can go to Management Studios and connect to Analysis services, and then see the production cubes, and the one I want to make a copy of to modify. I can in VS open the packages by going File, Open, and Project Solution, and see the solutions and their packages, but this seems incomplete as a "Cube", or a cube to copy.
What is the best or correct way for me to copy a cube from production to make a one off version using Visual Studio?
Thanks,
JPQ
October 17, 2016 at 12:40 am
quinn.jay (10/14/2016)
Hello,I Remote to a Windows 12 Server, that has SQL Server 2014 install, Visual 2013, SSDT, and Attunity 3.0 for Teradata. I'm new to this existing platform where there are production cubes and their SSIS packages.
I need to copy an existing cube, and make a new one from it, where I plan to make some a number of one off changes. I have already copy/renamed some of the views on the SQL Server that I plan to use in this V2 one-off cube as the data source of Facts and Dimensions. I do not need to alter the source to SQL Server tables at this time.
I open VS, go to File, Open, and go to Analysis Services, and give it the proper server/instance/database, but it doesn't connect. I can go to Management Studios and connect to Analysis services, and then see the production cubes, and the one I want to make a copy of to modify. I can in VS open the packages by going File, Open, and Project Solution, and see the solutions and their packages, but this seems incomplete as a "Cube", or a cube to copy.
What is the best or correct way for me to copy a cube from production to make a one off version using Visual Studio?
Thanks,
JPQ
It seems as if you are trying to connect to the existing cube in VS (known as online mode) when what you need to do is select File>New>Project and then under the Analysis Services menu choose Import from Server. Then you put in the details of the cube you wish to copy and it'll create a local development version fo the cube (that is, no data but all metadata).
If you are having problems actually connecting to your SSAS instance from VS but can do so in SSMS then make sure that you are using the same credentials in VS that you are in SSMS.
October 17, 2016 at 9:22 am
Your exactly right, and thanks for your feedback. I meant to come back and update to share what I learned, but yes, can't connect straight to it as I thought being a newbie. I go in with VS; File, New, Project, and in my case select Analysis Services Tabular Project, and give a new Cube name, select the work space server, then select the existing cube closest to what you want to base the new cube from and you're off to the races.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply