Create a Measure Using the TODATE Function in OBIEE

1 . Right-click the F1 Revenue logical table and select New Object > Logical Column.

2 . On the General tab, name the new logical column Year To Date Revenue.

 

2

3 . On the Column Source tab, select "Derived from existing columns using an expression."

 

2

 

4 . Open the Expression Builder.

5 . Select Functions > Time Series Functions and double-click ToDate to insert the expression.

2

 

6 . Click <<Measure>> in the expression.

2

 

7 . Select Logical Tables > F1 Revenue and then double-click Revenue to add it to the expression.

2

 

8 . Click <<Level>> in the expression.

2

Interested in mastering OBIEE Training? Learn more about  OBIEE  Tutorial in this blog post.

9 . Select Time Dimensions > H1 Time and then double-click Year to add it to the expression.

2

10 . Click OK to close the Expression Builder.

11 . Check your work in the Logical Column dialog box:

 

2

 

12 . Click OK to close the Logical Column dialog box.

13 . Drag the Year To Date Revenue logical column to the Base Facts presentation folder.

 

2

For indepth understanding of OBIEE click on