Database Reference
In-Depth Information
How it works...
SQL Server Analysis Services ships with a data source provider that allows you to access
the data stored in OLAP databases and cubes using reporting tools such as Report Builder.
Before you can use Report Builder to access the cubes provided by Service Manager, you
have to manually configure a data source in SQL Server Reporting Services.
As cubes store data in a multidimensional schema, SQL Analysis Services implements the
MDX
(
Multidimensional Expression
) query language. MDX queries are used in your re-
ports to define the datasets. The MDX used in this example is as follows:
SELECT
NON EMPTY
{
[Measures].[Incidents Breaching SLO Percentage],
[Measures].[Incidents Meeting Meeting All SLOs
Percentage]
}
ON COLUMNS,
NON EMPTY
{
(DESCENDANTS([IncidentDim_IncidentClassification].[ParentId].[Level
02].ALLMEMBERS))
}
ON ROWS
FROM
[SystemCenterWorkItemsCube]
