Code Snippet: Using Saiku via HttpClient + Java

gistfile1.txt

The following code demonstrates how to interact with the saiku webapp backend via Java.
You can check it out here: https://gist.github.com/3060118

Basically it creates a http session (important for authentication) and then executes the following steps: 

1. authenticate 
2. check if authentication was successful 
3. fetch a query called "test.saiku" 
4. post the xml of that query to the workspace 
5. execute the query 
6. execute the drillthrough on a returned result of the query