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.
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.
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 an in-depth understanding of OBIEE click on:
- OBIEE 11g Tutorials
- New Features in OBIEE11g
- Checking Out a Project in OBIEE 11g
- Making Changes to the Repository in OBIEE
- Setting Up a Multiuser Development Environment in OBIEE