Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Overview

1. Specify required imports

2. Prepare the request

3. Call the method executeOlapQuery

4. Use the response

Example

1. Specify required imports.
   

   import org.olap4j.Cell;
   import org.olap4j.CellSet;
   import org.olap4j.OlapConnection;
   import org.olap4j.OlapStatement;
   import org.olap4j.Position;

2. Prepare the request.

   Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
   /* Append “xmlaKyvos” to your Kyvos URL in below statement.
   Catalog is the folder name where the cube is saved to run MDX query else give [Root] here.
   Specify “KYVOS” under DataSource.*/
         Connection connection =
   DriverManager.getConnection(“jdbc:xmla:Server=http://localhost:8080/kyvos/xmlaKyvos;User=Admin;Password=Admin;Catalog=FlightShopDetails;DataSource=KYVOS");
   OlapConnection olapConnection = connection.unwrap(OlapConnection.class);
   OlapStatement statement = olapConnection.createStatement();
   String mdx = "SELECT [Measures].[Miles Traveled] DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON COLUMNS,NON EMPTY CROSSJOIN( [Travel Agent].[Hierarchy].[Travel Agent].AllMembers, [Departure Airport].[Hierarchy].[Departure Country].AllMembers) DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON ROWS FROM [Flight Shop Analysis]";

3. Call the method executeOlapQuery.

   CellSet cellSet = statement.executeOlapQuery(String mdx, boolean getMemberDetails);
   /*Pass getMemberDetails as false to avoid sending further request for each member to fetch extra information like member’s parent, child count, etc. This would ensure a faster response.*/

4. Use the response.

   private static void getResponse(CellSet cellSet){
                List<CellSetAxis> cellSetAxes = cellSet.getAxes();
                for (Position row : cellSetAxes.get(0))
                {
                      if(cellSetAxes.size() > 1)
                      {
                            for (Position column : cellSetAxes.get(1))
                            {
                                  for (Member member : row.getMembers())
                                  {
                                      System.out.print(member.getName() + ":" + " ");
                                  }
                                  for (Member member : column.getMembers())
                                  {
                                      System.out.println(member.getName() + "=" + " ");
                                  }
                                  final Cell cell = cellSet.getCell(row, column);
                                  System.out.println(cell.getValue());
                            }
                      }
                      else
                      {
                            for (Member member : row.getMembers())
                            {
                                  System.out.println(member.getName());
                            }
                            final Cell cell = cellSet.getCell(row);
                            System.out.println(cell.getValue());
                            System.out.println();
                      }
                            }

Token based SSO

In the above example, basic authentication is used with a connection URL. But sometimes, users do not want to use their credentials in some scenarios. To deal with such scenarios, Kyvos provides another authentication mechanism which is token-based SSO. Users can invoke Kyvos Login REST API to get a token and then use that token with a connection URL. Users will have to perform the following steps to use token-based SSO.

1. Get a token using passwordless authentication in login REST API.
   To get the token using passwordless authentication, make the following configuration changes:

   1. Set the value for the authentication provider as HOST_APP in the config.json file.

   2. Provide the value for the userAuthenticationVerificationUrl property in the config.json. This property is used for passwordless SSO, details are mentioned in below section.

   3. Provide value for EXT_AUTH_HEADER_ID property in the properties file. EXT_AUTH_HEADER_ID defines parameter name(request parameter name) against which user token would be provided.

   4. Get token with username and token (password less authentication)

      In this authentication mode (passwordless), Kyvos relies on the verification server for user authentication. Below is the flow diagram and its description: 
      
      

      • To get a sessionid from Kyvos, the client application will have to call Kyvos login REST API by passing the following parameters:
        username, bearer token (GUID), mode=INTEGRATION, and optional custom data.
        http:<hostname>:<port>/kyvos/rest/login?username=&token=&mode=INTEGRATION&customData= 
        

      • Kyvos validates parameter values received in the login REST by making the REST call to the verification server on userAuthenticationVerificationUrl with username, token, and custom data.

      • The verification server validates the data, ensures that given parameters are valid, and returns true or false based on successful validation or failure.

      • If this verification REST call returns true as the HTTP response, then the SSO is successful, and the user session is created in Kyvos. Kyvos login REST call would return the successful response for this user session. For example, on successful authentication, REST API produces the response as:
        

        { 
        "RESPONSE": { 
        "SUCCESS": "90DB354A-EE34-6827-B3E2-2BAAECE5C2E2" 
        } 
        } 

      • In the above response, the value of the SUCCESS key is the token. Users can use this token for authentication with the connection URL as mentioned in the below example.

      • If the verification REST call returns a false response, the Kyvos login REST call will not issue any success response and SSO will fail.
        

2. Using Olap4j API with a token-based authentication (passwordless authentication)

Users can obtain a token from login REST API and can use the same for the authentication in Olap4j API. The user has to pass this token as a query parameter in the connection URL.
The parameter name should be the value of EXT_AUTH_HEADER_ID provided in the kyvosclient.properties file.
The connection URL should be in the below-mentioned format:
http://www.kyvosinsights.com:8081/kyvos/xmlaKyvos?<EXT_AUTH_HEADER_ID_VALUE>=<token returned by login REST API>

Example:
If EXT_AUTH_HEADER_ID=username and token=4EB72FAD-B899-D331-BB86-A8895883A870
then XMLA connection URL will be: http://www.kyvosinsights.com:8081/kyvos/xmlaKyvos?username=4EB72FAD-B899-D331-BB86-A8895883A870

You can use this connection URL in the code provided in the examples while using the token, do not provide any username and password.

Examples

Code to get the token from REST API.

String userName = <Kyvos_user_name>
String password = <Kyvos_user’s_password>
String kyvos_url = <Kyvos_URL>+"rest/login";
URL obj = new URL(kyvos_url);
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestProperty("Accept", "application/json");
con.setRequestMethod("POST");
String urlParameters = "username="+userName+"&token=<RANDOM_TOKEN>&mode=INTEGRATION&customData={\"HOST_NAME\":\"localhost.kyvosinsights.com\"}";
con.setDoOutput(true);
DataOutputStream wr = new DataOutputStream(con.getOutputStream());
wr.writeBytes(urlParameters);
wr.flush();
wr.close();             
int responseCode = con.getResponseCode();
InputStream in = null.
if (responseCode! =200) {
in = con.getErrorStream();
} else {
      in = con.getInputStream();
}
BufferedReader br = new BufferedReader(new InputStreamReader(in));
String inputLine;
StringBuffer responseStr = new StringBuffer();
while ((inputLine = br.readLine()) != null) {
      responseStr.append(inputLine);
}
br.close();
//extract token from the response.
String responseString = responseStr.toString();
System.out.println("responseString = "+responseString);
// response = {"RESPONSE": {"SUCCESS":"49CD3E8C-1D9F-1025-5B5D-19393E8DEBA3"}}

Use the value of the SUCCESS key from the response as a token in the connection URL.

Using token in connection URL.

if EXT_AUTH_HEADER_ID_VALUE=username and token=49CD3E8C-1D9F-1025-5B5D-19393E8DEBA3
then XMLA connection URL will be:
<Kyvos_URL>/xmlaKyvos?username=49CD3E8C-1D9F-1025-5B5D-19393E8DEBA3

This connection URL can be used with the sample code (Prepare the request) provided in the above example, and there is no need to provide User=Admin;Password=Admin; in this case.