-
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
-
Did You Ever Try This?
Were you able to introduce bands with the suggestion I gave earlier? If you have further questions, please let us know.
Thanks.
Bill
-
Bands
Thanks. Created the bands as regular measure and that allowed the user to select the defined bands.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|