|
Speed Enterprise Reporter
is the only general reporting tool that can actually be used by
novices who have no understanding of SQL and tables relationship.
Many other enterprise reporters though user friendly, are only
able to report data elements predefined within the OLAP. Other
more generic reporting tool, requires understanding of table structure
and SQL to design a report.

Instead of tables and fields, users are accessing Subjects and
Shortcuts which are more meaningful.
Gender is represented by "PatientFK->GenderFK->GenderDesc"
which in other system, will be the complex SQL below:
SELECT Gender.GenderDesc As Gender FROM Gender
INNER JOIN (Patient INNER JOIN Episode ON Patient.ID =Episode.PatientFK)
ON Gender.ID=Patient.GenderFK;
Shortcuts can also be routines (written using VB scripting or
Caché Object Scripting).
Speed Enterprise Reporter intelligently
modifies the parameter according to the base class (e.g. From
Patient class, Gender should be GenderFK->GenderDesc, but from
Episode class, PatientFK-> will be added in front automatically).
|