
Hi,
I have got a requirement to add some of the new diemensions to standard SSAS cubes using MS Dynamics 2012.
Is it good to customize the standard SSAS cubes/creating new cube?
Please suggest me.
Regards,
Raj
*This post is locked for comments
I have the same question (0)Yes you should be able to add additional dimensions to the standard ssas cube project without causing problems with the rest of the cube.
There are a few ways to do this.
If you want to do it using the perspective objects in AOT, here are the steps. You can of course also directly add dimensions using BIDS instead if you wish.
After identifying which tables or view contain the data for your dimensions, add those views to the perspectives for the cubes you want the dimensions to be used in.
Under the perspective -> view-> node, find the fields you want to use as attributes and set AnalysisUsage = Attribute
Run the Sql Analysis Services project wizard under tools->Bisiness Intelligence tools and select the Update option. Select the cube project, and proceed through the wizard. It should add your dimensions to the project.