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.
Desired to gain proficiency on OBIEE Training? Explore the blog post on OBIEE training to become a pro in "OBIEE Training"
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:
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
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 in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox