Recently I had to create a fact table with a lower grain than the source database. My source database contained order lines with a start- and end date and monthly revenue amounts. To create reports that showed overall monthly revenue per year, lowering
Read More...