Reports off the Warehouse

To add stored procedures to the data warehouse database using a Report Spec, you must use MartKey="BBDW" in the root element of the spec. To retrieve data from a data source other than the transactional database from an RDL file loaded with a Report Spec, you must use a DataSource element.

MartKey

The MartKey attribute indicates where the Transact-SQL objects defined in DataRetrieval are created. When MartKey is not specified, the Transact-SQL objects are created in the application database. When MartKey is specified, objects are created in the data source provided.

These data sources are maintained by the platform in the transactional database in a table called dbo.[OLAPDATASOURCE].

    MartKey="BBDW"

DataSource

The DataSource element is optional for the Report Spec. Many reports will pull their data directly from the Infinity database. In this case, the DataSource element is not needed as the data source within the report will be updated to use the Infinity data source (BBAppFxDB) when the Report Spec is loaded.

However, reports may leverage any data source that is available in Reporting Services by specifying the relative path to the data source in the DataSource element. For example, the below will update the data source in the report to use the Blackbaud Data Warehouse.

  <DataSource>
    <DataSourceRelativePath>Blackbaud OLAP Reports/Blackbaud OLAP SQL data source</DataSourceRelativePath>
  </DataSource>