Chris, Thanks for the promptly response. The Funnction dimension is a ragged level-based hierarchy. The attached Model.docx illustrates how it has been modelled by our BI team. Could you cast your eyes to see if we have missed anything. What I found interesting is that the physical query does not include the lowest level…