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