1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
| SET ThousandSep='*';
SET DecimalSep=',';
SET MoneyThousandSep='*';
SET MoneyDecimalSep=',';
SET MoneyFormat='#*##0,00 ;-#*##0,00 ';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
ODBC CONNECT TO Qlikview (XUserId is daJEUZFMUDbIEBBA, XPassword is CIPSSSNOTLaYWXJOJD);
//Table Performance
LOAD AnneeDeCalcul,
DateDeCalcul,
Indicateur,
MoisDateDeCalcul,
ValeurIndicateur;
SQL SELECT AnneeDeCalcul,
DateDeCalcul,
Indicateur,
MoisDateDeCalcul,
ValeurIndicateur
FROM TLDB.dbo.Performance;
// Table Project
LOAD ProjectBudgetRevise,
ProjectBudgetTotalInit,
ProjectChefDsi,
ProjectChefEbis,
ProjectConduiteChangement,
ProjectDateAuto,
ProjectDateClo,
ProjectDescription,
ProjectDirectionMetier,
ProjectDomaineFonc,
ProjectEcartAvancement,
ProjectEcartPrixYtd,
ProjectId,
ProjectJournalEvenem,
ProjectLinkLoi,
ProjectLinkPlp,
ProjectMoe,
ProjectNotePriorite,
ProjectNoteRisque,
ProjectNouveauEvolu,
ProjectPreEtudeON,
ProjectProgramme,
ProjectRealiseYtd,
ProjectStatutLance,
ProjectType,
ProjectWbs;
SQL SELECT ProjectBudgetRevise,
ProjectBudgetTotalInit,
ProjectChefDsi,
ProjectChefEbis,
ProjectConduiteChangement,
ProjectDateAuto,
ProjectDateClo,
ProjectDescription,
ProjectDirectionMetier,
ProjectDomaineFonc,
ProjectEcartAvancement,
ProjectEcartPrixYtd,
ProjectId,
ProjectJournalEvenem,
ProjectLinkLoi,
ProjectLinkPlp,
ProjectMoe,
ProjectNotePriorite,
ProjectNoteRisque,
ProjectNouveauEvolu,
ProjectPreEtudeON,
ProjectProgramme,
ProjectRealiseYtd,
ProjectStatutLance,
ProjectType,
ProjectWbs
FROM TLDB.dbo.Project;
LET vDateMin = Num(MakeDate(2010,1,1));
LET vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));
LET vDateToday = Num(Today());
TempCalendar:
LOAD
$(vDateMin) + RowNo() - 1 AS DateNumber,
Date($(vDateMin) + RowNo() - 1) AS TempDate
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);
MasterCalendar:
LOAD
TempDate AS IziDate,
Day(TempDate) AS Day,
Month(TempDate) AS Month,
Year(TempDate) AS Year
RESIDENT TempCalendar ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
LET vDateMin = Num(MakeDate(2010,1,1));
LET vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));
LET vDateToday = Num(Today());
INTERVALMATCH (IziDate)
LOAD DISTINCT ProjectDateAuto, ProjectDateClo RESIDENT Project;
INNER JOIN
LOAD ProjectDateAuto, ProjectDateClo, ProjectBudgetRevise, ProjectBudgetTotalInit, ProjectChefDsi, ProjectChefEbis, ProjectConduiteChangement, ProjectDescription, ProjectDirectionMetier, ProjectDomaineFonc, ProjectEcartAvancement, ProjectEcartPrixYtd, ProjectId, ProjectJournalEvenem, ProjectLinkLoi, ProjectLinkPlp, ProjectMoe, ProjectNotePriorite, ProjectNoteRisque, ProjectNouveauEvolu, ProjectPreEtudeON, ProjectProgramme, ProjectRealiseYtd, ProjectStatutLance, ProjectType, ProjectWbs
RESIDENT Project;
DROP TABLE Project; |
Partager