Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 71

8. The next screen asks for dimensions you would like to include with the cube.
Since you only have two dimensions (promotion and date), include both and
click on Next .
9. The wizard detects relationships with other tables and suggests creating ad-
ditional dimensions via the following screen. As shown in the screenshot,
you have an option to create Sales Territory , Currency , Product , Fact
Reseller Sales , and Employee dimensions based on existing tables. Addi-
tionally, the wizard suggests creating a dimension based on the fact table:
FactResellerSales .
10. Although you should never expose fact level dimensions for ad hoc querying/
browsing data, such dimensions could be very useful for reporting. For ex-
ample, we could include the invoice numbers and order revision numbers
on a report, and neither of these attributes could be conveniently exposed