icCube

Reporting Services & Report Builder (Microsoft)

Creating an icCube data source in Microsoft Reporting Services and Report Builder is straight forward. First, add a new Data Source and select Analysis Services as type:

Then specify the icCube XMLA endpoint as server name (e.g. http://localhost:8282/icCube/xmla?msrs), note the ?msrs parameter:

The datasource is created, now you can use the Query Builder and create your reports:

Here is an example of a report with [Articles] on columns and [Regions] on rows for the [Measures].[Amount]: