Limitations and Restrictions

The data builder can use information maps that are based on relational tables. Information maps that are based on OLAP cubes cannot be used.

The information map cannot use more than 50 physical tables. A table that is used more than once in a self join counts as one physical table.

The information map cannot use more that 5000 physical columns. A column that is used in more than one data item counts as one physical column.

Prompts are not supported. Even if a prompt has a default value, the default value is not included.

Data items that are based on business data are not supported. For example, the equation Dataitem1 = Year + 2 (where Year is a data item) is not included in the data query.

Data items that are based on physical columns are not supported. For example, the equation Dataitem2 = FirstName || LastName (where FirstName and LastName are columns) is not included in the data query.

The output table is automatically named with the same name as the map. The name field is limited to 32 characters.