Create a Measure Using the TODATE Function in OBIEE1 . 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.
3 . On the Column Source tab, select "Derived from existing columns using an expression."
4 . Open the Expression Builder.
5 . Select Functions > Time Series Functions and double-click ToDate to insert the expression.
6 . Click <<Measure>> in the expression.
7 . Select Logical Tables > F1 Revenue and then double-click Revenue to add it to the expression.
8 . Click <<Level>> in the expression.
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.
10 . Click OK to close the Expression Builder.
11 . Check your work in the Logical Column dialog box:
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.
For indepth understanding of OBIEE click on