PAT_ENC is an overtime single table extracting data from the EPT master file. It contains 1 row for every encounter. The primary key is PAT_ENC_CSN_ID. PAT_ENC_DX is an overtime multiple table that also extracts data from the EPT master file. It contains 1 line for every diagnosis associated with an encounter. The primary key is PAT_ENC_CSN_ID and LINE.
Part 1 of 2
If you were to join from PAT_ENC_DX to PAT_ENC, what should be the join condition?
Select one of the following (1 PT)
A hospital needs to benchmark its patient satisfaction scores against Epic community data in a Radar dashboard, with drill-down to survey details, dynamic thresholds based on department, and export to external systems. Which configuration achieves this complex requirement?
A Reporting Workbench report must calculate readmission rates by provider using Clarity data. How should this be set up?
To create an interactive dashboard with a component that launches a Hyperspace activity with context from a table row, such as loading a patient ' s chart and navigating to a specific section based on report data, what advanced parameter syntax in the link?
In an advanced scenario, a dashboard with parameters linked to multiple components fails to update a metric component sourced from IDN when the parameter value changes to a non-standard value like a list of IDs. The metric definition uses a complex formula with dependencies on external resources. What could be the cause, and how to fix?
A SlicerDicer session in a dashboard component shows incomplete data for patient admissions. The session uses the Admissions data model. What could resolve this issue?
What must be true before you can share a SlicerDicer session with another user?
A dashboard component must display real-time patient triage data. Which data source and configuration ensure this?
You ' re tasked with identifying patients with asthma who have had more than two ER visits in the last year. What ' s the most efficient setup?
A Reporting Workbench report must calculate readmission rates by department using Clarity data. How should this be set up?
Jason adds filters to display only patients seen in Cardiology. What is the correct method?
A Radar dashboard component displays incorrect patient satisfaction scores due to a SlicerDicer session pulling data from an outdated Caboodle extract. The session uses the Patients data model, and the dashboard is enabled. How should the analyst resolve this?
A dashboard component ' s Hyperspace activity link works for administrators but not for standard users. What is the likely cause?
A Cogito SQL report, sourced from Clarity, groups ED visits by triage level and calculates multiple metrics (e.g., average wait time, patient volume), with a trace log. The report must be restricted to ED managers, support Epic benchmarking export, and allow dynamic filtering by shift. Which configuration is correct?
Who is responsible for maintaining the real-time operational database in Epic?
In an advanced dashboard with SlicerDicer and metric components, a parameter change updates SlicerDicer but lags for metrics. To synchronize in real-time for complex queries, what?
A Radar dashboard component, linked to a SlicerDicer session using the Admissions data model, displays outdated patient admission data from Caboodle and lacks drill-down to admission details. Some users report inconsistent threshold indicators. How should the analyst resolve these issues?
A dashboard component must display a pie chart of patient demographics. Which configuration is required?
What information do you need about an item in Chronicles to find its data in Clarity?
Select one of the following (1 PT)
Which of the following is a way to allow a user to access a dashboard in Hyperspace? Select all that apply:
A dashboard component must display real-time patient triage data with a link to the Triage Assessment activity and dynamic thresholds based on triage level. Which data source and configuration ensure this complex functionality?
A Radar dashboard component, linked to a SlicerDicer session using the Encounters data model, displays outdated patient discharge data from Caboodle and lacks drill-down to discharge summaries. Some users report inconsistent threshold indicators and no export capability. How should the analyst resolve these issues?
Maria wants to reuse a metric released by Epic in her own organization ' s dashboard. What should she do first?
A dashboard component ' s colored indicators fail to reflect department-specific, acuity-adjusted thresholds for a table of ED metrics. The component uses Dashboard Resources and a SlicerDicer session. Some users report no drill-down to encounter details. Where should adjustments be made, and what enables drill-down?
A provider wants to see the number of diabetic patients across clinics. What would you use?
Which tool schedules and monitors the extraction of data from Chronicles to Clarity?
Select one of the following (1 PT)
I EPT 16163 has an add type of no add and a response type of multiple. I EPT 19165 has an add type of response each time and a response type of multiple.
Part 1 of 2
Based on its add type and response type, which column(s) would you expect in the primary key of the table extracting item EPT 19165?
Select one of the following (2 PTS)
What ' s the benefit of using a Report Model over building from a template directly?
A provider wants to identify diabetic patients with A1C > 9.0 and break them down by clinic. What is the best configuration?
A Reporting Workbench report, sourced from Chronicles, fails to execute for some users due to a custom filter for high-risk patients, despite a trace log and Ready for Use status. The report groups data by provider and calculates readmission risk, but some users report no benchmarking export. What are the issues, and how should they be resolved?
A healthcare system wants to compare its ED triage times with Epic community benchmarks in a Radar dashboard. The component must allow drill-down to individual cases. Which configuration enables this?
A Cogito analyst is tasked with building a Radar dashboard to monitor patient no-show rates across clinics, using a SlicerDicer session based on the Appointments data model. The dashboard must include a component with drill-down to patient records, benchmark no-show rates against Epic community data, and restrict access to clinic administrators. The component fails to display in the Analytics Catalog, and some authorized users report inconsistent data. Which combination of steps resolves these issues and meets all requirements?
An analyst creates a Reporting Workbench report to track medication reconciliation errors, grouped by department and clinician, with a custom calculated column for error rates derived from Chronicles data. The report must be restricted to quality assurance leads, include a trace log, and allow export to Epic ' s benchmarking database. Which configuration ensures these requirements are met?
Operational reports must have which of the following characteristics? Select all that apply.
A women ' s health provider wants to identify all patients aged 50-75 who are overdue for mammograms. What would you do in SlicerDicer?
If a user can ' t view a particular SlicerDicer data model, what ' s likely the issue?
A Reporting Workbench report, sourced from Chronicles, fails to execute for some users due to a custom filter for high-cost patients, despite a trace log and Ready for Use status. The report groups data by department and calculates cost variance, but some users report no benchmarking export. What are the issues, and how should they be resolved?
In a complex dashboard with metric-based components linked to Caboodle, a user reports intermittent data corruption despite valid Clarity extracts. The metrics are derived from custom resource definitions in IDN, and the issue occurs only for certain user roles during peak ETL loads. What advanced troubleshooting step would you recommend first?
A healthcare system aims to benchmark its ED overcrowding metrics against Epic community data in a Radar dashboard, with drill-down to patient triage records and dynamic thresholds based on shift hours. Which configuration achieves this complex requirement?
A metric-based component on a Radar dashboard shows inconsistent data for users in different regions. The component uses Dashboard Resources and is configured with summary targets. What could cause this issue?
Which master file stores data values for metrics as they appear on a dashboard?
A Radar dashboard component, linked to a SlicerDicer session using the Patients data model, displays outdated vaccination rates from Caboodle and lacks drill-down to patient charts. Some users report inconsistent threshold indicators and no export capability. How should the analyst resolve these issues?
A dashboard component fails to open a linked Hyperspace activity for certain users, despite a correct activity descriptor and Dashboard Resources as the data source. The dashboard is accessible. What is the cause?
A Reporting Workbench report omits data for a specific hospital wing. The report uses Chronicles. What is the issue?
A user reports inability to interact with a Radar dashboard ' s annotation component, despite accessing the dashboard via the Analytics Catalog. The user has appropriate security roles, and the component is enabled. What should be modified?
An analyst needs to ensure a Radar dashboard is only visible to clinical staff. Where should this be configured?
A dashboard component displaying surgical case delays requires dynamic, surgeon-specific threshold indicators that adjust based on case volume. The component uses Dashboard Resources and is linked to a SlicerDicer session. Which configuration enables this advanced functionality?
Why can ' t you view the data displayed by components in another user ' s dashboard while in Proxy Mode?
A Reporting Workbench report, sourced from Chronicles, fails to execute for some users due to a custom filter for chronic disease patients. The report includes a trace log and is Ready for Use. What could be the issue?
A user ran a report to list all geriatric patients. They now want to see only those who have arthritis. How can they do this without re-running the report?
A SlicerDicer session in a dashboard component, using the Encounters data model, shows incomplete data for patient readmissions despite correct filters and a Ready for Use dashboard. The session is linked to Caboodle, and some users report no data visibility. What is the root cause, and how should it be resolved?
When designing a metric for advanced dashboarding that calculates rolling 30-day averages from Caboodle facts tables, but the component shows lagged data. What advanced ETL configuration might be the timeliness?
A metric-based Radar dashboard component, linked to a SlicerDicer session, displays varying patient satisfaction scores across regions, despite using Dashboard Resources and a correctly configured session in Caboodle. The dashboard is enabled, but regional managers report discrepancies in colored threshold indicators. What configuration is likely causing this, and how should it be resolved?
A user with appropriate security roles can view a Radar dashboard but cannot post to its collaborative feedback component, despite other users posting successfully. The dashboard is accessible via the Analytics Catalog, and the component is enabled. The user also reports no drill-down capability. What should the administrator do to resolve these issues?
A Radar dashboard component is not appearing in the Analytics Catalog despite being enabled on an active dashboard. The dashboard is marked Ready for Use. What is the likely cause?
A Radar dashboard component, linked to a SlicerDicer session using the Admissions data model, displays outdated patient admission data from Caboodle and lacks drill-down to admission details. Some users report inconsistent threshold indicators and no export capability. How should the analyst resolve these issues?
A hospitalist wants to see how many inpatient encounters involved sepsis over the last 90 days and visualize it by day. What should they do?
You want to return I EMP 14300: Default User Role and I EMP 600: Login Instant by your query.
Part 1 of 2
What tool would you use to look up the table and columns that extract these items?
Select one of the following (1 PT)
In an advanced dashboard with multiple views, to switch views dynamically based on a parameter value (e.g., " detail " vs " summary " ), what configuration in the Layout form is required?
What restrictions exist for the Chronicles items underlying the columns returned by a view?
Select one of the following (1 PT)
What information can the Item Editor provide about a Chronicles item?
Select one of the following (1 PT)
True or False: Only administrators with the right security can build a report from an unconfigured template.
A Radar dashboard component, enabled and part of a Ready for Use dashboard, does not appear in the Analytics Catalog. The component uses Dashboard Resources and is linked to a SlicerDicer session. What is the most likely cause, and how should it be fixed?
An analyst needs to restrict a Radar dashboard to specific user roles without affecting other dashboards. Where should this restriction be applied?
A user modifies the display title and component order in their dashboard. What kind of record is created?
A Cogito SQL report, sourced from Clarity, groups ED visits by chief complaint and calculates multiple metrics (e.g., average wait time, patient volume), with a trace log for debugging. The report must be restricted to ED directors, support Epic benchmarking export, and allow dynamic filtering by triage level. Which configuration is correct?
An advanced Workbench template with custom criteria logic using NOT EXISTS subqueries for exclusions needs to be. To optimize for large result sets, what?
An analyst designs a Reporting Workbench report to monitor post-surgical complications, grouped by procedure type and surgeon, with a custom calculated column for complication rates using Chronicles data. The report must be restricted to surgical quality teams, include a trace log, support Epic benchmarking export, and allow dynamic filtering by hospital wing. Which configuration meets these requirements?
A user cannot add comments to a Radar dashboard ' s comment section component, despite accessing the dashboard via the Analytics Catalog. The user has appropriate security roles. What should be modified?
A user ran a SlicerDicer session on a dashboard integrated with multiple parameters, but the data does not update when a summary-level parameter is changed. The session uses the Patients data model with criteria for high-risk patients and slices by department. To ensure the parameter affects the component, what advanced setting should be verified in the SlicerDicer session save window?
A Reporting Workbench report, sourced from Chronicles, fails to run for some users due to a custom filter for high-cost patients. The report includes a trace log. What could be the issue?
A hospital wants to benchmark its ICU length of stay against Epic community members. The data must be displayed in a Radar dashboard component. Which tool and configuration are required to achieve this?
A dashboard component fails to load due to a data source issue. The component uses a SlicerDicer session. What should be fixed?
You want to analyze flu vaccination rates for patients aged 65+ during flu season. Which is the best approach?
You want to view a population of hypertensive patients grouped by gender. What should you use?
A SlicerDicer session in a dashboard component, using the Encounters data model, returns no data despite correct filters and an enabled dashboard. The session is linked to Caboodle. What is the most likely issue?
A dashboard component ' s colored indicators fail to reflect clinic-specific, volume-adjusted thresholds for a table of patient throughput metrics. The component uses Dashboard Resources and a SlicerDicer session. Some users report no drill-down to patient records. Where should adjustments be made, and what enables drill-down?
A dashboard component must display real-time surgical schedule data with a link to the Surgical Case activity. Which data source and configuration ensure this functionality?
You are troubleshooting a SlicerDicer session that uses a custom FDM data model extended with Clarity data not yet in Caboodle. The population shows inconsistent results when slicing by a custom criterion involving related groups from Chronicles. What advanced step to verify the data flow?
You are asked to review data for Noah Shehulk ' s 11/22/2016 office visit. Which Master File and contact would you enter in Record Viewer?
Which Epic tool is most commonly used for real-time operational reporting?
A Radar dashboard component shows incorrect data due to a SlicerDicer session mismatch with the dashboard ' s data source. How should this be fixed?
A user needs to benchmark a custom metric against Epic community averages, but the dashboard metric component shows no community data. The metric is defined in IDN with benchmarking enabled, but the issue is organization-specific configuration. What advanced setting in the metric administration should be verified?
A custom component using Native SQL in Clarity fails to load on a dashboard for users with standard Radar security, but works for admins. The SQL queries a custom view joining multiple tables from different schemas, and error logs indicate permission denied on one schema. What advanced configuration in the component ' s Access form could resolve this?
Why can views and derived tables deviate from the primary key pattern derived from Chronicles add types and response types?
Select all that apply (1 PT)
How can you tell if a summary level parameter will affect a SlicerDicer component on a dashboard?
A metric-based component on a Radar dashboard displays inconsistent data across user groups. The component uses Dashboard Resources with summary targets. What could be causing this issue?
What master file stores one record for every display column in Chronicles?
Which of the following is true about working with SlicerDicer populations?
A team leader wants to compare the rate of COVID-19 vaccinations across all PCPs in the network. How would you set this up?
Where can you define thresholds to highlight results in a Table Component?
A SlicerDicer session in a dashboard component shows stale data. The session uses Caboodle. What is the solution?
A Radar dashboard, enabled and Ready for Use, is not visible to a specific user group, despite containing SlicerDicer-based components and a valid Hyperspace activity link. The components are enabled but not interactive for some users. What should the administrator investigate first?
In advanced, when a personalization record for a component overrides the source ' s data source to a custom Clarity query, but changes don ' t persist across sessions. What setting in the Component Editor might be preventing this?
What feature allows you to narrow a population down to only females aged 40-60?
A Radar dashboard component, linked to a SlicerDicer session, displays outdated patient admission data from Caboodle. The session uses the Admissions data model. How should this be resolved?
Which Epic database must data be extracted to in order for SlicerDicer to use it?
A Cogito SQL report, sourced from Clarity, groups inpatient stays by care unit and calculates multiple metrics (e.g., average length of stay, cost), with a trace log. The report must be restricted to unit managers, support Epic benchmarking export, and allow dynamic filtering by patient age group. Which configuration is correct?
True or False: Your Chronicles Administrator, Clarity Administrator, and Caboodle Administrator will always be three separate people.
Which forms control a dashboard ' s content and metadata in the Dashboard Editor?
A dashboard component with a Hyperspace activity link fails to open the Patient Summary activity for non-admin users, despite a valid activity descriptor and Dashboard Resources as the data source. The dashboard is enabled, and admins can access the link. What is the cause, and how should it be fixed?
True or False: A patient seen twice should have two records in the patient master file.
A quality team is investigating readmission rates. They want to compare patients readmitted within 30 days by primary diagnosis. What should they use?
A Native HTML component executes Clarity SQL with user-input params, but to prevent SQL injection in advanced use, what?
Use the screenshot below to answer the following question. What is true about HSP_ACCOUNT_ID?
Select one of the following (1 PT)
Where does Jason go to create a new report from a template in Hyperspace?
A Cogito SQL report groups patient visits by procedure code with multiple summary functions and requires a trace log. Which configuration is correct?
A dashboard component must display real-time patient transfer data with a link to the Transfer Coordination activity and dynamic thresholds based on transfer type and urgency. Which data source and configuration ensure this complex functionality?
Which of the following can be found in the Report Repository? Select all that apply
An analyst creates a Reporting Workbench report to monitor patient falls by ward, grouped by incident severity. The report must be restricted to safety officers and include a trace log. Which configuration achieves this?
A Reporting Workbench report, sourced from Chronicles, fails to execute for some users due to a custom filter for high-acuity patients, despite a trace log and Ready for Use status. The report groups data by care unit and calculates length of stay variance, but some users report no benchmarking export. What are the issues, and how should they be resolved?
A dashboard component requires dynamic threshold indicators for a table showing clinic performance metrics. Which setting in the Component Editor enables this?
How is the Analytics Catalog different from the Reporting Workbench Library?
You switch from " Count of Patients " to " Encounters per Patient " . What did you change?
A Radar dashboard component, part of an enabled and Ready for Use dashboard, is not visible in the Analytics Catalog and fails to load data for authorized users. The component uses Dashboard Resources, is linked to a SlicerDicer session, and has a valid Hyperspace activity link. What are the likely causes, and how should they be addressed?
An analyst needs to restrict a Radar dashboard to administrative staff. Where should this be configured?
True or False: A new Reporting Workbench Security Class must be created for each user.
You want to return I EMP 14300: Default User Role and I EMP 600: Login Instant by your query.
Part 2 of 2
You find that I EMP 35 extracts to the CLARITY_EMP table which has a primary key of USER_ID. You find that I EMP 600 extracts to the EMP_LOGIN_HX table which has a primary key of USER_ID and LINE.
How would you join these two tables in your query?
Select one of the following (2 PTS)
Which of the following can you do in the Criteria tab of the Report Settings window? Choose 3 answers.