Skilirium

Recognises a drill-across without a shared conformed dimension

W-304 · Skill knobit · Activity: Design the bus matrix and data products · Competence: Data warehousing and business intelligence

A cross-process question with no common conformed dimension.

Can AI do this?

Not settled yet The benchmark tested this, but the models' answers do not settle yet whether they master it. 0 of 4 models in the current benchmark master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 67%Not shown
gemini-3.5-flash-liteLow cost 48%Not shown
gpt-6-lunaLow cost 66%Not shown
claude-haiku-5-5Low cost 67%Not shown

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: The question and the dimension to drill through

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Card spend vs deposit balances "by customer" across PD-022 and PD-002 Acceptable: Through PD-002 only

Also known as: Drill-across without a shared dimension

Related knobits

Builds on

Usually followed by

All 14 knobits of Design the bus matrix and data products.

Source: Review checklist 03-bus-matrix-data-products, row 4 (Kimball)