I am very new to this OLAP cubes and dimensions technology. We got one requirement to give a prototype to fetch the data from the AWM Cubes and dimensions and show it in JSp. We created the cubes and dimensions using AWM tool . And created the view with one of the plug in of AWM and displayed the data bu suing the JDBA connection.
But my manager wants to display tthe data from the cubes but not from the views.Can you please help me out by gingthe sample java code to connect to the OLAP cube and dimensions.
See the JDBC tutorial for the sample code to write SQL from Java. Also note that data warehouses are huge - you'll want to make sure the appropriate indexes are in place so your query performs decently.