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 inst...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller shantelleG. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.