We started writing about DFM and DW testing as a winning combination here.
The functional test of the DFM schemas aims at verifying that the multidimensional schema produced for the data mart effectively supports user requirements and it comes in three complementary types, the workload test, the hierarchy test and the conformity test.
The conformity test is aimed at assessing how well conformed hierarchies have been designed. This test can be carried out by evaluating the sparseness of the bus matrix (shown by indyco Explorer as in the aside picture), which associates each fact with its dimensions, thus pointing out the existence of conformed hierarchies.
If the bus matrix is very sparse, the designer probably failed to recognize the semantic and structural similarities between apparently different hierarchies. In this case, creating a conformed dimension to be shared by multiple facts would be preferable.
Conversely, if the bus matrix is very dense, the designer probably failed to recognize the semantic and structural similarities between apparently different facts. In this case, it could be worth merging these facts into a single fact including the union of their measures.
– DFM and DW Testing: A Winning Combination
– Functional test of the DFM schemas: the workload test
– Functional test of the DFM schemas: the hierarchy test
– Functional test of the DFM schemas: the conformity test
– Usability test of DFM schemas