I have to build a cube to show metric for the current date, month before, 3 month before, 6 month before and 12 month before and the difference between current date and month before and so on. How can I set up the date dimension so that the data refresh in the future will keep giving me the metrics for the subsequent dates in the future? Thanks in advance.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Transformer Cube build with selected dates
- Thread starter pramsam1
- Start date
Similar threads
- Locked
- Question