...
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).
Column Group
A subset of fields from a specific view used for data integration.
Core
A specific set of Activity Hub views that are available to report developers and data integration developers upon request. Excludes restricted views or views requiring secondary approvals.
Data Integration
The automated movement of data from one server to another.
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
...
Numeric values mathematical equations are applied to. Aka numeric, decimal, integer, bigint, smallint.
Example: Count, Amount, Total
P Level (P1, P2, P3, P4) Protection Level
Sensitivity of the data within the field.
https://security.ucop.edu/policies/institutional-information-and-it-resource-classification.html
Restricted View
View contains restricted data. Available to a small audience requiring additional access approvals.
SAP Hana
Server platform used to host the Activity Hubs.
...