Source System ID
Dimension tables (tables that begin with "d") contain general information about Igloo Objects. Within a table, an object may have many associated rows because actions such as archiving or renaming create new rows in the table. While the object will receive a new row and unique key value, its Source System ID will remain the same.
As a result:
- Join object dimension tables to navigation tables (dContentNav, dContainerNav) by the Source System ID and not the unique row key.
- Total activity across the Source System ID if you want to know the overall activity on an Igloo Object.
Current digital workplace members
The dUser table contains users who have ever performed any action in your digital workplace. To identify current digital workplace members, you must determine which users are currently in the Member group.
Large data sets
Tables such as fact tables (tables that begin with "f") can become very large. Filter this data by a specific date range. Also, remove any unneeded columns.
Guest Users
Identify Guest Users in fact tables by their user_key value 367003. Activity by Guest Users is most common on locations made open to the public.