Skip to main content
Version: 1.4

Data Model Overview

The CCBI WxC data model contains all data that was integrated from Webex Calling APIs. Every API feed is stored within a corresponding table, and everything is linked to an extensive star schema within Power BI, called the semantic model.

Fact tables contain the data of the data model. Call Detail Records (CDR) are used to measure incoming and outgoing calls from users, places and system elements like voicemail, hunt groups, auto attendants, etc..

Data model

Dimensions are used to filter data within the fact tables and to group this data for any field of the dimension table. Dimensions about configuration objects (User Dimension and Feature Dimensions) are loaded from the "List Configuration"-APIs and are kept all time, even if they get deleted within the source system (they get the suffix "deleted" within the name in this case).

Some dimensions are on top of other dimensions and do not directly filter data from the fact tables. USER LOCATION and USER GROUP are used to filter the users in a first step and the USER dimension then filters the data within the facts. This has an impact on the data that is filtered within facts, if the assignment of a user changes (what is not the case for dimensions directly connected with the facts).

Number dimensions are extracted from the facts and joined with the names of the known Webex numbers and the parameters of the custom PhoneNumber mapping import file. This allows to configure a name and location parameter for known numbers outside of Webex.

There are two out of the box Security Roles available within the Power BI workspace to be assigned to the Power BI users:

  • "MY OWN" filters the USER dimension with the current user that is logged in to Power BI and the USER dimension then filters the data within the Calling CDR table.
  • "USER DEPARTMENT" uses the Department of the current user that is logged in to Power BI and the DEPARTMENT dimension then filters the data within the Calling CDR table.