In most businesses, there are many information consumers who need reports from business data, but relatively few IT professionals available to meet their requests.
There is often a backlog of requests that cannot be filled quickly enough to meet the business needs.
One way to reduce this backlog is to empower the end users so that they can create more of their own reports, leaving IT to the business of managing and developing mission critical applications.
Allowing end users access to business data gives them the ability to create reports quickly and make changes as often as needed.
Unfortunately, empowering end users is not as easy as just telling them how to get to the data and turning them loose with Excel spreadsheets.
Most people outside of the IT department are not trained to understand and interpret the complex data structures that store business data.
SAS Information Maps consist of metadata that describe a data warehouse in business terms. This provides the ability to take a ubiquitous data warehouse and surface it to business users in context to the way they work.
Instead of seeing a multitude of tables and columns…
… the user gets a list of business terms that they can select. These items are surfaced with relevant labels that are customized for the business user.
An information map contains metadata about
Because SAS Information Maps consist of metadata, they can contain all the information that allows the application to generate query code.
The data source can be SAS data sets, SAS®9 OLAP cubes, or a third party database such as Oracle, Teradata, DB2, or MS Excel. Information maps can access anything that SAS can read.
Multiple relational data tables can be combined or joined. This allows the application to optimize queries, regardless of the data source.
The information map can store metadata that controls the display and usage of the data items. For example, you can decide that a certain data item should not be used in a sort or to compute statistics.
Standard calculations and filters can be predefined, so business users do not need to re-create them every time they are needed.
Information maps are used by business users when they are asking questions of the data.
Because the warehouse is surfaced in terms they understand, business users can be more self-sufficient with ad hoc questions and reports.
Reporting applications such as SAS Web Report Studio, which is targeted at business users, surface information maps as data sources for queries and reports.
SAS Information Map Studio provides the bridge between your data warehouse and the end user who builds reports from the data.
The SAS Metadata Server manages the metadata and provides security, while the SAS Web Report Studio product enables the user to create reports.
SAS Information Map Studio is a Java application used to create, edit, and manage SAS Information Maps.
The application runs on several Windows operating systems:
End users can access information maps through
SAS Information Map Studio is targeted at data modelers or data architects who
>>Most report writers are consumers of information maps for building reports. Typically, these users do not create information maps.
>>Data modelers or data architects are typically someone in an IT or MIS unit. This person works very closely with the business domain experts to understand the types of questions they need to ask as well as the business context in which they are asked.
Information maps are much more powerful than database views. In addition to surfacing physical database variables, they capture metadata about allowable usage and query generation rules.
OMR – Open Metadata Repository.
Information maps can use different types of application servers as shown below:
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.
Copyright © 2013 - 2022 MindMajix Technologies