Microsoft Analysis Server
Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace  Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
Kyvos emulates a Microsoft Analysis Services semantic model for MSAS compatibility. Tools that can connect to an MSAS semantic model can generally connect to a Kyvos semantic model using the same connection mechanism.
Prerequisites
You must install any one of the following:
For 2014 SP1 (version 12.0.2000.8)
Download and install the SQL_AS_OLEDB driver.
If not available by default, you might need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.
For 2012 SP1 (version 11.0.2100.60)
Download and install the SQL_AS_OLEDB driver.
If not available by default, you might need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.
Note
MSAS connectivity is not supported for Mac and Linux.
Configuration
To configure the Kyvos connection, provide the following information in your connection screen.
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.
Points to remember
To use SSO and LDAP connections, users must be available in the Kyvos repository.
When using an IIF statement, both clauses are evaluated before choosing a proper value. In situations where this causes a logic issue, break the measure into two measures, and then create a third measure with a valid IIF statement.
Calculated members are not allowed in subselect and where clauses.
Subselect statements do not support multiple levels of a dimension on a single axis.
Copyright Kyvos, Inc. All rights reserved.