Activity Hub
UC San Diego's modernized data warehouse environment, running on the SAP Hana platform.
Aggregation
Grouping data fields.
Numbers can be aggregated using Total, Sum, Count, Count Distinct, Minimum, Maximum, Average and more.
Strings and dates are usually displayed without an aggregation.
Strings and dates that are aggregated turn into numeric values. Example: Count ( Building Name).
Dates
Cognos = Dates, Date and Time formatted as yyyy-mm-dd hh:mm:ss.###
No matter how the original data source is formatted, Cognos formats the date time as above
Report developers can change the output format but filters and calculations must use the Cognos format
Tableau = Date fields are automatically displayed as a Calendar Year with a drill down to Calendar Quarter, Calendar Month then date.
Filters and calculations must be formatted like a date or date time, no quotes
Date = 2023-04-15
DateTime = 2023-04-15 18:00:00.000
Measure
Any numeric value intended to be used in mathematical equations or to be aggregated.
Numbers
Numeric values mathematical equations are applied to. Aka numeric, decimal, integer, bigint, smallint.
Example: Count, Amount, Total
SAP Hana
Server platform used to host the Activity Hubs.
String
Alpha (words), alphanumeric, character, car, varchar or sometimes numeric.
Example: Names, Codes, 9 digit year
Filters and calculations must include a single quote (') before and after the value.
Examples: Name = ‘Mickey Mouse’; Year = ‘2023’; ID = ‘123456789’
View
Collection of related fields used to build Activity Hubs.