BookmarkSubscribeRSS Feed
s_p_kumar
Calcite | Level 5
I am using information map studio and WRS.
I am trying to design information map version 4.2 for multiple reports to be created in WRS.what are most important factors in deciding How many information maps to design
Is there limit on data items for single information map.
Is there some rough idea .
or is there some document which can help.
2 REPLIES 2
mojerry2
Fluorite | Level 6

dear,

There's not really a document explaining how to think about imap and reports. It's more a logic thinking.

Check the number of reports who are going to get data from the same tables. Make grouping. These reports then are using the same information map.

But, yes there's always a but, think about the number of joins between tables. If you have a report who's using two tables (A and B) and your other report is using also A but C check the performance because the imap will join the 3 tables before the reporting.

the amount of records is also important, if your tables are small then you can have a huge imap.

kind regards

Madelyn_SAS
SAS Super FREQ

The limit is a practical one. If you create an information map with hundreds or thousands of data items, then the performance is going to be poor.  In addition, information maps are intended to provide an easy interface to a specific subset of data to non-technical end users. So, typically, you would not simply create information maps that include all columns from a data source. For instance, a report creator will likely have a difficult time trying to navigate through 2000 data items to find just those data items that are useful for one report, even if the data items are in separate folders. Instead, you should create multiple information maps, each containing a selected number of columns that serve a particular reporting need.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 1012 views
  • 2 likes
  • 3 in conversation