Skip to main content
An Atoti session comes with its own dashboarding app but it can also be queried from other clients such as Excel. With Excel, the connection is done through the session’s /xmla endpoint. Create a new connection to an Analysis Services. Use this URL for the server field and choose to connect with:
  • Use Windows Authentication if Kerberos secures /xmla, which is the case when main_sso or xmla_sso is a KerberosConfig.
  • User Name and Password:
    • Without security, leave these fields blank.
    • With security, fill them with your basic authentication credentials.
Connect with Excel

​
Connecting to a session using OpenID Connect

Excel’s Analysis Services connector offers Windows (Kerberos) and Basic authentication only, so it cannot present the identity of an OpenID Connect provider. A session whose main_sso is an OidcConfig can still be queried from Excel, in one of two ways:
  • With a username and password: /xmla keeps accepting basic authentication, so define the credentials of the Excel users and give them roles.
  • With single sign-on, by setting xmla_sso to a KerberosConfig. /xmla then authenticates with Kerberos while every other endpoint keeps using main_sso, so Excel users are not prompted for a password.
The roles of a user authenticated on /xmla come from individual_roles and from the default roles of the provider that authenticated them.