There's a tool called Prism that allows you to consruct multidimensional
("pivot") queries and analyses directly over any data source / table /
cube.

You may want to check it out. It's free to download at
http://www.sisense.com.




--
Smith7690