2.3 Using the Reporting Console

Use the Reporting Console to set up your reporting environment:

2.3.1 Managing Data Source Connections

Data Source connections are the basis for the reports that you run with Reporting Center. The setup program automatically configures your initial data source connections according to the information you provide during installation. These data source connections point to specific database servers that provide the data for your reports. Data source connections use either Windows authentication or SQL authentication depending on the security configuration of the source SQL Server and the choices you make when installing SQL Server. After installation, you can configure additional data source connections and modify connection properties in the Reporting Console.

Adding a New Data Source Connection

  1. In the Navigation pane of the Reporting Console, right-click Data Source Connections and click Add New Data Source Connection.

  2. Click the General tab.

  3. Specify the Data Source connection name and description.

  4. (Conditional) If you want to set this Data Source connection as default, select the Default Connection option.

  5. Select the Data Source Type as Analysis Center.

  6. In the SQL tab of the Connection Details panel, specify the following:

    1. In the Server Name option, specify the SQL Server Instance name where AC_Warehouse is installed.

    2. In the Database Name option, specify AC_Warehouse.

    3. Select the authentication type.

    4. (Conditional) If you chose SQL Server Authentication, then specify the credentials to log into the SQL Server.

  7. In the OLAP tab of the Connection Details panel, specify the following:

    1. In the Server Name option, specify the SQL Server Instance name where AC_OLAP is installed.

    2. In the Database Name option, specify AC_OLAP.

  8. Click OK.

Specifying a Default Data Source Connection

Before you run reports for the first time, NetIQ Corporation recommends that you specify a default data source connection for each connection type.

To specify a default connection:

  1. In the Navigation pane of the Reporting Console, click Data Source Connections and right-click a connection.

  2. Click Data Source Connection Properties > General and select Default Connection.

  3. Click OK.

2.3.2 What’s Next?

After you install Reporting Center and get familiar with the Console and Data Source connections, get started with performing the following tasks. This is a suggested order, but the order in which you perform these tasks might vary depending on your organization requirements:

  1. Create reports from templates provided. For more information, see Section 3.0, Understanding Report Templates.

  2. Deploy a report to SSRS and set up a subscription for it. For more information, see Section 4.5, Deploying Reports.

  3. Create a hierarchy of Reporting Center users and groups. For more information, see Configuring Reporting Center Security in the NetIQ Analysis Center Administrator Guide.

  4. Set up permission sets for the users and groups and assign them to objects. For more information, see Configuring Reporting Center Security in the NetIQ Analysis Center Administrator Guide.