Connecting Excel to Kyvos Semantic Model

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

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

Microsoft Excel has become one of the most popular data analysis tools due to its availability on most office machines. Kyvos can integrate with Excel for your reporting needs, using the MSAS connector.

To retrieve the Kyvos semantic model data in MS Excel, perform the following steps.

1. Go to Data > Get Data > Select From Database > From Analysis Services on your Excel worksheet.

2. On the displayed Data Connection Wizard, provide the connection information.

URL/Server: This is the server URL. Enter as http://<ServerName>:<port>/<kyvos>/xmlaKyvos
Here,
<ServerName> is the IP address or DSN name of your Kyvos server.
<Port> is the port number on which Kyvos listens.
<kyvos> is the web app name.
User/Password: Use your Kyvos username and password for authentication.

In some cases, the connector won’t allow you to enter the user information. In such cases, try the URL as http://ServerName:port/kyvos/xmlaKyvos?username=JohnSmith&password=Secret

Here, JohnSmith is the username, and Secret is the password.

3. Click Next.

4. Choose the semantic model from the drop-down list and select Connect to a specific semantic model or table option. This loads a list of the available semantic models.

5. Select the semantic model that you want to browse and click Next.

6. On the Save Data Connection File and Finish screen, check the information and click Finish.

7. From the Import Data dialog box, select how you want to view data in your workbook.

8. Click OK.

The Kyvos semantic model is loaded in your worksheet. All your business logic is abstracted and presented in the form of measures and filters. You can now start browsing the semantic model. This example shows profit against parts.