M
Murthy Jarugumilli
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 much for any idea
Murthy
FYI: posting this on adomd.net and sql server olap newsgroups
- 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 much for any idea
Murthy
FYI: posting this on adomd.net and sql server olap newsgroups