How to Run a Dax Query from a Java Program?

Learn how to run a DAX query from a Java program, including setting up the JDBC connection, executing the query, and processing the results.

DAX Query

evaluate
(
   summarize
  (
   'Internet Sales',
   'Internet Sales'[Sales Order Number],
   'Internet Sales'[Sales Order Line Number]
  )
)
order by
  'Internet Sales'[Sales Order Number],
  'Internet Sales'[Sales Order Line Number]

How to Execute the Above Query Using a Java Program

DAX (Data Analysis Expressions) is a formula language used in Analysis Services, Power BI, and Power Pivot for data modeling and analysis. It allows users to retrieve and manipulate data and provides advanced calculations, filtering, and aggregation capabilities for analyzing large datasets.

Below is an example of running a DAX query from a Java program:

• Select a Mondrian XMLA JDBC driver to connect to Analysis Services.
• Configure the necessary connection parameters: server URL, username, and password.
• Construct a DAX query as a string in your Java application.
• Create a statement object, assign the query, and execute it.
• Retrieve and process the results within the Java program.

Below is the code snippet:

import java.sql.*;

public class SampleQuery {
  public static void main(String[] args){
   String url = "jdbc:sqlserver://localhost:1433;databaseName=xxxxxxxx";
   String username = "xxxxxxx";
   String password = "xxxxxxx";
   String query = "evaluate ( summarize ( 'Internet Sales', 'Internet Sales'[Sales Order Number], 'Internet Sales'[Sales Order Line Number] ) ) order by 'Internet Sales'[Sales Order Number], 'Internet Sales'[Sales Order Line Number]";

   try (Connection con = DriverManager.getConnection(url, username, password);
   Statement statement = con.createStatement();
   ResultSet resultSet = statement.executeQuery(query)) {
   while (resultSet.next()) {
     int salesOrderNumber = resultSet.getInt("Sales Order Number");

     // Print the values of each column
     System.out.println("Sales Order Number: " + salesOrderNumber);
   }
   } catch (SQLException e) {
   e.printStackTrace();
  }
  }
}

Note: Replace the "Username" and "password" fields with your own login credentials. Additionally, update the URL with the server details specific to your account.

With these steps, you can seamlessly integrate DAX queries into your Java applications, enabling refined data analysis directly from your software.