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