i made a app. working pretty good (i join an extract to see the loading script) with 4 principal data files (2 with real datas, and 2 with goal datas) and 1 with nomenclature List
For my set analysis I have a master calendar (MM, YYYY), several flags (current Year, Previous Year, Goal Year /special thank's toSunny for that), and possibility to switch between calendar Year or Fiscal Year.
My issue is :
The users can do several predictive simulations (Goal) per year (with predictive label as well).
so i import a table for that with number (highlighted), year, and label for each simulation
I need help to integrate correctly this table in my loading script ...
I think i have to,create a key number_year (SIP_CDSIMP&SIP_EXE) , but i don't know the script to make to be compatible with my calendar MonthYear
if anyone can take a look to my script i would be very helpful ...
PS : tables with real datas are PDFPR & PDVMS
tables with GOAL datas are PDFPP & PDVMP : below the script concerning these 2 tables (with simulation's number hightlighted)