Share via

SSAS cube project

Nahto Teddy 0 Reputation points
2024-07-18T18:27:49.94+00:00

I added a dimension table to the Data Source View (DSV) and refreshed it. I then processed the cube, but I can't see this new dimension table under "New Dimension" in the cube structure to add it to the cube. I have tried refreshing, restarting, and reopening the SSAS cube project, but I still encounter this issue. Could you please advise on how to fix it?

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,947 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,290 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,931 Reputation points
    2024-07-18T18:37:36.5533333+00:00

    I added a dimension table to the Data Source View (DSV)

    Adding a table/view to DSV doesn't change anything in the cube.

    You have to add+define the dimension, fact/dimension relation, cube dimension, relation between and so on.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.