Skip to Content
avatar image
Former Member

Custom Report

Hello Gurus,

We have Requirement to Create report based on 15 customers and add some calculated and restricted key figures. Please let me know your thought , where do I filter customers ? is it possible to filter in Bex ?

Thanks in Advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 10, 2015 at 02:18 PM

    Hi Bond,

    There are different ways to restrict customers however need to choose best way,

    As per your requirement create authorization based reports this will solve the problem, if you restrict a query level , in future report maintain will become tough activity as we need to add new customers in all reports.

    If you goto authorization,lest create one report that will fit for all and less maintenance,.

    Please do share more about requirement so that you will get best approaches.

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      you can use conditons on the KF values.

      KF some values is populating - create the TOP N values.

      it will give the only TOP N customer when ever run the query.

      it will work based on the keyfigure value.

      Thanks,

      Phani.

  • avatar image
    Former Member
    Jan 11, 2015 at 08:37 AM

    Hi Bond,

    You can use Analysis authorizations for restricting users based on characteristic values to avoid creating multiple queries for each user.

    Regards,

    Rathish

    Add comment
    10|10000 characters needed characters exceeded