Ssas unit test

[grahamcrowell]

One table (cubetable) to store cube metadata with one to many relationship to table (measuretable) that stores which measure is being tested with another one to many relationship to a table (dimtable) that stores dim meta data.
Each row from measuretable implies

[grahamcrowell]

Each row from measuretable implies an MDX query that returns a dataset.

A sql (or Denodo vql) query that returns columns names that match a cubes field and measure names could be used to generate records for cubemeasure and cubedim and by extension an mdx query.

This gives two comparable data sources.