Configuration
Data retention time
Data is stored for 4 years (1500 days exactly) in the datamart and will be deleted after this time without any notice.
If data must be kept for a longer period, customers must request this and will get the offering for increased storage space on top of the existing service subscription.
Data size limitation for Power BI
Depending on the Power BI licensing, the size of the pbix files is limited to 1 GB per file for a pro license as of today. To keep those limits, the historical depth can be reduced for all data or specifically for user data based on a configuration setting. This allows to comply with the Power BI limitations with little adjustments and without the need of deleting/restoring any data.
These adjustments are part of the implementation process, just before publishing the pbix files to the customer workspace. The configured limitations (if any) should be documented and communicated to the customer.
User Name Display
There are 3 options available on how the full name of the users can be displayed:
1 = [lastName], [firstName] (Id) -> example: Bond, James (7)
2 = [firstName], [lastName] (Id) -> example: James, Bond (7)
3 = [email] -> example: james.bond@mi6.gb
The Id next to the name is required because the name can be the same for different users.
Available time zones
Data is stored in UTC and converted to the time zone that is selected in the normal "Filters" by the user. The list of available time zones for the users can be modified by enabling or disabling time zones inside the TIME ZONE dimension table.
Keep the list of available time zones as little as possible because users must choose the right time zone from that list and every time zone has some impact to the performance.
See the list of supported time zones
Geographical settings for Sites
Map charts require latitude and longitude coordinates for locations. Locations are required for Webex Calling and can be configured in the Webex Control Hub for all users, including geographical settings. This is the preferred way to support map charts based on the user location.
Webex Contact Center Sites, on the other hand, have no geographical settings in the provisioning portal. They can be configured as a workaround for the SITE dimension in the datamart to support map charts for sites as well. Please do not use this concept for deployments with frequent changes because they have to be implemented based on charged services.
Global Variables
Up to 10 reportable variables can be included in the facts and dimensions of the semantic model. We need to map the available variables to a fixed variable name (VARIABLE 10 to 20) inside the data model.
The mapping of the variables has an impact on the data load and only works from the time of implementation!