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