Manage Logical Star

A logical star is the basic complete unit of a dimensional model with a fact at the center and joined to the surrounding dimensions. Manage a logical star by adding and updating objects, attributes, joins, and calculations.

Facts contain elements that you can measure such as count, aggregate, and perform statistical operations on; while dimensions contain elements that provide context to those measurements. Each logical star has one fact and one or more dimensions. You can manage your own custom star or you can manage a prebuilt star by adding dimensions. You do these operations to extend the model to make use of custom data objects or elements that you've added to the warehouse or to create new calculations or joins to address your reporting needs.

Within the Sandbox you can zoom and focus on specific areas of the logical star using the graphic tab on the logical star page. You can rearrange the objects in the logical star using the graphic tab on the logical star page. Additionally, you can view all the joins in a tabular format using the tabular tab on the logical star page.