Question on shared cube dimensions and measure groups

Hi, all experts here,

Thank you very much for your kind attention.

I am wondering is there anyway of sharing dimensions and measure groups between different cubes? Like if we want to create a new cube, we dont need to reselect its data source and data source view, instead we can select dimensions and measure groups of other cubes?

Hope it is clear for your advices and I am looking forward to hearing from you shortly and thanks a lot in advance for your help.

With best regards,

Yours sincerely,

Hi Helen,

Dimensions can be shared between all cubes inside an AS2005 Database. In order to use dimensions and/or measure groups in multiple cubes you only need to create the cubes inside the same AS2005 database.

hth,

Eric

|||

Hi, Eric,

Thanks a lot for your kind attention.

But in BI studio, yes, I did create a new cube within the same analysis services project which no dount will deploy the cube to the same SSAS2005 database, but whenever I create a new cube with the cube creation wizard, I have to select the new data source view for new dimensions and measure groups again? Could you please shed me any light which UI is available to create new cube with dimensions and measure groups from existing cube?

Hope it is clear for your further advices and I am looking forward to hearing from you shortly and thanks a lot in advance for your help.

With best regards,

Yours sincerely,

|||

Hi,

The cube wizard allows you to use existing dimensions. In the "Identify Fact and Dimension Tables" page, select no dimension tables and in the next page, "Review Shared Dimensions", you can pick the existing dimensions to include in the new cube.

Adrian Dumitrascu

|||

Hi, Adrian,

Thanks a lot for your help.

With best regards,

Yours sincerely,

sql

Question on cube and dimension deployment in production

Hi, all experts here,

Would any of you here shed me any light on how could we deploy cubes and dimensions to other server rather than the one where they are created? And also what permissions at least are needed to be set up for them to be accessed in production enviornment?

Hope it is clear for your help.

Thanks a lot and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hi Helen,

Take a look at the functionality of the Deployment Wizard: http://msdn2.microsoft.com/en-us/library/ms176121.aspx

Regarding permissions, do you mean administrative access or the ability to query data? In either case BOL is again the best place to start: http://msdn2.microsoft.com/en-us/library/ms174517.aspx. Or do you mean the ability just to connect to the cube at all? In which case this new paper on connectivity problems might help - it discusses everything might might stop you from connecting:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

Regards,

Chris

|||

Hi, Chris,

Thanks a lot for your very kind help. Definitely they've been very helpful to clear up my confusions and questions on that.

Yes, I am concerning about being able to access the cubes and dimensions after they are deployed to other production environment.

Thanks a lot again.

With best regards,

Yours sincerely,