Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIA - Answer error : [nQSError: 27037] Unresolved level

Gaétan FrancoeurJan 22 2014 — edited Jan 23 2014

HI,

We installed the OOTB OBIA sandbox and I'm unable to create a column formula with the time function AGO in Answer.

I tried : AGO("Fact - Sales Invoice Lines"."Invoiced Amount", "Core"."Date"."Year",1) where "Core"."Date"."Year" is from the BMM hierarchies.

I tried many combinations for the time_level unsuccessfully.

I got the follwing error :

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27037] Unresolved level: "Core"."Date"."Year". (HY000)

Can someone tell me what I'm doing wrong?

Thank you for any help you could provide.

Gaétan

This post has been answered by SriniVEERAVALLI on Jan 23 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2014
Added on Jan 22 2014
6 comments
4,377 views