This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 39%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
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.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
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.
Apologies for not being clear, I was referring to the
1) fact table (relational data warehouse) - a measure group was created based on this
2) SCD (relational data warehouse) - a dimension in the cube is based on this
Issue: When I query the fact and dimension table joining on the appropriate key the value I get is different from what I get when I browse the cube.
Additional information: the said attribute is part of a hierarchy
Appreciate the comment
This comment is more of the same, not new information.
Besides processing, which you haven't indicated you've investigated, I've got another idea. See whether dimension attribute keys and the link to the measure group correspond to the way you author your joins in the query to the database.