ACOP Vocabulary

Owned by Saparnell
Last updated: Nov 13, 2024
2 min read

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).

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

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

P Level (P1, P2, P3, P4) Protection Level

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.

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.