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.
How Do You Currently Supply the Bands?
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
Great to Know it Worked ...
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