Almost in every project, this is one of the requirements to get the Current and Previous EFFDTed rows (from JOB table).
Most of the times, we will use the Self Join SQL to get the same.
SELECT
A.EMPLID, A.EFFDT CURR_EFFDT, B.EFFDT PREV_EFFDT
FROM PS_JOB A, PS_JOB B
WHERE
B.EFFDT =(SELECT [...]
From the yearly archives:
2007
Continuing from my
previous post…
Here are the steps to implement the Fine Grained Access Control feature to mimic the row-level security in your PeopleSoft online Query Manager.
Let’s for a moment accept the hypothesis that the true intent of Business Intelligence is to help organizations manage their business better. “Better” in this context tends to be a rather elastic adjective as it straddles the entire spectrum of firms using BI for simple management reporting to the other extreme of using BI to [...]
Most of the times we would have faced a requirement of having Dynamic prompt table for Record Fields. Also PeopleSoft itself very much utilizes Dynamic Prompt table. How can we achieve the same in our project????
Here we go
This is accomplished by 2 ways
Using EDITTABLE fields for Prompt Table
Using Dynamic Views
1. Usage of EDITTABLE Fields
In [...]
How to schedule an employee in a work group schedule?
Login to Kronos Timekeeper Central through the web browser using a Super Access / Super User Profile
Under the My Genies menu of the navigation bar, click on the “Quick Find” Submenu
The quick find genie would be displayed in the navigation bar
In the Name or ID field [...]
Today, I will demonstrate use of Fine Grained Access Control to create row-level security for the database to mimic the row level security setup in the PeopleSoft application. Let me start with asking a few questions.
Most of the projects have the below mentioned scenarios…..
FTPing the file from one server location to another
Deleting the file
We can simply execute those in SQR by using CALL SYSTEM built-in…Here is the syntax
CALL SYSTEM Using $del_file #del_status Wait
if edit(#del_status,’9′) = ‘0′
show ‘intfiles.txt was deleted sucessfully’
end-if
$del_file – Specifies the operating system command to execute. The command [...]
Following are the design aspects towards getting a DI system dynamic
Avoiding hard references, usage of parameter variables
Usage of lookup tables for code conversion
Setting and managing threshold value through tables
Segregating data processing logics into common reusable components
Ensuring that the required processes are controllable by the Business team with the required checks built in
In this blog, I will answer two questions.
How to trace AE?
There are a few ways to trace an AE program. You can enable the trace using some of the below methods:
In the process scheduler configuration file psprcs.cfg
You can enable the trace in the“Process Definition”.
Grab the Oracle [...]
In the last 2 posts, we looked at the way Agile Framework can be implemented to manage BI systems. Diagram below is intended to reiterate the process of Agile Framework implementation with its Planning & Execution phases.
Having taking care of managing the evolution of enterprise BI systems, the next important aspect of implementation is “How [...]
