Dimensional modeling in a business intelligence environment