Skip to Content
author's profile photo Former Member
Former Member

Grouping in BW excel report

Hi Experts,

I have a requirement, where user wants to see report based on grouping. Its like, I have various materials in the report and user wants based on high prior material ( Mat 1, 3, 5, 10) Medium Priority material ( 13,4,2,6..) Low priority material ( 7,11,9). This material grouping may be changed, over a period of time. What is the best way to implement this requirement ?And also, if these grouping can be shown in the report then, they able to drill down to check the material belonging to them

thanks in advance

D bret

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 04:43 AM

    hi,

    i can give you a small idea regarding grouping reports

    create a exception for material's --- give priority for low, medium, high for each of

    the groupthen put you material id in free chata restrict which ever material

    details u want, that will be drill downed in report's

    if helpful provide points

    regards

    harikrishna.N

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 08:48 AM

    Dave,

    Would you consider using one of the Materials 'Material Groups' in master data. If it's a navigational attribute you will be able to report on the materials current status.

    Using a hierarchy for materials if you have a large volume of materials may prove to be too cumbersome.

    Regards

    Gill

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.