I have a [DateAsAt] table in the DSV. This is linked to 3 fact tables to analyse and slice them from an as at date perspective (lets call them FactA, FactB and FactC). But I want to reuse this dimensions (almost like an alias) and although I have tried
this and it seems to work, I just want to follow some due dilligence to make sure what I am doing is valid.
I have not created a new Named Calculation for a new date dimension that will be used in a Transactional way (not an as at way), and in stead simply copied the [DateAsAt] dimension, and pasted it back into the dimensions section of the cube (the default
name it was given was [DateAsAt 1], but I changed it to [DateTransaction].
Although the relationship between the [DateTransaction] dimenion's source in the DSV (I.e. [DateAsAt]) is linked to FactA, FactB and FactC, I set a new dimension relationship between [DateTransaction] and FactTransactionD in the Dimension Usage area
of the cube.
Is this valid? or MUST I create a seperate source for [DateTransaction] in the DSV and set its relationships there?
View Complete Post