BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi All,

How to define a custom hierarchy in information map studio? in my scenario i am using a table. but using the table from rdbms plss lemme know how to create a hirerachy for particular dimensions?


can we define a custom hirerachy using sas programming code?..if so plss lemme know how to do?

With Regards,
Mahi

Message was edited by: mahi_kool Message was edited by: mahi_kool
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
Tables are single tables of data - and in an information map, you can specify how multiple TABLES can be joined together and you can define the relationships between the various tables. In this way, the consumer of the information map does not have to worry about the complexity of the underlying data, the physical storage and/or the database or file schema. For example, you could have one table with vendor names and vendor IDs and a second table with vendor IDs and vendor products and a third table with vendor IDs and addresses. In an information map, you can control the join that takes place so that a report person could get a report that showed vendor name, product and vendor address all on one report -- without having to worry about knowing how to join the 3 separate tables. There is no hierarchy definition or possibility of a hierarchy definition in this information map that joins these 3 tables together.

On the other hand, the term "hierarchy" refers to a concept that relates to multi-dimensional data sources -- also called OLAP cubes. An OLAP cube is a unique type of data source. Usually, the hierarchies for an OLAP cube are defined by the cube developer using either OLAP Cube Studio or other tools. This paper gives a good overview of OLAP cubes in the context of the BI Platform.
http://www2.sas.com/proceedings/forum2008/182-2008.pdf

cynthia

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
  • 1 reply
  • 559 views
  • 0 likes
  • 2 in conversation