Can anyone recommend a decent business intelligence & reporting application that can be integrated into an OEM application?
Primary requirements are:
- Administrators can define cubes/dimensions etc (or we - the OEM - can predefine some)
- Report designers can easily inspect data by visually selecting dimensions, filters etc in an adhoc way that is quickly output with little upfront investment
- Report designers can design a report based on dimensions/filters and save their definition to be run as required
- Report viewers can view the reports defined by the report designers
All of this plus in .NET that can be branded/integrated into our existing web application's look and feel.
Permissions need to work off our user/groups system.
I've found a few that look good, but they are all in Java and I don't want to ask our clients to install ASP.NET for the app, and then Java, tomcat etc just for reporting.
Thanks
EDIT
Should have mentioned - I can't just use SQL Server Reporting Services - this needs to be database agnostic (although it will be connected to one) and needs to support a variety of data sources.
EDIT 2
Well - thanks to posting this question I saw an ad popup on the side of SO with a product that on the surface looks great.
I'll download the trial and give it a whirl tomorrow, and post back my findings.