Hello,
From a while a have this error when I put a filter in this simple test workbook. I create also a support ticket for that ( 4-0000564990 ) a month ago but thet don't find anything yet. I suppose that is a bug after the March 2025 version because I don't have this error before.
Without filter on the first field (Etablissment) work very fine, but if i chose a any value I have an errour (here AL003 - CH DIE). This is a classic dimension field. The calculation is: Nb familles metiers = COUNT(distinct "DOM_BVA_CM_PNM"."Dim Metier"."Famille metier (code)")
It seem that the error it's related to AGO fonction (the second filter on date). The date is in format DD/MM/YYYY in datebase and workbook, I met also
GMT+01:00 in OAC console settings. If I chose no date on second filter It works also but if I choose one I have the error message.
[nQSError: 46043] Internal error: No matching table for expr A_BVA_CM_FACT_PNM.ETAB_ID, File server/Query/Optimizer/SmartScheduler/PhysicalRequestGenerator/Src/SQOSPSimplifyJoin.cpp, line 214.",
Il semble que vous utilisiez peut-être un objet non-date avec la fonction AGO. VoirOAC Error While Using AGO Function With Non Date/Time Column or Attribute
Thanks,
Daniel
