A fact table with no measures is known as a factless fact table. It's essentially a crossroads of dimensions (it contains nothing but dimensional KEYS). One form of factless table is used to capture an event, while the other is used to describe conditions.

In the first type of factless fact table, there is no measured value for an event, but it develops the relationship among the dimension members from several dimensions. The existence of the relationship is itself the fact. This type of fact table can be utilised to create valuable reports on its own. Various CRITERIA can be used to count the number of occurrences.

The second type of factless fact table is a tool that's used to back up negative ANALYTICAL reports. Consider a store that did not sell a product for a period of time. To create such a report, you'll need a factless fact table that CAPTURES all of the conceivable product COMBINATIONS that were on offer. By comparing the factless table to the sales table for the list of things that did sell, you can figure out what's missing.