Investigating Caboodle Flashcards
Why is “Reporting with Caboodle” used for researching reporting topics in Caboodle?
The “Reporting with Caboodle” guide includes descriptions and reporting examples for most of the tables in Caboodle’s reporting database. The document provides a series of reporting topics, which are broken down into scenarios and example for learning to work with the Caboodle tables. Each topic includes common tables, example reports, and an exercise for furthering your knowledge about the topic.
(Aug. 2021, 3.8)
What resource should you use if you are attempting to create a report that is similar to one you can produce in SlicerDicer?
You can use the SlicerDicer troubleshoot button to know which database objects you want to explore and research more.
(Aug. 2021, 3.8)
What are join diagrams?
Join diagrams are visual representations of the tables, columns, and joins involved in a query.
(Aug. 2021, 3.9)
How are join diagrams different from ER diagrams?
- Join diagrams only show the joins that will be used in a certain report.
- ER diagrams show all possible joins from a certain table.
(Aug. 2021, 3.9)
You are writing a report in Caboodle about surgeries. A colleague on the OpTime team tells you that the patient is stored in I ORC 50. What is the best way to determine which Caboodle table and column extracts this data?
Search the Cogito Dictionary for “ORC 50”. To limit the search results to ONLY Caboodle, search “CB: ORC 50”.
(Aug. 2021, 3.13)
A column in Caboodle does not contain the data you expect to see. To determine if the issue is within the source data or the ETL process, you want to investigate the Clarity data. How can you determine which Clarity column is used to populate the Caboodle column?
Investigate the data lineage for the column using the Cogito Dictionary.
(Aug. 2021, 3.13)
True or False: The ER Diagram contains information that cannot be found anywhere else in the Cogito Dictionary?
False. The ER Diagram is a visual representation of information that can be found in the dictionary.
(Aug. 2021, 3.13)
Where can you find the Caboodle dictionary?
The Caboodle dictionary is completely integrated within the Analytics Catalog.
(Aug. 2021, 3.4)
How do you know if a column is populated with Epic data?
The Source Data Lineage section will include:
- Clarity tables and columns
- A section listed as Chronicles Info.
(Aug. 2021, 3.5)
What does an ER diagram reference?
All possible joins for that table.
Aug. 2021, 3.6
Does the Cogito Dictionary have ER diagrams for dimension tables?
No. Only fact tables have ER diagrams.
Where can you find all of the lookup columns for a fact table?
The ER diagram lists all the lookup columns for a fact table.
In the Cogito Dictionary there is a value in the “Links To” column. What does this tell you about the column?
That the column is a lookup column that contains a surrogate key.
