Document toolboxDocument toolbox

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)

For 2012 SP1 (version 11.0.2100.60)

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.