As per your statements the Objective data must have the date field and you fact table must have the date field.
Create the link table that connects you fact table and future Objectives and Calender.
LOAD DISTINCT Canal, Zone , Date Resident FactTable;
LOAD DISTINCT Canal, Zone , Date From Objective Data;
LOAD AUTONUMBER(Canal&'-'&Zone&Date) AS %FACT_KEY ,
AUTONUMBER(Canal&'-'&Zone&Date) AS %OBJECTIVE_KEY ,
Date AS %CALENDER_KEY
DROP Table TempLinkTable ;
Based on your requirements you can keep Canal , Zone in the Link Table of fact table.
instead of joining try concatenating your goals and fact table..see script of attached example
test.qvw 149.5 K
People, i send an example
as you can see if you chosee any month year of 2014, the objective desapear
thank you again for your help!
DivinoUltimaVersionExample.qvw 22.8 MB