This page provide you information to see the different tables, Views and stored procedure available to use in the PLATUE REPORT DESIGNER (PRD). You can also see the columns and its Data Type used in the table.
NOTE: Steps in this job aid are slightly different depending on how you define preferences under Window > Preferences > Report Design > Data Set Editor > JDBC Data Set. This graphic shows the default settings:
SuccessFactors suggests that you uncheck Prefetch all Schemas, then set Maximum number of schemas to 1. You can set Maximum number of tables to any value you wish.
1. Access the data set and navigate to Query > middle of the screen, Available Items.
a. If you have left default preferences, you will see a screen similar to this one:
Select the schema name, in this case PLATEAU, from the Schema dropdown list. Then select Apply Filter.
b. If you have changed preferences and do not pre-fetch schemas, TYPE your schema name into the Schema field, then select Apply Filter. You can expand the schema now to list the tables.
Hosted customers need to know their schema ID such as ACME_STAGING or ACME_SBX.
If you do not know your schema: Set preferences temporarily to prefetch all schemas and set maximum number of schemas at a high number. After you find YOUR schema from the list, write down the schema ID for future use. Then set the preferences back to the suggested values.
2. Use a filter to limit the tables returned to a subset of tables you want to browse. The filter is case sensitive.
This filter finds table names that This filter finds table names that start with
start with PA_ CPNT PA_ and end with _CPNT
3. After finding the table, expand the list of fields:
Note: You can drag a field from this list and drop it into your query. However, you will pick up the schema owner (below, shown as PLATEAU) and the full table name.
You need to edit this to remove the schema owner and use the same alias as is used in the query. In the query shown below, “e” is the alias for the PA_CPNT_EVTHST table