View

Alchemex

Home > Connector > Data Containers > Adding a View Container

Adding a View Container

Sage Accpac Intelligence supports the use of a View as the source for Data Containers for certain Database systems.

Adding a View Container – Step by Step

  1. In the Connector, add a new Container to your Connection. When prompted to Select the Container Type choose View.
  2. The Container name will default to the View name.
  3. When prompted select the View that you would like to use as the source for this Data Container.
  4. Press OK to complete adding the container.
  5. Right Click on the new Container and choose > Add Expressions. When prompted for the Expression Type to add choose Data Fields.
  6. The list of fields that the View holds will appear. Select those fields which should be available for reporting on and click OK. The Container should now be ready to be used in Reports.