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

3413965

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?

Pedro F

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.