ZENworks® ESM 3.5 Administrator’s Manual 49
Figure 26 : Report Document Properties
• The report may not contain any sub-reports.
• Filtering parameters must be named the same as the target columns within the database
fields of the table or view.
Figure 27 : Available Database Fields
What reporting information is available?
The ESM reporting database is designed to closely model the star schema format. What is a star
schema? A single "fact" table containing a compound primary key, with one segment for each
"dimension," and additional columns of additive, numeric facts.
The Reporting Service includes the following two dimension tables:
ORGANIZATION_DIM: The organization table, defining the instances of users, groups,
organizational units, containers and services in a hierarchal relationship. Each row represents one
of these units.
UNIT_MEMBER_DIM: Association of organization units to other organization units. For
example, while a user may be stored within a specific container within Active Directory, he/she
