Configuring Projects Capitalizable Flag for PeopleSoft

You can configure Project Capitalizable flag in Project dimension for Peoplesoft source, based on the project type.

Project Capitalizable Flag is associated against Project Type in flat file file_project_capitalizable_flag_psft.csv.

The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:

Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.
Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.

Note:

If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows: 1. From the Tasks bar, click Define Business Intelligence Applications. 2. Click Actions, then Manage Source Configuration Data Files. 3. Click the Export Source Configuration Data Files option on the tool bar. 4. Move the required files to the right hand list, then click Export.

Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.

Identify the Project Type Class Codes by using the following SQL (to be run in OLTP source):

SELECT T.PROJECT_TYPE||'~'||T.SETID AS PROJECT_TYPE
FROM PS_PROJ_TYPE_TBL T
WHERE T.EFFDT = (SELECT MAX(EFFDT)
               FROM PS_PROJ_TYPE_TBL T1
               WHERE T1.SETID = T.SETID AND T1.PROJECT_TYPE = T.PROJECT_TYPE
               AND T1.EFFDT <= CURRENT_TIMESTAMP
               GROUP BY T1.SETID, T1.PROJECT_TYPE)

Edit the file file_project_capitalizable_flag_psft.csv.
Copy the data from the PROJECT_TYPE column to the PROJECT_TYPE_CLASS_CODE column in the CSV file.
Map each Project Type Class to a value of Y or N in the CAPITALIZABLE_FLG column.

If the Project Type Class is considered capitalizable, enter Y. Otherwise, enter N.
Save and close the file.