• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

Summary
Review Date
Reviewed Item
Create a Measure Using the TODATE Function in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Create a Measure Using the TODATE Function in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.