Error when using TODATE(REVENUE, YEAR) Oracle SQL function
Summary
TODATE function resulted in error, what are possible alternatives to get the needed results?Content
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?
1