Introduction
In one of the previous article (Using Delivered Date Time and System Functions in OBI Analysis) we have seen how to use delivered functions to display Current Date, Current Time, Logged In User and other details. Continuing with the same we will try to show how can one use SUBSTRING function in an OTBI Analysis.
So let’s get started.
Using Substring Function in OTBI Analysis
In order to demonstrate this we would create a very simple OTBI Analysis. For this example we would use “Workforce Management - Person Real Time” Subject Area and the details of the field included are present in table below.
Attribute Name |
Attribute Value |
Person Number |
"Person Details"."Person Number" |
National Identifier Type |
"Person National Identifiers"."National Identifier Type" |
National ID |
"Person National Identifiers"."National Identifier Number" |
First 3 Characters of NID |
SUBSTRING("Person National Identifiers"."National Identifier Number" FROM 1 FOR 3) |
4th and 5th Character of NID |
SUBSTRING("Person National Identifiers"."National Identifier Number" FROM 5 FOR 2) |
Last 4 Characters of NID |
SUBSTRING("Person National Identifiers"."National Identifier Number" FROM 8 FOR 4) |
The Crieteria Tab would appear as below:
And the results tab would show the desired results
Comments
if i have a field called "Concat Account"....and it has something like
australia.project xyz.expenses
how would i extract 'expenses' if all three of the components have variable sizes ?
Thanks and kind regards
RSS feed for comments to this post