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 workload test verifies that the workload preliminarily expressed by users during requirement analysis is actually supported by the multidimensional schema.
If the DFM has been used one should check, for each workload query, that the required measures have been included in the fact schema and that the required aggregation level can be expressed as a valid grouping set on the fact schema. Should the workload be too large to be comprehensively tested, tests should be made on a sample of queries only.
In putting the sample together, priority should be given to the queries involving irregular portions of hierarchies (e.g., those including multiple arcs or cross-dimensional attributes), those based on complex aggregation schemes (e.g., queries that require measures aggregated through different operators along the different hierarchies), and those leaning on non-standard temporal scenarios (such as rollback).
Remarkably, the existence of a conceptual schema significantly simplifies the workload test, that can be carried out more profitably because, differently from a logical schema, the DFM can be understood by users and discussed with them.
– 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