Je suis vraiment tres bizarre ces derniers jours. J'ecris mes requetes, elles fonctionnent bien sous TOD FOR ORACLE. Mais quand je les importe dans Qlikview, c'est la vrai ***. Ca ne marche jamais.
Exemple:
SELECT c.nomredclass libpere, c1.nomredclass libfils1,
c2.nomredclass libfils2, SUM (e.cpt_mtdb)
FROM comclass c
LEFT JOIN comclass c1
ON c1.cdos = c.cdos AND c1.numpere = c.codclass
LEFT JOIN comclass c2
ON c2.cdos = c1.cdos AND c2.numpere = c1.codclass
LEFT JOIN deltaerp.comecrgen e
ON e.cdos = c2.cdos AND SUBSTR (e.numcpt, 0, 3) = c2.codclass /* filtre sur les dates : */
LEFT JOIN deltaerp.comdos d
ON d.cdos = c2.cdos AND d.nred = 'BGFI' AND e.datcpt between d.ddex and d.dfex
WHERE c.cdos = '01'
AND c.numpere = 'MAIN'
AND c.ctab = '20105'
AND c.codclass = '2'
GROUP BY c.nomredclass,
c1.nomredclass,
c2.nomredclass
ORDER BY c.nomredclass,
c1.nomredclass,
c2.nomredclass
Cette requete me donne le bon resultat sous TOAD mais sous Qlikview, elle me retourne des erreurs du genre: Voivi l'erreur:
Champ non trouvé - <Classe>
SQL SELECT c.nomredclass as Classe, c1.nomredclass as Sous_Classe1,
c2.nomredclass as Sous_Classe2, SUM (e.cpt_mtdb) as mount
FROM comclass c
LEFT JOIN comclass c1
ON c1.cdos = c.cdos AND c1.numpere = c.codclass
LEFT JOIN comclass c2
ON c2.cdos = c1.cdos AND c2.numpere = c1.codclass
LEFT JOIN deltaerp.comecrgen e
ON e.cdos = c2.cdos AND SUBSTR (e.numcpt, 0, 3) = c2.codclass
LEFT JOIN deltaerp.comdos d
ON d.cdos = c2.cdos AND d.nred = 'BGFI' AND e.datcpt between d.ddex and d.dfex
WHERE c.cdos = '01'
AND c.numpere = 'MAIN'
AND c.ctab = '20105'
AND c.codclass = '2'
GROUP BY c.nomredclass,
c1.nomredclass,
c2.nomredclass
ORDER BY c.nomredclass,
c1.nomredclass,
c2.nomredclass
