Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Using Evaluate(Lag) in column formula in OBIEE 11g

Received Response
614
Views
1
Comments
3413965
3413965 Rank 1 - Community Starter
edited Aug 13, 2024 6:05PM in Oracle Analytics Forum

I am trying to do a report in obiee 11g with columns- year, sales, and sales_previous year. I want to get the sales of previous year using Lag function below:

EVALUATE('LAG(%1,1,0) OVER (ORDER BY %2)',"Sales"."Total_Sales","Time"."Fiscal Year")

I get the error:  Cannot function ship the following expression: Evaluate( LAG(%1,1,0) OVER (order BY %2),D2.c1, D2.c2) .Please have your System Administrator look at the log for more details on this error. (HY000)

Ive set the Aggregation rule to Sum as well. Am I missing anything else?

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics & AI Lead

    Hi,

    That's happening because the use of the EVALUATE function needs to be enabled before you can use it. See here item 7.35.

    Also, if you have a time dimension defined, you can use the time series function AGO to achieve what you're probably trying to do with the EVALUATE function.