|
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).
|
.gif){kind=spacer}
.gif){kind=spacer}
