SAS Visual Data Builder
has the following limitations and restrictions for working with information
maps:
-
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.