September 29, 2016 at 3:48 pm
Has anyone upgraded from 2012 to 2016 yet? If so, what are some challenges? How did you verify that the Tabular models and/or Multidimensional cubes migrated over properly?
September 30, 2016 at 5:58 am
For multidimensional, normally there aren't any issues to be expected since not much has changed.
However, one of my clients hit a bug where they could only deploy/process a cube once. After that, deploying or processing the cube would get time-outs or it would even shut the instance down. Very weird bug, but doesn't mean everyone will encounter it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 30, 2016 at 9:47 am
Thanks for the feedback. By the way, what type of tools were used to confirm that source and destination were the same?
October 1, 2016 at 9:55 am
imani_technology (9/30/2016)
Thanks for the feedback. By the way, what type of tools were used to confirm that source and destination were the same?
Not sure what you mean. Which source/destination?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2016 at 10:05 am
source = old system = SSAS 2012
destination = new system = SSAS 2016
October 3, 2016 at 10:09 am
It was the same project deployed to the new server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2016 at 11:34 am
That makes sense. I guess one can assume that the same project deployed to a new server should have the same number of rows, etc. Was anything done to verify that?
October 3, 2016 at 11:38 am
imani_technology (10/3/2016)
That makes sense. I guess one can assume that the same project deployed to a new server should have the same number of rows, etc. Was anything done to verify that?
Yes, the reports still showed the same data.
The problem was that a bug prevented the cube from being deployed/processed multiple times.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply