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.

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.