Hello all ,
I am facing a strange behaviour of the presentation server 11.1.1.1.9 running on Windows 2012 R2
I use a very simple query that shows sales figures for march 2017 and previous year ( using Ago function on year level defined in the rpd)
SELECT
0 s_0,
"Activité "."Articles"."Famille Reporting" s_1,
"Activité "."Articles"."Gamme - Libellé" s_2,
"Activité "."Articles"."Univers - Libellé" s_3,
SORTKEY("Activité SVR"."Articles"."Famille Reporting") s_4,
SORTKEY("Activité SVR"."Articles"."Univers - Libellé") s_5,
"Activité "."Facturation"."Montant Facturé N-1" s_6,
"Activité ."Facturation"."Montant Facturé" s_7
FROM "Activité"
WHERE
(("Clients"."Marché" = 'FRANCE') AND ("Temps"."Année Mois" = '201703'))
ORDER BY 1, 6 ASC NULLS LAST, 4 ASC NULLS LAST, 5 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 500001 ROWS ONLY
To run this report , Obiee runs a first physical query for march 2017 , then one for march 2016 and the join the two queries to display data in the report.
I went to session manager , copied both physical queries and ran them directly against the oracle database.
Both queries are correct.
Problem : it seems that in some circonstances ( adding or removing some columns of the "Activité "."Articles" dimension ) the presentation server does not join the to physical queries correctly
Some (!!!) not all data disappear and corresponding sub totals and totals show the wrong figures.
I copied physical ,business and presentation layers on a 11.1.1.6 rpd and ran it on 11.1.1.6 environnement , data is displayed correctly
Any ideas where to look ?
Shall I open an SR ?
Thanks
