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

    How do I connect fact & dimension table

      Hi,

       

      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.

       

      Thanks,

      Bikash