Skip to Main Content
Forums

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!

AGO function in OBIEE

sliderrulesAug 6 2010 — edited Aug 9 2010
Hi,

I am creating a new logical column on my fact table and would like to use time series function(AGO) to compare trends a month ago. I have a time dimension too.

I am using this expression defined in the new logical column properties:

Ago("HCBF"."Workflow Fact"."Total Case Handlers" , "HCBF"."Time"."Month of Year" , 1)

I get the following error message:

[nQSError: 27009] Unresolved identifier: "HCBF"."Time"."Month of Year".

The function expression appears to be fine, month of year is numeric and total case handlers is a count.

Can anybody help resolve this error message.

Thanks
This post has been answered by 813443 on Aug 6 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2010
Added on Aug 6 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
19 comments
7,449 views