Income Statement Variance Analysis Showing A Query Using Ago Must Reference A Time Dimension
Last updated on JULY 01, 2016
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 6.1.1 version
When attempting to view Income Statement Variance Analysis, the following error appears.
View Display Error
Odbc driver returned an error (SQLExecDirectW).
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: 22062] A query using Ago must reference a Time dimension. (HY000)
1. New installation of Oracle Financial Services Enterprise Financial Performance Analytics 6.1.1.
2. Ran dimension loading, time dimension, ledger stat transformation successfully.
3. Navigate to the Dashboard Income Statement Variable Analysis and received the above error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms