Changing the database name

The default name for the Planning relational database is Planning. The Planning relational database stores the Workforce Budgeting data. If you specify a different name for the Planning relational database, you need to change the value for the RelationalSchema variable and the alias to ensure that the Workforce Budgeting supplemental reports run. These changes are made in Application Studio.

To change the database name:

  1. Start Application Studio and open the Log On dialog box.
  2. From the Repository list, select Financial Applications.
  3. In the Report Catalog pane, expand Reports.
  4. Select the Start report.
  5. Click Design on the Mode toolbar to switch to design mode.
  6. In the Accessories pane, expand Report Variables.
  7. Go to the RelationalSchema variable.
  8. Change the value of the variable from Planning to the name of your relational database.
  9. Click Save.
  10. In the Report Catalog pane, expand Reports.
  11. Right-click the Start report and select Check-in/out > Check-in. If you are logged in to Dashboards when checking in the changes, you must log out and log back in to see the checked-in changes.
  12. In the Database Structure pane, expand Database Alias.
  13. Right-click Workforce Budgeting Detail and select Log Off.
  14. Right-click Workforce Budgeting Detail and select Edit.
  15. When prompted, click Yes.
  16. In the Database box, specify the name of your relational database.
  17. Click Test Connection.
  18. Click OK.
  19. Click Close.
  20. Right-click Workforce Budgeting Detail and select Log On.
  21. Exit Application Studio.