I have a Dim table that called
It is describing a User account and the dates that the account has been created.
I would like to get the list of accounts that have been created on the last 6 month Dynamically. For example today is the 09\01\2016.
So my list of accounts will be the accounts created from the
09-01-2016. Notice that this
CreatedOn field does not have a hierarchy and it is an attribute of the accounts dimension .