Technical References

1-40
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Best Practices for Service Design and Reporting
which loads the data mart. The query subjects are still available in the reporting framework; the table
which holds the dictionary or service data is NOT available for use with another dictionary or service,
and still counts as one of the number of tables in use.
Data Type Conversions
All data in the data mart is stored as either a character (text) string; a number; or a date (with time
component). Data from internal dictionaries is converted to the appropriate type, as shown in the table
below.
A Person data type is represented in the data mart as a combination of the person's first name and last
name, as shown in the “Select a Person” window on a service form. A Boolean data type is represented
by the strings corresponding to “yes” and “no” as shown in the radio button representation of the data
type.
Data from external dictionaries is converted into the appropriate type. For example, all numeric fields,
regardless of magnitude or precision, are converted into the Number type of the target database shown
in the table above. Graphic and large object (LOB) data types in external dictionary tables are not
supported and are ignored when the data mart is created or data is loaded via the ETL process.
Number of Columns in the Dictionary and Service Tables
As part of the data mart configuration, designers specify how many of each type of column (character,
numeric, or date) should be created in the dictionary and service tables. All dictionary tables must have
an identical composition, in terms of the number of each type of column allowed. The same holds true
for service tables.
Parameter Default Value SiteValue
NUMBER_OF_SERVICE_TABLES 100
NUMBER_OF_DICTIONARY_TABLES 100
Data Mart Column Data Type Internal Dictionary Data Types Database-Specific Implementations
Number (Numeric) Number
Money
Oracle –NUMBER
SQL Server - FLOAT
Date Date
Date and Time
Oracle – DATE
SQL Server - DATETIME
Character (Varchar – variable
length character strings)
Text
Person
URL
Account
Phone
SSN
Boolean
Oracle – VARCHAR2
SQL Server – VARCHAR