Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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

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.

...