MCQs
Assemblies let you extend the business functionality of MDX and DMX.
For a write-enabled dimension, updates are recorded directly in the dimension's table.
In Microsoft SQL Server 2005 Analysis Services (SSAS), a linked dimension is based on a dimension that is stored in another Analysis Services database.
Specifying the conversion type allows the Business Intelligence Wizard to define the named query and dimension structure of the reporting currency dimension.
Transactions are stored in the fact table in the pivot currency, and then converted to one or more other reporting currencies.
The Forecast tool predicts future values based on trends in existing time series data.
Report Manager works in native mode only.
By using calculated cells, the client application can specify a rollup value for a particular set of cells, instead of for an entire set of cells as in the case of a custom rollup formula or a calculated member.
Online Analytical Processing is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data.
This context can be the whole cube or just a subcube from that cube. Having specified cube context through the FROM clause, you can use additional functions to expand or restrict that context.