Exam (elaborations)
Cogito - Clarity Data Model - CLR 110 Clarity Data Model Fundamentals
- Course
- Institution
Cogito - Clarity Data Model - CLR 110 Clarity Data Model Fundamentals
[Show more]
Content preview
Cogito - Clarity Data Model - CLR 110Clarity Data Model Fundamentals
A Clarity table's primary key includes a "CSN." What does this mean? - ANSWER-A
CSN is a Contact Serial Number, which identifies a specific contact within a specific
record. A table with a CSN in its primary key extracts overtime data - if it extracted no-
add data, you wouldn't need to identify a contact.
A Clarity table's primary key includes a line count. What does this mean? - ANSWER-
Only Chronicles items with a response type of multiple-response or related group have
line counts, so you know the table must extract multiple-response or related group
items.
A user shows you a field in Hyperspace that they want to report on. How can you find
where in Chronicles that field files to? - ANSWER-Control left-click it. If that doesn't
work, try using the Chronicles Record Viewer.
Add Types - ANSWER-Identifies whether a data changes on the item for each Contact
or is stored directly on a record
Add Types - Lookback - ANSWER-Stores values separately on each contact, but
assume that last value remains true until new value is entered (not used very often
anymore.
Add Types - No-Add - ANSWER-Stores items directly on a record, not a specific contact
Add Types - Response Each Time - ANSWER-Stores values separately on each of a
record's contact
Analytical Reporting in Clarity - ANSWER-Comprehensive; Summarized; Standardized
Category Tables - ANSWER-ZC_* tables; Performance Tip - filter or sort on the _C
columns
Chronicles Data Type - Category - ANSWER-A pre-defined list of choices; Some can be
modified by customers, some cannot
Chronicles Data Type - Instant - ANSWER-Date/Time stored in single item as the
number of seconds since midnight on 12/31/1840 and converted back to normal for
display
Chronicles Data Type - Number - ANSWER-Any number - can be an integer or a
decimal
, Chronicles Data Type - String - ANSWER-Any combination of characters
Chronicles Data Type - Time - ANSWER-A time without a date; stored as the number of
seconds since midnight; converted back to normal time for display
Chronicles Record Viewer - ANSWER-Scheme of all items with numbers and values for
a given record/contact combination in a given master file/INI
Chronicles to Clarity Data Type Mapping - ANSWER-String - VARCHAR; Number -
NUMERIC/FLOAT; Date - DATETIME/FLOAT*Contact Date Real; Time - DATETIME;
Instant - DATETIME; Category - VARCHAR/INTEGER
Clarity Compass - ANSWER-Defines what Chronicles/production data will be extracted
into which Clarity tables and columns. Defines the structure of your Clarity tables,
including primary keys - Hyperspace
Clarity Console - ANSWER-Schedules the extract of defined tables from Chronicles into
Clarity - Web-based
Clarity Distribution Mechanisms - ANSWER-EPIC-Crystal Integration; Business Objects
Universes; Radar (information center/Portal )
Column Search - ANSWER-Path: Epic>Report Management>Column Search: can
search your column definitions for a column that extracts a certain Chronicles item, and
then jump to that column's compass entry for more information
Contact Date Real (CDR) - ANSWER-A contact date real is a date in Epic's internal
format, followed by a two decimal places that identify one contact among many on the
same date.
Contact Serial Number (CSN) - ANSWER-A CSN is a number that uniquely identifies a
single contact within a master file
Control Left-Click Method - ANSWER-One method to find where the data lives though
Hyperspace
Creating a Reporting Workbench Report - ANSWER-Reports in Reporting Workbench
are made from templates. Templates control many things about a report, including what
master files the query searches, what criteria are available, and many aspects of the
user interface.
Crystal Hyperspace Integration - Default values ext - ANSWER-Most users at your
organization will only be interested in report results pertinent to their particular location,
department(s), or employees they work with. On the Hyperspace user record, you can
set which departments, locations, and other records should be considered relevant to a
particular user when they run reports.
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 LUCKYSTAR2022. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75057 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now