I would like to add cubes that are in production environment to Dev Environment. Dev has additional cubes and would like to know if there is a way to add additional cubes from prod without overwriting the cubes in dev environment.
相关问题
- Distinct count to exclude NULL
- Fast way to check if long integer is a cube (in Ja
- DateAdd Column caused an overflow
- SSAS dimension processing makes underlying measure
- SSAS cube processing error about column binding
相关文章
- Process SSAS cube through c# code
- C# amo get roles complete
- SSAS tabular model timeout raised during processin
- MDX - TopCount plus 'Other' or 'The Re
- Simulated OLAP
- 计算成员具有多个属性层次 - MDX(Calculated Members with multip
- 我如何才能找到的MDX措施的数据类型?(How can I find out the datatyp
- SSAS DAX时间智能上年计算给出错误值(SSAS DAX time intelligence p
You have several options...
Here is a link to TechNet that explains all of your options.
Here is a bit of explanation for the first and fourth option.
1) Take (or ask your dba to take) a backup of the prod cubes and restore them to your dev environment. Information on how to do this can be found here. If you do this, you will be restoring an entire SSAS database rather than specific cubes. So you will end up with 2 SSAS databases on your dev server.
4) Open the production cubes in SSDT by creating a new project and choosing import from server. Then change the project settings to deploy that cube to the dev server. Enter the info for the production server and database.
Once you have the prod SSAS database in your project, change the Project properties so the target server is the dev server and deploy the cubes.