views:

144

answers:

1

I'm developing my university graduation project and I'd like to include an OLAP-based reporting module.

In the past, I've used Mondrian with JPivot as an OLAP solution for Java projects and I'm looking for something similar using .NET. The tricky part is that my project should run on Mono and MySQL (installation environment is a Linux machine) so MSSQL OLAP is out of the question.

Anyone knows anything similar to Mondrian / JPivot that I can use? I don't mind even creating most of the aggregation tables myself as long as I have some sort of a crosstab/pivot control for my aspx page

A: 

I believe you can use basically any free OLAP servers such as Mondrian or Palo thats supports XML for Analysis (XMLA). Then you should be able to use the ADOMD.Net API to connect to and run queries. Not sure if ADOMD.Net works under Mono though.

Christian Vik
Mondrian is Java-only. I'll try Palo. Haven't seen any mention of ADOMD under Mono, though.I'm also going to need a freeware Pivot (crosstab) component akin to JPivot.Thanks :)
Electric Monk