How to copy an SSAS cube

Zimiso 121 Reputation points
2024-06-11T10:33:17.89+00:00

Good day,

I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this?

Please assist

Many thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Greg Low 1,670 Reputation points Microsoft Regional Director
    2024-06-22T01:18:05.7+00:00

    In Visual Studio, when creating a New Project, use the template for Importing from a server:

    User's image

    This is available for both multidimensional and for tabular. I'm guessing you're meaning multidimensional (based on saying cube) but regardless, this works for both.

    You then have it create a project for you.

    If it's multidimensional, just then modify the project to add another cube and redeploy.

    If it's tabular, then you can't have multiple models in the one project (you can have multiples in one solution), so save it as a new name, modify it, and deploy it.

    0 comments