SyteLine Analytics: Understanding Fact-Trak OLAP Databases

This lesson was recorded in Fact-Trak 2023. The functionality is unchanged in Fact-Trak 2024. Take a closer look at how the Fact-Trak OLAP databases are built. The sales cube is assembled from four views, or sources, tied to customer invoices, and only the most popular fields are included so Excel refreshes stay quick. Sort out the terminology behind every pivot table: facts are values you drag to the value area, dimensions classify data as filters, row labels or column labels. The help tab of each template lists every available field by source. In this lesson: 0:00 Cubes built for company roles 0:46 Sources and the operational database 1:40 Field list groups named for sources 2:06 What a fact is 3:01 Dimensions as filters and labels 3:56 The help tab field table 5:19 Slicing sales data many ways 5:46 Default fields in the accounting cube 7:25 Fields calculated outside SyteLine Learn more: lakeco.com | orders@lakeco.com