File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes need help in getting data from OLAP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "need help in getting data from OLAP " Watch "need help in getting data from OLAP " New topic
Author

need help in getting data from OLAP

vamshikrishna chinta
Greenhorn

Joined: Aug 07, 2008
Posts: 6
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
vamshikrishna chinta
Greenhorn

Joined: Aug 07, 2008
Posts: 6
Hi,

Thanks for the rely.You mean to say the code is same for getting the data from oracle or it is from Cubes?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: need help in getting data from OLAP
 
Similar Threads
Help on choosing a good Java project
What do you think will become the next coming SQL trends ?
OLAP - how to ?
how to access olap objects in j2me application