Customised Bands In Excel 2007

Please help.

I access my cube via Excel 2007. Curently we provide bands below to slice the cube by
<50%,
>=50 and < 60%
>=60% and <70%
>=70 and <80%
>=80 and <90%
>=90%
The users have a new requirement to slice the cube dynamically that is slice the cube by thier own defined bands. For example parameter, >=55% and < 69% >=70 and < 85%,
>=85% and <90% etc.
How can this be achieved in the CUBE? Is this a calculated Member/set job?

Thanks for your kind response.

Are the bands currently calculated members in the cube? If so, could you create a calculated member for each band, and then let the users select the desired band at runtime?

Thanks.

Bill

Were you able to introduce bands with the suggestion I gave earlier? If you have further questions, please let us know.

Thanks.

Bill

Thanks. Created the bands as regular measure and that allowed the user to select the defined bands.

Great to know you were able to get there. And especially nice to have direct access to the cube to make modifications to meet an Excel reporting need.

Thanks for letting us know!

Bill