Database Functions
Developers can create requests by directly calling database functions from either Oracle BI Answers or RPD. Key uses for these functions include the ability to pass through expressions to get advanced calculations, as well as the ability to access custom written functions or procedures on the underlying database
1. EVALUATE
2. EVALUATE_ANALYTIC
3. EVALUATE_AGGR
4. EVALUATE_PREDICATE
Exercise 4: Find first space position in Name column of customer
1. Create a logical column in RPD with the name of Name_Space_Position
2. Develop below formula à drag and drop into presentation layer
3. Develop a report as shown and observe output
No comments:
Post a Comment