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