Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are unable to use ago function in our report
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
Answers
-
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?
0 -
Error Codes
---------------------------------------------------
[nQSError: 14078] This query requires the External Expression to be set in the physical Complex Join
0 -
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
0 -
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.)
0
