I am totally new to making schema - and i want to create an OLAP view for Jaspersoft report. But my understanding is too shallow so i try to study the Foodmart data and i have an intriguing question that i quite don't understand. See the screenshot below.

As you can see there are quite a few dimension + dimension usage for the Sales cube such as Store, Store Size in SQFT, Store Type, Time, Product, Promotion Media, Promotion, etc.

However despite of the few list of dimensions + dimension usage only two namely (Promotion Media + Product) is displayed in the OLAP crosstab output. My Question is how the system determine what to show on the table? why not show all the available dimension + dimension usage.

Name:  OLAP view.jpg
Views: 40
Size:  14.9 KB