OAC - erreur on a simple calculation (count distinct) placed on a Tile component — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC - erreur on a simple calculation (count distinct) placed on a Tile component

Received Response
102
Views
4
Comments
Daniel Vornicu
Daniel Vornicu Rank 5 - Community Champion
edited May 26, 2025 9:40AM in Oracle Analytics Cloud and Server

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)")

image.png

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

Answers

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    Hi

    This error normally happens if you are using time series calculated for a non-date/time datatype column. Can you please confirm data type of the date filter column?

    thanks

    Gayathri

  • Daniel Vornicu
    Daniel Vornicu Rank 5 - Community Champion

    Hello,

    The format for the DATEREFENCE field is DATE (in the Oracle schema and in the physical layer of the SM).

    In the workbook in the dashboard filter the format in set to Auto (dd/MM/YYYY) and the field is recognized as Date as you see below. I don't understand the error related to the time series (AGO function or other).

    image.png

    Thanks!

  • Daniel Vornicu
    Daniel Vornicu Rank 5 - Community Champion

    Hello @GayathriAnand-Oracle and thanks for the answer on the SR 4-0000564990.

    I didn't have any solution yet on my problem (SR opened 2 months ago affected to a guy named Nathan that sugest me to close it and open another SR).

    Daniel

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    Hi Daniel

    We will have a zoom call with you to review this issue. SR will be updated. Thank you for your patience.

    Regards

    Gayathri