Application Server Settings

You may need to edit the OneStream Application Server Configuration so users can create and change data in the additional database tables. If other OneStream Solutions (such as Specialty Planning) are already in the application, these adjustments may already exist.

See Solution Database Migration Advice.

Configure the OneStream Application Server

Be sure that the security group settings include the users who work on and set up the solution before proceeding.

NOTE: Group settings are applicable to all OneStream Solutions; it is important to keep the group names generic.

  1. Start the OneStream Server Configuration Utility as an Administrator.

  2. Click Open Application Server Configuration File > Database.

  3. Edit the following OneStream Database Server properties:

  • Access Group for Ancillary Tables: Select a group that includes those who will access records.

  • Can Create Ancillary Tables: True

  • Can Edit Ancillary Table Data: True

  • Maintenance Group for Ancillary Tables: Select a group to edit and maintain tables.

  • Table Creation Group for Ancillary Tables: Select a group who can create tables.

  1. Restart Internet Information Server.