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!

Obiee ToDate function Error Essbase Integration

769171Oct 25 2010 — edited Dec 20 2010

Hi everybody!

I want to get the agregated sales of the year, I'm using the function ToDate like this:
ToDATE("PECMX#1"."PECMX - measure","Tiempo"."Gen4,Tiempo")

My herarchy was defined in essbase as follow:

Time
Month (It is just a total)
Bimester
Months (Jan, Feb, Mar.....) Detail Level

I'm getting the next error

Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27037] Unresolved level: "Tiempo"."Gen4,Tiempo". (HY000)
SQL Issued: SELECT TODATE("PECMX#1"."PECMX - measure", "Tiempo"."Gen4,Tiempo") FROM "PECMX"

Thanks and waiting for an answer....

Best,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2011

Added on Oct 25 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #error, #essbase, #obiee

1 comment

409 views