CLR 110 EXAM QUESTIONS AND
ANSWERS (GRADED A+)
Analytical Reports- - ANSWER-Clarity Data Warehouse
b. Operational Reports - ANSWER-Application Reports, Reporting Workbench
B. Operational Reporting - ANSWER-a. Time-sensitive- reports need to be real-time or
near to real-time
b. Relatively small- small in scale, only doctor's patients instead of all patients
c. Easily accessible-sb able to easily access report, such as in hyperspace
d. Actionable- provider info that can be acted upon within a short time frame
C. Operational reporting tools - ANSWER-a. Application reports- integrated into the
workflows of epic's applications, often tools end users are familiar with, often highly
specialized
b. Reporting workbench- epic's core operational reporting tool that uses a standard
infrastructure to allow flexible reporting on almost any Epic application, built into
hyperspace, allows users to create new reports or modify existing report without
knowledge of programming
D. Advanced/Administrative Reporting Tools - ANSWER-a. These tools used to be only
available in text, but now are often available in hyperspace and have much broader
applicability
b. KB_SQL- epic has a sql report writer module embedded within chronicles for access
to live data that uses a sql variant called kb_sql.kb_sql's main use is as part of the
clarity extract process. Can convert sql syntax into an equivalent search through the
chronicles data structure
c. Chronicles ad hoc- available only to text -side users, very flexible, requires little setup
and can effectively search any master file for any value in any item, limited formatting
and presentation capabilities
d. M Script- M is the programming language on which chronicles is built and used to
write all or epic's applications
E. Analytical Reporting - ANSWER-a. A report needed not as a real-time source of data
in order to drive a workflow, but as a tool to be used in long term decision making
b. Characteristics:
i. Comprehensive- designed to make sense out of large patterns
ii. Summarized-grouped and summarized
iii. Standardized-readers are often management types who expect reports presented in
a certain format
c. Use clarity or caboodle as a data source
, F. Clarity - ANSWER-extracts data from chronicles db and stores in a relational db on a
separate, dedicated reporting server.
G. Caboodle - ANSWER-epic's enterprise data warehouse. Part of cogito ergo sum
enterprise intelligence suite
a. A data warehouse provides a central repository for an organizations data from
potentially multiple sources, combines data from clarity and third party data sources.
Caboodle is downstream from clarity
H. Data lineage- - ANSWER-the stream of where a column's data comes from
I. Advantages to meeting an analytical need with clarity or caboodle - ANSWER-a.
Performance-running your report on a separate db will not impact your end users in
production. Can run very large reports
b. Flexibility- crystal and other tools provide flexibility to pull from these industry
standardized databases
J. Limitations of clarity and caboodle- problems - ANSWER-a. Real-time data- data is
not real time
b. Interactivity- often delivered by email
K. Analytical reporting tools - ANSWER-a. Crystal reports and SQL are tools that
access clarity and caboodle data
L. Business objects universes- - ANSWER-designed to simplify the reporting process,a
universe acts as a logical layer between db and the end user, universes can be built off
of clarity or caboodle
M. Cubes - ANSWER-a. An OLAP (online analytical processing) cube is an actual
physical structure (as opposed to logical layer) that is preaggregated for speed
N. Report Distribution Mechanisms - ANSWER-a. Epic-BI Integration- a report run off of
clarity of caboodle data can be configured to appear in the myreports activity
hyperspace alongside reporting workbench reports
i. You can subscribe by adding them to their favorites, can run on demand
b. Radar- epics portal that hosts personalized home pages to display epic data, reports,
and links to other pages. Front end for my reports activity
a. What is the difference between operation and analytical reports? - ANSWER-i.
Operational is time-sensitive, more interactive, smaller in scale. Needed by end users to
do their jobs
ii. Analytical is larger in scale, older data, less interactive, good for grouping and
summarizing, over time reports that show long term trends and data
b. Why should you use clarity for analytical reporting needs? - ANSWER-i. Very large
sets of data can be run without slowing down production server
ANSWERS (GRADED A+)
Analytical Reports- - ANSWER-Clarity Data Warehouse
b. Operational Reports - ANSWER-Application Reports, Reporting Workbench
B. Operational Reporting - ANSWER-a. Time-sensitive- reports need to be real-time or
near to real-time
b. Relatively small- small in scale, only doctor's patients instead of all patients
c. Easily accessible-sb able to easily access report, such as in hyperspace
d. Actionable- provider info that can be acted upon within a short time frame
C. Operational reporting tools - ANSWER-a. Application reports- integrated into the
workflows of epic's applications, often tools end users are familiar with, often highly
specialized
b. Reporting workbench- epic's core operational reporting tool that uses a standard
infrastructure to allow flexible reporting on almost any Epic application, built into
hyperspace, allows users to create new reports or modify existing report without
knowledge of programming
D. Advanced/Administrative Reporting Tools - ANSWER-a. These tools used to be only
available in text, but now are often available in hyperspace and have much broader
applicability
b. KB_SQL- epic has a sql report writer module embedded within chronicles for access
to live data that uses a sql variant called kb_sql.kb_sql's main use is as part of the
clarity extract process. Can convert sql syntax into an equivalent search through the
chronicles data structure
c. Chronicles ad hoc- available only to text -side users, very flexible, requires little setup
and can effectively search any master file for any value in any item, limited formatting
and presentation capabilities
d. M Script- M is the programming language on which chronicles is built and used to
write all or epic's applications
E. Analytical Reporting - ANSWER-a. A report needed not as a real-time source of data
in order to drive a workflow, but as a tool to be used in long term decision making
b. Characteristics:
i. Comprehensive- designed to make sense out of large patterns
ii. Summarized-grouped and summarized
iii. Standardized-readers are often management types who expect reports presented in
a certain format
c. Use clarity or caboodle as a data source
, F. Clarity - ANSWER-extracts data from chronicles db and stores in a relational db on a
separate, dedicated reporting server.
G. Caboodle - ANSWER-epic's enterprise data warehouse. Part of cogito ergo sum
enterprise intelligence suite
a. A data warehouse provides a central repository for an organizations data from
potentially multiple sources, combines data from clarity and third party data sources.
Caboodle is downstream from clarity
H. Data lineage- - ANSWER-the stream of where a column's data comes from
I. Advantages to meeting an analytical need with clarity or caboodle - ANSWER-a.
Performance-running your report on a separate db will not impact your end users in
production. Can run very large reports
b. Flexibility- crystal and other tools provide flexibility to pull from these industry
standardized databases
J. Limitations of clarity and caboodle- problems - ANSWER-a. Real-time data- data is
not real time
b. Interactivity- often delivered by email
K. Analytical reporting tools - ANSWER-a. Crystal reports and SQL are tools that
access clarity and caboodle data
L. Business objects universes- - ANSWER-designed to simplify the reporting process,a
universe acts as a logical layer between db and the end user, universes can be built off
of clarity or caboodle
M. Cubes - ANSWER-a. An OLAP (online analytical processing) cube is an actual
physical structure (as opposed to logical layer) that is preaggregated for speed
N. Report Distribution Mechanisms - ANSWER-a. Epic-BI Integration- a report run off of
clarity of caboodle data can be configured to appear in the myreports activity
hyperspace alongside reporting workbench reports
i. You can subscribe by adding them to their favorites, can run on demand
b. Radar- epics portal that hosts personalized home pages to display epic data, reports,
and links to other pages. Front end for my reports activity
a. What is the difference between operation and analytical reports? - ANSWER-i.
Operational is time-sensitive, more interactive, smaller in scale. Needed by end users to
do their jobs
ii. Analytical is larger in scale, older data, less interactive, good for grouping and
summarizing, over time reports that show long term trends and data
b. Why should you use clarity for analytical reporting needs? - ANSWER-i. Very large
sets of data can be run without slowing down production server
