Desktop productivity for business analysts and programmers

Custom Hirerachy in SAS BASE 9.1

Posts: 0

Custom Hirerachy in SAS BASE 9.1

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,

Message was edited by: mahi_kool Message was edited by: mahi_kool
Posts: 8,720

Re: Custom Hirerachy in SAS Information Map 3.1

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.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation