Share via

SSAS 2016 Dimension data is not consistent

Rajesh Paruchuri 1 Reputation point
2022-04-27T03:54:36.58+00:00

I have a fact table and a slowly changing dimension. the dimension values for a specific attribute is not consistent with what i have in the data warehouse.

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.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Alexei Stoyanovsky 3,416 Reputation points
    2022-04-27T05:58:18.173+00:00

    SCDs are not a feature of SSAS, they are just dimensions to it. First suspect for your problem - processing of the said dimension or lack thereof.

    Was this answer helpful?


Your answer

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