Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

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

 


Ashish Harbhajanka

Comments   

+3 #1 Angus 2021-07-12 23:20
Hello , how are you .

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
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2022  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112
13141516171819
20212223242526
27282930   

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner