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.

Desired to gain proficiency on OBIEE Training? Explore the blog post on OBIEE  training to become a pro in "OBIEE Training Online"

  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

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 an in-depth understanding of OBIEE click on: