Dimension Level & Member Browser Control
 

Looking for a control which I can use on Excel form to browse
dimension levels & members which enables multiple levels and members
to be selected. Just like in the Excel Pivot table, except I want to
handle the generation of MDX thereafter using these selected values to
give a static non-pivot table output into a worksheet.

Has anyone any ideas where I might find such a control or can harness
just that part of the pivottable object?

TIA
Lawrence

Dimension Level & Member Browser Control
 

Possibly a listview control.

--
Regards,
Tom Ogilvy

"Lawrence Orchard" wrote in message
om...
Looking for a control which I can use on Excel form to browse
dimension levels & members which enables multiple levels and members
to be selected. Just like in the Excel Pivot table, except I want to
handle the generation of MDX thereafter using these selected values to
give a static non-pivot table output into a worksheet.

Has anyone any ideas where I might find such a control or can harness
just that part of the pivottable object?

TIA
Lawrence