You need to delete the dimension

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.You need to delete the dimension.
What should you do?

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.You need to delete the dimension.
What should you do?

A.
Deploy the project from the development environment by using SQL Server Management Studio.

B.
Script the deletion of the dimension as an XMLA command for execution against the production model.

C.
Use the SQL Server Analysis Migration Wizard.

D.
Write a T-SQL command to drop the dimension from the database



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Marchello

Marchello

B.
Script the deletion of the dimension as an XMLA command for execution against the production model.