SQL Server Reporting Services (SSRS) on Kyvos

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports. You can connect to Kyvos semantic models from SSRS to create your reports.

Kyvos supports SSRS reporting through the SSRS Report Builder and Visual Studio. Click the relevant to see the procedure. 

Connect to Kyvos cubes from SSRS

1. Open SSRS Report Builder.

2. Right-click Data Sources and choose the Add Data Source option.

3. On the Data Source Properties dialog, enter details as:

   1. Provide a Name (without any spaces) for the data source.

   2. Select the Use a connection embedded in my report option.

   3. Select the Microsoft SQL Server Analysis Services option from the Connection Type list.

   4. Click the Build button.

4. In the Connection Properties, provide the below details

   1. Server Name: http://serverurl.com:<port>/kyvos/xmlaKyv

   2. Provide your credentials in Username and password.

   3. Choose your database from the drop-down list.

      Open

      

   4. Click the Advanced button. On the Advanced Properties dialog box, remove SSPI from Integrated Security and click the OK button.

5. Click the OK button on the Connection Properties dialog.

6. Right-click DataSets and select the Add Dataset option.

7. In the Dataset Properties window, provide information as:

   1. Provide Name (without any spaces) for the dataset.

   2. Select the Use a dataset embedded in my report option.

   3. Choose the data source that you created earlier.

   4. Provide a Query or click the Query Designer button to design the query.