In 2005 it was not possible to create an empty cube but in 2008 we can create an empty cube. A new feature in Analysis Services 2008 is the Attribute Relationships tab in the Dimension Designer . to implement attribute relationship is complex in ssas 2005, we can create ONLY 2000 partitions per Measure Group in ssas 2005 and the same limit of partitions is removed in ssas 2008. You can answer more but if you end this with these then the interviewer feels that you are REAL EXPERIENCED.
Posted Date:- 2021-09-27 23:28:11