February 24, 2009 at 10:23 pm
Hi
I am into migration project from SQL Server 2000 Analysis Services to SQL Server Analysis Services 2005. I am not using the migration wizard to accomplish this job.
I am rebuilding all the cubes in SSAS 2005. I am comfortable with the regular cubes.....those are designed fine and works as they do in SSAS 2000.
Now, the issue is i have few virtual cubes in SSAS 2000, which are to be recreated in SSAS 2005. As we all know there is no concept of SSAS 2005 and we have a concept of Linked Objects to accomplish this job.
Lets say i have a virtual cube VC1 which is set of 3 regular cubes RC1, RC2, RC3 in SSAS 2000. I have RC1, RC2, RC3 designed in SSAS 2005 already.
Now to rebuild a replica of the virtual cube VC1 in SSAS 2005, Do I need to create a new cube other than RC1, RC2, RC3 or Can I make use of any of the cube (say) RC1 and then add the linked objects from other cubes.
Please suggest me in this regard
Sam
February 26, 2009 at 10:50 am
Virtual Cubes in AS 2000 were needed in order to join multiple fact tables. In SSAS 2005 with the UDM you no longer need to setup multiple cubes. You are now able to have multiple fact tables (measure groups) within a single cube. If the overall view of the cube is too much you can create simplified views with perspectives for end-users to connect to that only include the objects that they are interested in.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
February 26, 2009 at 11:49 pm
To create equivalent of virtual cube in SSAS 2005 without using the migration wizard, there are two ways of accomplishing the same:
1) Either create a new cube, add linked objects and create different perspectives for each virtual cube. This cube can act just as a controller, to emulate the views of all virtual cubes and it would provide better managebility.
2) Another option is use the cube with major number of objects, add linked objects and create a perspective within it for the virtual cube.
--Siddharth Mehta
February 27, 2009 at 8:25 am
Your suggestions were really helpful. I fixed the problem.
Thank you Dan and Siddhu.
ItzMe
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply