The INFOMAPS Procedure: Creating OLAP-Based SAS Information Maps in Batch Processes

This e-lecture introduces INFOMAPS procedure code to create a SAS Information Map on a SAS cube in a batch process. The code for the procedure is detailed, including the required login arguments for the SAS Metadata Server, the statements to write to the SAS Metadata Server, and the statements that control the data source and data items included in the SAS Information Map. This e-lecture also explores including named sets as a technique to filter a hierarchy and creating folders to simplify the user's experience.

Voraussetzungen
Before listening to this lecture, you should know what a SAS Information Map on a cube is and where it is used, be familiar with SAS Information Map Studio and also with the MDX language.

Zielgruppe
Anyone interested in creating an information map on a SAS cube in a batch process

Module
SAS Information Map Studio

Kursinhalte

• Setting up the Connections to the SAS Metadata Server
  • via the OPTIONS statement
  • in the PROC INFOMAPS statement
• Learning the Syntax for PROC INFOMAPS
  • the PROC INFOMAPS statement
  • the DELETE and OPEN statements
  • the SAVE statement
  • the INSERT DATASOURCE statement
  • the INSERT DATAITEM statement to add a hierarchy or a measure
  • the INSERT DATAITEM statement to add a named set
• Testing the SAS Information Map

zurück...