8 Replies Latest reply: Jun 30, 2011 3:28 AM by Leonard Short RSS

    How do I connect fact & dimension table



      I have attached the view of a data model. I want to learn how would I relate CREATED_DATE field of Opportunity table to

      DW_LOAD_DATE field in Time table.


      My requirement is I want to pick a fiscal year & fiscal month or (QTR_DESC- Quarter Description) and find all the items that has been created after the selected date range.



      Do i need to map or create a new time dimension. I am really out of clue.

      I have been trying for a solution to this problem, but seems luck went for a shopping tour.