Error when using TODATE(REVENUE, YEAR) Oracle SQL function
SummaryTODATE function resulted in error, what are possible alternatives to get the needed results?
Hello Oracle Community,
The below error (per enclosed 2 screenshots) prompted when using TODATE function (per enclosed screenshot named TD) in Analysis in Oracle BI. "Total Revenue" is a fact component:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27037] Unresolved level: "year". (HY000)
SQL Issued: SELECT TODATE("Costing - COGS and Gross Margin Real Time"."Revenue"."Total Revenue", year) FROM "Distributed Order Orchestration - Fulfillment Lines Real Time"
1) What is the cause to this error? What would be the resolution to this error?