Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

need help in getting data from OLAP

 
vamshikrishna chinta
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

Greetings.

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.

 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
vamshikrishna chinta
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Thanks for the rely.You mean to say the code is same for getting the data from oracle or it is from Cubes?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic