How to remove dimension table from MDX and Tabular Cube?

Prabu, Chandran 41 Reputation points
2023-03-09T07:25:51.12+00:00

Please suggest the easy step to remove one dimension table from MDX and Tabular Cube.

Also , suggest is there any option to disable it instead of deleting dimension tables.

Thanks in advance....

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
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,263 questions
0 comments No comments
{count} votes

Accepted answer
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-03-09T08:32:42.7033333+00:00

    Hi @Prabu, Chandran

    Disabling dimension tables seems impractical.

    To remove a dimension table, you can refer to this link.

    https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/database-dimensions-modify-or-delete-a-database-dimension-in-solution-explorer?view=asallproducts-allversions

    Best regards,

    Percy Tang


    If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 43,331 Reputation points
    2023-03-09T08:20:32.71+00:00

    Not clear what your issue is.

    Open then cube design, delete the dimensions from it and deploy the cube.

    0 comments No comments