Creating an AIMS DataSource

Use the Projects Tree or the Project Configuration dialogue to Create or Edit a new AIMS DataSource.

Configuring the AIMS DataSource

To setup an AIMS DataSource:

• Enter the Server Name
• Enter the API Version to use, mostly v1 for now
• Enter your API Key (you can get one from the provider, Datb)

Configuring the AIMS DataView(s)

DataView have standard and custom configurations areas. This section describes how to setup SQL DataView custom area. Refer to the standard section for information about setting up Parameters, Data Pivot or Calculated Columns.

To create a new DataView, from the DataSource Configuration dialogue click the New DataView button. Refer to the section Configuring a DataView for more ways to create and edit DataViews.

To configure an AIMS DataView:

• Enter a view Name
• Select type of Query to run (currently only 'asset' to get the list of assets)
• Under Item, specify the asset Id you wish to load information from
• The Max Level value let you specify how deep you want to browse the asset tree. Since one asset will have children asset that can have children etc.
• In the Parameters grid, you can add parameters to your query. Unless you are a psychic genius you won't guess them so leave it at those for now:

• expandConstituents: to specify whether to load data for the children asset or not