We are using currently Executive Viewer Server and Web client (OCX Control in asp.net page) by Temtec (www.temtec.com
It has nice and easy functionality that probably will cover what you'll need (assuming you have shared dimensions) with little or no programming
Otherwise there are free controls - i.e. MS BI .Net control or commercial controls - i.e. Enterprise Blocks (http://www.eblocks.com/) and many others that can do the job with more or less programming


----- Murthy Jarugumilli wrote: ----

Our need
- Display multiple reports with little interactivity if any on a *single* asp.net page. The format of the reports is static in the sense that each report's axes are known at design time
- Each report goes against a different cube (all cubes in the same MSAS database
- The Users need to be able to filter across different dimensions that affect different reports (for instance they would select to see a particular product family, limit the time period, etc.

I am looking for some help to implement these dimension filters in conjunction with the reports. I'm assuming that the OWC pivot tables can't be used as I need multiple such pivot tables on the same page. I never saw any example showing multiple pivot tables on the same page. Is this true

These reports themselves can be easily coded using asp.net grids/html tables using adomd.net and MDX queries.

I appreciate any ideas (or existing controls) to show a common set of dimension filters (hierarchical) that I can use to apply against all of the reports' queries. We have many dimensions across different cubes (more than 10). Pivot tables have elegant dimension explorers for filtering, I'm wondering how I can take advantage of these. Do I have to write custom code using asp tree controls, manage state, etc.

Thanks muc
Murthy

FYI: Also posting this on office developer and adomd newsgroup

If Windows SharePoint Services (part of Windows Server 2003) is an
option, then multiple OWC 2003 PivotView Web Parts can co-exist on a Web
Parts page - don't know if their filters can come from a single source
on the page:

http://www.microsoft.com/downloads/d...8BE67A5-2056-4
6A1-84B1-337FFB549C5C&displaylang=en


The Web Parts from DSP Portal Edition (a 3rd-party product) can be used
to drop multiple OLAP-based tables/charts on a Web Part Page. These can
be connected to Filter Web Parts, which allow common selection of OLAP
Dimension members:

http://www.dspanel.com/files/dsp_portaledition_so.pdf


- Deepak

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

You even can use www.gmsbv.nl / www.reportportal.com ReportPortal 1.3
as full BI Portal Suite

Regards,
Marco

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote