Querying OLAP cubes Oracle from ASP.NET MVC

3809176

Hi,

we have an asp.net mvc web site with sql server database.

We need to query some OLAP cubes Oracle with millions of records for create ad-hoc reports.

What is the best way for make report at runtime without stress the web server?

Is it possible do OLAP queries via Oracle Developer Tools for Visual Studio and Oracle Data Provider for .NET?

What performance recommendations you suggest to me?

Thanks in advance

Ken Chin OLAP Option-Oracle

Hi,

There is an MDX driver that you might use to query OLAP cubes.

This is some additional information on how to query OLAP cubes using SQL.

https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/olap/olap_cube/querycubes.htm

Hope it helps,

Ken Chin