About the Business Intelligence fact tables on the Analytics Server
The Business Intelligence fact tables play a crucial role in storing and displaying insights information about the collected usage data. Your solution includes fact tables in the Analytics Server that are unique to your environment. These tables cannot be viewed directly, but the visualizations in the dashboards allow you to view trends and statistics about the collected data stored in the fact tables.
After the tables merge related start activity strings and stop activity strings into data rows, these data rows are sent to the first level of the fact tables on the Analytics Server. The procedures and activities within these tables only ever apply across rows that exist at the same sequential order. In addition, any table will only ever see the data collected in the table of the immediately preceding warehouse phase. For example, row 3 of the jersey item type in a fact table in the Pick phase can only pull in the data stored in row 3 of the jersey item in the Put Away fact table.
In addition, a fact table can only pull in data for the same item type, the same location, the same environment, and with an earlier time stamp.
The communication between fact tables and the movement of data is used to achieve two goals: filtering out data with no context from a previous warehouse phase, and performing balancing operations between warehouse phases.
Loading...
There was a problem loading this topic