Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
