If you want to use a Information Map as a data source for tasks such as DI Studio Jobs, Stored Processes, or building OLAP cubes, you can create a SAS Library that points to a folder that contains the Information Maps.
Each Information Map then gets treated as a table in the library.
To do this either use the following SAS code:
libname ImapLib sasioime
user=”username”
pw=”password”
metaserver=”servername”
metaport=8561
metarepository=”Foundation”
mappath=”/BIP Tree/InfoMaps/sales”
Of course you need to add your on environment settings for the variables.
Or you can create it in metadata by creating a libname with:
- Create a generic libname
- Type = sasioime
- Options = user=”username” pw=”password” metaserver=”servername” metaport=8561 metarepository=”Foundation” mappath=”/BIP Tree/InfoMaps/sales”
Issues to be aware of:
- It is slow as you are going through multiple layers to get to the data (i.e Libname > Infomap > Query and Reporting Services > Libname > Data)
- The user is hard coded for the libname
- If the libname has fields defined with gaps in the names the SAS Libname will not show the column.
Recent Comments