Skip to Content

How to Display report on the basis of Priority

Hi Experts,

I am having one requirement where user is entering a values on the basis of Store (Selecting from select member as Store 1 and Store 2 as input templates are same for both).

but displaying report its displaying data on the basis of Priority ..And doing a total on the basis of Priority only .

Please refer below given image ..

So here is problem how to do grouping of rows on the basis of Priority ?

Thanks,

Ravi

pri.jpg (111.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi Vadim,

    User want to give Priority for each request and if Priority is 1 then means it's need to approve for this year budget

    and if Priority is 2 or 3, 4 means not that much important .

    Now my client want to see the report on that basis of Priority that ok how many stores has submitted Priority 1 request for this (current year ) budget ..

    Thanks .

    Ravi

  • Hi Vadim,

    I have closed the questions ..

    Thanks,

    ravi

  • Number of questions are closed with incorrect reason: Right answer was accepted, but no answer was accepted!

  • Get RSS Feed

8 Answers

  • Best Answer
    Feb 20, 2017 at 09:46 AM

    For sure you can sort members using single property! In the member selector use "Member Sorting". What's the issue?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16, 2017 at 05:01 PM

    Requirement is strange... BPC is not a request based system!

    For sure you can create additional dimension Priority and post data to the required member: P1,P2,...

    But to my mind it's a wrong approach!

    The whole business process have to be discussed.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim,

      Please find right screen ..

      But i can not find option in the filter or some where to group the Property ..

      Please help to know how to display this as P1 in one group and P2 in another group on the same report or input tempate?

      Thanks,

      Ravi

      group.jpg (20.4 kB)
  • avatar image
    Former Member
    Feb 16, 2017 at 05:33 PM

    Hello,

    As per my understanding your table has data as follows

    If it is so than you only need to group your report on priority and get its summary.

    Thanks

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2017 at 10:30 AM

    Hi Experts ,

    The same issue I have but Priority P1 under here maintaining some groups (P1- Comupter for office, Building for library, Tables for office furniture) all these for other Priorities P1,P2,P3 maintaining. But user is expecting Grouping on Priorities under sub groups with respective Offices.

    Regards

    Vadan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 07:26 AM

    Can't comment under your last comment!

    The logic on this picture:


    is totally incorrect!

    What is Req??? I see text values on the report, Same for LOC etc...

    Please show real dimension administration screenshot!

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim,

      Please find the screen ..

      And while generating a report i am getting like below

      But according to client it should be P1 group and P2 Group..Like below ..

      Please make a note here you can see P1,P2 in the report i just added for your reference to understand ..but i need group like that.

      Thanks,

      Ravi

      report12.jpg (23.3 kB)
      matrix.jpg (38.0 kB)
  • avatar image
    Former Member
    Feb 21, 2017 at 03:42 PM

    Hello All,

    I am having same problem and want to show the group but i am not getting Member sorting in Member selector in SAP BPC 10.1, Any one please help me to tell me the steps to get Member sorting in Member selector option in SAP BPC 10.1 NW.


    Warm Regards,

    ANDO

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 25, 2017 at 10:39 AM

    Yes Vadim, I am working for SAP BPC 10.1 NW version and EPM is Please refer below screen ..

    Let me know where i will get Member sorting in Member selector screen ...

    Sorry i m not able to comment on your message so that is why putting my comment in this box.


    Thanks,

    ANDO

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2017 at 01:38 PM

    Hi Vadim,

    I am able to add comment so putting information here ..

    \

    Please let me know to get option Member sorting in Member selector for dimension!.

    Regards,

    ANDO

    Add comment
    10|10000 characters needed characters exceeded