Database Reference
In-Depth Information
7. Click on the OK button and process and deploy your model.
One of the benefits with the tabular model when it comes to partitions is the fact
that you have the ability to partition all tables. In multi-dimensional models, you can-
not partition dimension tables except fact tables. In the tabular mode, all tables are
equal, there is no difference between fact and dimensions.
Partitions in tabular mode can be used to process a model incrementally; in order to
do this, you need to partition by an incrementally growing key and create a new par-
tition, and only partition that. This will allow you to only read the new data. You also
have the possibility to create an equivalent of ROLAP partitions called DirectQuery
partitions.
Search WWH ::




Custom Search