To ensure that as an administrator, you are viewing all the LMS database tables and views which are available to access within PRD.
SuccessFactors Learning Management System (LMS) - All Supported Versions
PRD - Plateau Report Designer
Reproducing the Issue
- Connect to Plateau Report Desinger using your VJDBC connection details.
- Open an existing report and expand a Data Set. Under the Available Items section expand the Data Source (if necessary) to reveal your Schema.
- Expand the Schema and note that some of the tables and views which were expected to be displayed are not available.
The Preferences options within PRD need to be updated so that all are displayed for your Schema
Within PRD, navigate to Window > Preferences > Report Design > Data Set Editor > JDBC Data Set
Note the value for the 'Maximum number of tables in each schema to display:' configuration
Adjust this value to your preference. According to the latest version of the Data Dictionary there are approximately close to 1300 tables and views. Have set this example therefore to 1500 so it should display all.
2326249 - How to find the latest version of LMS data dictionary
PRD. Plateu Report Designer, tables, views, schema, VJDBC, Maximum number of tables in each schema to display, Preferences , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-REP , Reporting Data , How To