Results 1 to 5 of 5

Thread: Customised Bands In Excel 2007

  1. #1
    Join Date
    Jul 2003
    Posts
    142

    Question 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.

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    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

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    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

  4. #4
    Join Date
    Jul 2003
    Posts
    142

    Smile Bands

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

  5. #5
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    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
  •