ACOP Vocabulary

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.