Paritioning data is really useful for grouping data prior to data manipulation (as opposed to group by which does grouping after manipulation the data). This is because group by is grouping resulting data while partition by is actually partitioning  the data and returning the appropriate partitioned data. Simply said; a normal query is run and the results are retrieves by the Database, then Analytics are applied to the results and the Analytic function columns are computed.

In my previous post on setting up predelivered collaborative related services, I was asked to also elaborate on how to create your own custom related content based on field content from the component. In this post I will explain how to incorporate Google Maps directions as related content based on the home address of an employee and the work location. For this example I will be using PeopleSoft HCM9.1 on PeopleTools 8.51.

Workstation

Installing 3of9Font on developer workstation

In order to develop BI Publisher templates with barcodes you need to deploy the barcode font FREE3OF9.TTF on the developer workstation as following steps describe.

Open Zip:

Extract FREE3OF9.TTF to c:\windows\fonts, do not extract FRE3OF9X.TTF.

Server

Deploying font on Server

To be able to generate BI Publisher reports from PeopleSoft the FREE3OF9.TTF needs to be deployed the the application server and process scheduler servers like described below and the xdo.cfg file needs to reflect the font.

Copy FREE3OF9.TTF to folders:

• C:\windows\Fonts
• PS_HOME\jre\lib\fonts\

Adjust xdo.cfg

In folder PS_HOME\appserv to can find file xdo.cfg. Open this file and add the following lines:

<!–
; ***************************************************************
;  This software and related documentation are provided under a
;  license agreement containing restrictions on use and
;  disclosure and are protected by intellectual property
;  laws. Except as expressly permitted in your license agreement
;  or allowed by law, you may not use, copy, reproduce,
;  translate, broadcast, modify, license, transmit, distribute,
;  exhibit, perform, publish or display any part, in any form or
;  by any means. Reverse engineering, disassembly, or
;  decompilation of this software, unless required by law for
;  interoperability, is prohibited.
;  The information contained herein is subject to change without
;  notice and is not warranted to be error-free. If you find any
;  errors, please report them to us in writing.
;
;  Copyright (C) 1988, 2010, Oracle and/or its affiliates.
;  All Rights Reserved.
; ***************************************************************
–>

<config version=”1.0.0″ xmlns=”http://xmlns.oracle.com/oxp/config/”>

<properties>
<!– System level properties –>
<property name=”xslt-xdoparser”>true</property>
<property name=”xslt-scalable”>true</property>
<property name=”system-cachepage-size”>50</property>
<property name=”system-temp-dir”></property>
</properties>

<fonts>
<font family=”Free 3 of 9″ style=”normal” weight=”normal”>
<truetype path=”C:\Windows\Fonts\FREE3OF9.TTF”/>
</font>
</fonts>
 </config>

Barcode

In this example we will use the Emplid for Parcode

For our the barcode is consist out of  the employee identifier.

All barcodes needs to be prepended and postpendend with character *. These * character will not be translated to the barcode, but are start and end indicators of the barcode font.

PeopleSoft Prerequisite objects

Prerequisites

Before a BI Publisher Template can be created, the barcode generator function needs to available in PeopleSoft. For this a custom view is created that call the function and this view is added to a custom Query Tree to be able to use this view in PeopleSoft Query as input for the Datasource of BI Publisher.

All PeopleSoft object can be found in Application Designer database HCMD project L_BARCODE.

FIELD

Ad first create a Field, which will store the identifier which will present the barcode

Record L_BARCODE_VW

This record will be based on the vanilla view NAMES_VW, so we save the view as L_BARCODE_VW

View SQL

SELECT

 A.EMPLID

 ,A.NAME_TYPE

 ,A.EFFDT

 ,A.LAST_NAME

 ,A.FIRST_NAME

 ,A.MIDDLE_NAME

 ,A.NAME_PREFIX

 ,A.NAME_SUFFIX

 ,A.LAST_NAME_SRCH

 ,A.FIRST_NAME_SRCH

 ,A.NAME_DISPLAY

 ,'*' %Concat A.EMPLID %Concat '*'

 FROM PS_NAMES A

 WHERE A.EFFDT = (

 SELECT MAX(B.EFFDT)

 FROM PS_NAMES B

 WHERE B.EMPLID = A.EMPLID

 AND B.NAME_TYPE = A.NAME_TYPE

 AND B.EFFDT <= %CurrentDateIn)

 AND A.EMPLID = 'K0G001'

To have predictive result ( for this blog) I will retrieve only the data of  emplid =’K0G001′

Query Tree

In order to use record L_BARCODE_VW in PeopleSoft Query as input for Datasources, this record needs to be added to a Query Tree. For this a new Query Tree L_GENERIC_Tree has been created.

(just enter your Access group name and press save)

PermissionList & Role

PermissionList

In order to have user  have access to this Query Tree, this has to added to a Permissionlist. For this a new PermissionList and Role has been created.

PermissionList L_BARCODE_PERM_LIST

Add access group to the permissionlist

Role

Role L_BARCODE_ROLE

And assign the L_BARCODE_ROLE to your user

Create a BI Publisher Template Example

Prior to creating a BI Publisher Report Template, a Datasource has to be created. For this example the Datasource is based on a PeopleSoft Query.

Query

Datasource

Now a datasource needs to be created based on above Query

Generate the XML and the XSD

Click on L_BARCODE_QRY.XML  link to view the generated XML

Save XML locally to be used as input for the BI Publisher Template.

Template

Open Word and click on start and choose Word Option.  After this choose Add-Ins and Manage Templates and click on GO

After this choose Add-Ins and Manage Templates and click on GO

You will now see a Add-Ins menu in the XMLP Desktop menu ribbon.

From the menu choose Data – Load XML Data and select the XML file that was locally saved from the Datasource.

From the menu choose Insert – Field and drag field L Barcode String to the Word area twice.

Now set one of the L Barcode String fields to font 3 of 9.

The field will be shown as barcode and on the runtime the barcode string from the datasource will be translated to the barcode.

Save the template as L_BARCODE.rtf

Report Definition

In order to run the report from PeopleSoft, a Report Definition has to be created.

Use the Upload button to upload the RTF template.

Run the report

output:

‘Hiring new employees or adding contingent workers into the system is one of the most time-consuming tasks for Human Resources departments. Template-Based Hire reduces the current labor-intensive data entry process through the Personal Data and Job Data pages by providing a configurable, template-driven approach. Template Administrators can define default data for various sections or fields in the hiring process and they can determine what sections should be displayed, hidden and made  equired to the end-user. This allows organizations to deploy policy control and flexibility in multiple template configurations for the end-users. This flexibility provides Human Resources departments the ability to decentralize the hiring process out to line managers or HR representatives in the field, rather than only allowing centralized hiring.’

Source: Red Paper Template Based Hire Red Paper for Human Resources 9.0.

Greetings all,

In the previous chapter, we showed the steps to install the “UPK Developer single user” .

In the following chapter we will use the created “Hello World” outline to record and edit a topic.

This chapter will cover the following topics:

-          How do we record a UPK topic?

-          How do we preview a UPK topic?

Recording a UPK topic

In the previous chapter we ended with the following outline.