2707316 - How to view all database tables within Plateau Report Designer (PRD)

Admin would like to ensure that they are viewing all the LMS database tables and views which are available to access within Plateau Report Designer (PRD).

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors Learning

1. Connect to Plateau Report Designer using your VJDBC connection details
2. Open an existing report and expand a Data Set. Under the Available Items section expand the Data Source (if necessary) to reveal your Schema.
3. 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 tables are displayed for your Schema

1. Within PRD, navigate to Window > Preferences > Report Design > Data Set Editor > JDBC Data Set
2. Note the value for the 'Maximum number of tables in each schema to display:' configuration
3. Adjust this value to your preference. According to the latest version of the Data Dictionary there are approximately close to 1500 tables and views. Have set this example therefore to the same or even to a slightly higher number (e.g. 1700) to ensure any new tables will also be included in your view.
   
   
   

2326249 - How to find the latest version of LMS data dictionary

2379690 - Custom Report Development and Support - LMS

PRD. Plateau Report Designer, tables, views, schema, VJDBC, Maximum number of tables in each schema to display, Preferences , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-CRI , Custom Report Issues , How To