Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MDX for getting history based on last dimension characteristic for SCD
no, you got it not correct – my last example it is the copy of previous example with 3 additional columns(measures) in fact table – Debit, Credit and Balance – just to give you an idea that that might be other measures which requires this logic. All that records in fact table are about the same...- individ
- Post #5
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
MDX for getting history based on last dimension characteristic for SCD
Hi RiverGuy, yes, the idea of current DimPolicy member looks good, but the problem is the ‘current’ depends on the MDX query. If I query the cube for jan only, the current is DimPolicyId=100, if I query the cube for period jan-feb, the current is DimPolicyId=101. Or you suggest to somehow...- individ
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
MDX for getting history based on last dimension characteristic for SCD
MDX for getting history based on last dimension characteristic for SCD. Hi everyone, I am implementing the cube and I run into a problem with slowly changing dimensions(SCD). I guess it might be resolved somehow with MDX, maybe you guys can help me to resolve it. The problem: I have SCD, say...- individ
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
