An OLAP cube is a data structure that organizes data in a fashion that promotes end-user driven adhoc reporting. Many front end utilities exist to allow users to manipulate the cube by slicing the data by dimensions, drilling through layers of granularity, and pulling out the measures they want.

One of the most common dimensions for an OLAP cube is the time dimension. The time dimension allows the user to aggregate data based on, well dimensions of time. For instance, you may report data on a daily, weekly, or monthly basis.

(more…)

This post details how to accomplish a cross-join between two tables and left join in the many-to-many to override a value in the left most table. The result is a dynamic setting view in which each target section pulls from a base of setting values, but may override the default value with it’s own value.

(more…)