BookmarkSubscribeRSS Feed
DJWanna
Obsidian | Level 7
Hi, Can anyone share with me how information maps are included into a SAS Enterprise Guide project. It is not very intuitive. Thanks!
3 REPLIES 3
ChrisHemedinger
Community Manager
Hi,

You can start with File->Open->Information Map.

When you select that menu option, you then get to select which information map you want from the list in your repository. Note that you can open only relational information maps (not OLAP maps).

Once you select your map, the data items selection dialog pops up. It might take a few seconds to populate as EG discovers the data items and filters in your map. From there, you can select which data items and filters you want to apply for this information map data source.

When you click OK, EG issues some code (using the INFOMAPS library engine) to extract the selected data from the information map. This works like an import step, pulling the data from the map and storing it in a SAS data set. The data is filtered according to the filters you selected (multiple filters are ANDed together). Note that you get the detail data in this step, not an aggregated view like you might see in SAS Web Report Studio. The detail data is usually more appropriate for use in further analysis.

Each time you rerun the process flow, the map data is refreshed into your SAS session. You can use the result set (a SAS data set) in any subsequent task or SAS program.

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
Hoggy
Calcite | Level 5
Chris

RE: Note that you can open only relational information maps (not OLAP maps) which is backed up by this support note: http://support.sas.com/kb/31/028.html

Are there any plans to enhance EG so it can access OLAP maps?

Cheers
Dave
ChrisHemedinger
Community Manager
Dave,

No immediate plans for OLAP data via InfoMaps with the INFOMAPS engine or within EG.

EG allows you to get to OLAP two ways right now: registered OLAP cubes via metadata, or using "Private OLAP Server" to get to 3rd party cubes such as MS Analysis Services or SAP BW (using OLE DB for OLAP as the connector).

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 770 views
  • 0 likes
  • 3 in conversation