Applies to:
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
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.
Data connection Wizard
- 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 cube or table option. This loads a list of the available semantic models.
Data Connection Wizard – Loading 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.
Data Connection Wizard – Saving Information
7. From the Import Data dialog box, select how you want to view data in your workbook.
Import Data dialog box
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.
Sample worksheet with Kyvos semantic layer