Use the Services section in EPM Workspace (select Navigate, then Administer, then Reporting and Analysis, and then Services) to configure the Hyperion Interactive Reporting Data Access Service so the service references the database system that contains the Reporting and Analysis repository tables. The configuration must match the way that business reporting data sources are configured.
For example, if the repository is implemented using MS SQL Server, the Hyperion Interactive Reporting Data Access Service configuration is displayed in the Add Data Source to DAS screen with the parameters:
Connectivity Type: ODBC
Database Type: MS SQL Server
Select the name of the data source: metadata