Oracle Analytics and AI

We are unable to use ago function in our report

Muhammad Hyder

Problem Description

---------------------------------------------------

We are unable to use ago function in our report

Subject Area: Sales - CRM Pipeline Example: enterprise

Quarter|revenue|previous Quarter

2016 Q4|16000|0

2017 Q1|17000|16000 2017

Q2|18000|17000 -

calculation @previous Quarter: ago("pipeline fact"."revenue", "time".time"."quarter",1)

Regards,

Muhammad Hyder

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

2944729 wrote:We are unable to use ago function in our report

And what does it means?

You aren't able to write the formula? You aren't able to find your column? Are you getting an error?

Muhammad Hyder

Error Codes

---------------------------------------------------

[nQSError: 14078] This query requires the External Expression to be set in the physical Complex Join

2986141

I have the same big problem too. I use the formula in FAH cloud ....

TODATE("- Balance"."Period Net Activity", "Time"."Date - Fiscal Calendar"."Fiscal Year")

Got the error message :

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14078] This query requires the External Expression to be set in the physical Complex Join

AnkitR Gupta

My assumption in here is, you have setup correct Dimension hierarchy with chronological keys which are number in nature(like int (year), double (row_wid) etc.)