We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"

Accepted answer
9
Views
4
Comments
edited Jul 12, 2021 2:56PM in Reporting and Analytics for ERP 4 comments

Summary

Relate procurement with workforce to get department name

Content

Hi, 

We are trying to relate the procurement requisition real time subject area with the workforce profiles - Model Profiles real time. 

 

Basically, we have the first 3 characters from the center cost of requisition as the part of department name. Below are an example:

Center cost: 550000

Department Name: Sales department (550)

Based on that we've created the OTBI with the information below:

Subjects Areas: "Procurement - Requsition real time",  "Workforce Profiles - Model profiles real time"

Criteria using a SQL expression: 
SUBSTRING( "Workforce Profiles - Model Profile Real Time"."Department"."Department Name" FROM LENGTH("Workforce Profiles - Model Profile Real Time"."Department"."Department Name") -3 FOR 3 ) = SUBSTRING( "- Requisition Distribution Detail"."POR_REQ_DISTRIBUTIONS_ONS_CENTRO_CUSTO_"  FROM 1 FOR 3  )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!