Database Reference
In-Depth Information
Processing Tabular Models
Once a Tabular Model has been loaded initially, you may need to reload the data to
pick up new data or handle data source refinements. Unlike a multidimensional mod-
el, which does not need data to work, the Tabular Model starts out in a processed
state.
How to do it…
The Processing primarily occurs during development, while using Microsoft SQL
Server Management Studio :
1. In order to process the database, individual tables, or partitions, you merely
need to right-click on the object and select the Process option. This will open
the Process dialog box.
2. From here you will pick your processing option and click on OK to process the
selected object.
How it works…
Processing the model refreshes the data or the metadata depending on the process-
ing option chosen.
As you can see Process Default is available to all objects. This will process any table
or partition that is currently unprocessed and update the internal structures including
calculations and hierarchies. Process Full replaces all components, data, and intern-
al structures. Process Clear does the opposite and removes all data in the database,
table, or partition. Process Data will reload the data in the selected table or partition.
After either a Process Clear or Process Data option is run, you should run a Pro-
cess Recalc option, which will rebuild all of the calculations, relationships, and other
structures used in the model.
Search WWH ::




Custom Search