mobileNavlogo
headerlogo

Create a Measure Using the TODATE Function in OBIEE

10 October, 2020

Ratings

Related Blogs

 

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:

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .