Semantic data model definition
A semantic data model is a structured multidimensional dataset; it has many dimensions and pre-calculates aggregations ahead of time. The model organizes data in a hierarchical arrangement according to dimensions and measures.
The structure of a semantic data model makes it easy to visualize or conceptualize data along various dimensions of a model, making it easy to query and interact with the semantic model.
Multidimensional analytics is a set of operations that one can do on a dataset using this semantic data model, for example, pivoting, slicing, dicing, or drilling.
Slice - is the act of picking a rectangular subset of a semantic data model by choosing a single value for one of its dimensions. For example, the sales figures for all sales regions and all product categories of the company in a year can be "sliced" out of the data semantic model.
Dice - is a slice on more than two dimensions of data. A dice, for example, shows the sales figures of a limited number of product categories, while the time and region dimensions cover the same range as the slice example.
Drill up/down - allows you to navigate among levels of data ranging from the most summarized (up) to the most detailed (down).