Showed "Couldn't load file" in Payable Analytics"

[PhooPyae23]

Dear Experts,

We are trying to generate the payable analytic reports in Test system and some tiles could not be loaded.

Please kindly check my attached image and let me know how I can fix this.

Really appreciated for your kindly response.

Loading chart data failed.Database returned the SQL code 719. Error text: currency/unit conversion error: Conversion( "INPUT_COL0", "INPUT_COL1", "INPUT_COL2" ), row 0: ... ot determine valid conversion rate for value(s) 0, -21.8, 3030.2 from unit 'SGD' to unit 'EUR' on date 2024-11-26 00:00:00.0000000 for client '100' Error reading the data of InfoProvider 2CIAPOVRD Error while reading data; navigation is possible Database returned the SQL code 719. Error text: currency/unit conversion error: Conversion( "INPUT_COL0" ), row 0: could not determine valid ... n rate for value(s) -21.8 from unit 'SGD' to unit 'EUR' on date 2024-11-26 00:00:00.0000000 for client '100' Error reading the data of InfoProvider 2CIAPOVRD Error while reading data; navigation is possible.

Best Regards,

Phoo

[Javier_del-Peso · Accepted solution]

Hi PhooPyae23 

Please create an OSS incident to report this type of issues. SAP support will take a look.

Thank you.

Javier del Peso

[PhooPyae23 · Accepted solution]

Thanks for your suggestion.

[MKreitlein · Accepted solution]

Hello @PhooPyae23 ... can you let us know the root cause and the solution? Thanks a lot, Martin

[PhooPyae23 · Accepted solution]

Dear @MKreitlein, I opened ticket to SAP and it has been solved. thanks.

[MKreitlein · Accepted solution]

Hello @PhooPyae23 ... yes sure, got it. But did you get feedback about the root cause? I have the same issue in Cube 2CISDSLSANACUBE1 with currency USD, but all TCUR* tables seem to be maintained correctly... and other CDS Queries with currency converison work fine. Except the one. Thanks, Martin