October 24, 2016 at 2:45 pm
Hello everyone, I'm still a newbie,
Learning new to me existing system, SQL Server 2012, SSAS and SSIS stacks, and VS 2013 with SSDT.
I have an existing cube, and a two new dimensions needed to be added. The source view in a DW already has the columns I need to add to the cube, so now changes needed there.
Perform a drop/rename on the temp table/views to be the original table/vies (having backup table copy of orig).
Create a new solution off the existing cube, and add or make sure to wire up the new dimensions from the now new orig table/views.
Deploy, update loads, etc..
Is there a better way to add what seems to be two columns of dimensions into an existing cube?
Thanks
October 26, 2016 at 12:19 pm
In answering my own question, it's not so straight forward, but I think its fairly industry standard so I hope this may help others. It's a matter of going through the entire flow and modifying the item in each stack, at a high level...
Go to SQL Server and Alter the table and the view. Copy the Solution, go to the target package, and modify the SQL in the target tasks, and deploy.
Copy the Cube and modify the folder to add the column(s), check the diagram for the new additions, and deploy.
In my case, their are a variety of partition tables, Template, Manager, Dimensions, etc... and insert into a column of a row in the dimensions table, that holds the newly modified query that has the new column(s) added to the script.
Once all this is done, run the job at the correct starting step.
It will run and use the modified SSIS package to see the new column(s), from the table/views on SQL Server that you also modified to accommodate the new columns to have loaded from the data warehouse, and load that data from the data warehouse into the SQL Server table and into the newly modified SSAS cubes folder.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply