Typically finance teams want to know the posting date in relation to the fiscal period close, that is, postings: Between 1 and 3 days...

Disclaimer! This blog post contains my thoughts surrounding using prime numbers for performance optimisation. I am not advocating you do...

Mixed Grain Fact Tables Granularity is determined by the number of foreign keys in the fact table. For instance, the grain of your...