Question : I have a Dim table that called DimAccounts. It is describing a User account and the dates that […]
Tag: dimension
How to remove leaf member values?
Question : I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case […]
Issue with DECLARE @CutOffDate DATE = DATEADD(YEAR), @NumberOfYears, @StartDate); [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
SSAS MD dimension joins to same table twice (but processing fails as attribute has 2 names for same ID)
Question : My cube has a product dimension, and each product has an “availability” status attribute. In the database, SellableItemAvailabilityId […]
Error when only deploying a dimension on SSDT
Question : I’m trying to follow a tutorial on SQL Server Analysis Services (SSAS) but I’m having trouble on deployment. […]