0 Replies Latest reply: May 23, 2013 12:41 AM by sidath_telstra RSS

    Mixed dimensional granularity in a single fact table

      Hey Guys,

       

      Im sure this is a simple fix however I feel like I just cannot fiugure is out.

       

      I have 4 MAIN TABLES

       

      1)   CT TABLE holds all the Information about a COM TECHNICIAN including which TEAM they are in.

      2)   MEASURES - this table holds CT Fee for Service and Lead Transactions with a Date.

      3)  % APOINTMENTS MET - is a Table that Holds Values and a Date but at a TEAM level - Every CT that should Inherit these Values.

      4) TARGET - This is a Table that contains the TARGETS for each of the Measures at a TEAM level with a Date.

       

      I need to be able to have the TARGET / % APOINTMENTS MET / MEASURES  TABLES WORK USING THE master calendar AND ROLL UP TO THE CT TABLE ACCODINGLY - EITHER AT A TEAM LEVEL OR AT THE CT LEVEL.

       

      CANNOT SEEM TO HAVE ALL OF THE ABOVE AT ANY GIVEN TIME.

       

      NOT SURE WHAT I AM DOING WRONG - ANY HELP OR POINTING ME IN THE RIGHT DIRECTION WILL BE MUCH APPRECIATED.

       

      PLEASE SEE DATA MODEL ATTACHED.

       

      THANKS,