|
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).
|
