The INFOMAPS Procedure

Syntax: INFOMAPS Procedure

PROC INFOMAPS
<DOMAIN="authentication-domain">
<MAPPATH="location>"
<METACREDENTIALS=YES|NO>
<METAPASS="password">
<METAPORT=port-number>
<METASERVER="address">
<METAUSER="user-ID">;

DELETE INFOMAP "information-map-name"
<MAPPATH="location">;

EXPORT
FILE=fileref |"physical-location"
<INFOMAP "information-map-name">
<MAPPATH="location">;

IMPORT
FILE=fileref |"physical-location";

INSERT DATAITEM
COLUMN="data-source-ID"."column-name" | EXPRESSION="expression-text" | HIERARCHY="dimension"."hierarchy" | MEASURE="OLAP-measure"
<ACTIONS=(actions-list)>
<AGGREGATION=aggregate-function>
<AGGREGATIONS_DROP_LIST=(aggregate-function-list)>
<AGGREGATIONS_KEEP_LIST=(aggregate-function-list)>
<CLASSIFICATION=CATEGORY | MEASURE>
<CUSTOM_PROPERTIES=(custom-properties-list)>
<DESCRIPTION="descriptive-text">
<FOLDER="folder-name" | "folder-location" </CREATE>>
<FORMAT="format-name">
<ID="data-item-ID">
<NAME="data-item-name">
<TYPE=NUMERIC | CHARACTER | DATE | TIME | TIMESTAMP>
<VALUE_GENERATION=NONE | DYNAMIC | (custom-value-list)>;

INSERT DATASOURCE
SASSERVER="application-server-name"
TABLE="library"."table" <COLUMNS=(column-1 <... column-n>) | _ALL_>
<DESCRIPTION="descriptive-text">
<ID=data-source-ID>
<NAME="data-source-name">;

INSERT DATASOURCE
SASSERVER="application-server-name"
CUBE=<"schema".>"cube" <_ALL_>
<DESCRIPTION="descriptive-text">
<ID=data-source-ID>
<NAME="data-source-name">;

INSERT FILTER
CONDITION="conditional-expression"
<CUSTOM_PROPERTIES=(custom-properties-list)>
<DESCRIPTION="descriptive-text">
<FOLDER="folder-name" | "folder-location" </CREATE>>
<ID="filter-ID">
<NAME="filter-name">;

INSERT FOLDER "folder-name"
<CUSTOM_PROPERTIES=(custom-properties-list)>
<DESCRIPTION="descriptive-text">
<LOCATION="parent-folder-name" | "parent-folder-location" </CREATE>>;

LIST <DATAITEMS | DATASOURCES | FILTERS | RELATIONSHIPS | _ALL_> ;

MOVE DATAITEM "data-item-ID" | ID_LIST=("data-item-ID-1" <... "data-item-ID-n">)
NEW_LOCATION="new-folder-location" </CREATE>;

MOVE FILTER "filter-ID" | ID_LIST=("filter-ID-1" <... "filter-ID-n">)
NEW_LOCATION="new-folder-location" </CREATE>;

MOVE FOLDER "folder-name"
NEW_LOCATION="new-folder-location" </CREATE>
<LOCATION="current-folder-location">;

SAVE
<INFOMAP "information-map-name">
<MAPPATH="location" </CREATE>>;

SET STORED_PROCESS
NAME="stored-process-name"
<LOCATION="stored-process-location">;

UPDATE DATASOURCE "data-source-ID"
<NAME="data-source-name">
<DESCRIPTION="descriptive-text">
<ID="new-data-source-ID">;

UPDATE FILTER "filter-ID"
<CONDITION="conditional-expression">
<CUSTOM_PROPERTIES=NONE | ADD (custom-properties-list) |
REPLACE (custom-properties-list) | REMOVE (property-names-list)>
<DESCRIPTION="descriptive-text">
<ID="new-filter-ID">
<NAME="filter-name">;

UPDATE FOLDER "folder-name"
<CUSTOM_PROPERTIES=NONE | ADD (custom-properties-list) |
REPLACE (custom-properties-list) | REMOVE (property-names-list)>
<DESCRIPTION="descriptive-text">
<LOCATION="current-parent-folder-name" | "current-parent-folder-location">
<NAME="new-folder-name">;

Top of Page