Database Reference
In-Depth Information
Figure 12-42.
Processing a cube from SQL Server Management Studio
In the same menu, you can see many other options available such as the ability to browse the cube using
a browser window that is similar to the one we have seen in Visual Studio. You also see the Script Cube option,
which allows you to create XMLA code that re-creates the cube if necessary.
Processing a cube is considered an administrative task. When you choose the Process option from the
context menu, a dialog window opens that offers processing options. One of the most important options allows
you to create an XMLA script that processes the cube when it is executed (Figure
12-43
). This is important
because you use XMLA code like this to create automated SQL Server jobs. Afterwards, these jobs can be
scheduled to perform the processing tasks each night using Microsoft's
SQL Server Agent
software.
