Database Reference
In-Depth Information
Summary
In this chapter, we have covered the process of deployment that sends the script gen-
erated by SQL Server Data tools to Analysis Services. We have also covered the
processing of objects, the step where data is moved from the source and stored for
querying in Analysis Services. It also shows how the process could be scheduled and
tuned. One way of tuning is partitioning that was covered, another one is through us-
ing storage options such as ROLAP and proactive caching.
In the next chapter, we will look at how a cube can be queried using different tools and
on the language used for querying called Multidimensional Expressions ( MDX ).
Search WWH ::




Custom Search