Mixed dimensional granularity in a single fact table

Thu, 23 May 2013 04:41:31 GMT

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,

topic Mixed dimensional granularity in a single fact table in QlikView

Mixed dimensional granularity in a single fact table