Skip to Content

Deriving a characteristics at BEX Report level

Dear Experts,

We'd a certain Requirement - Where a characteristic is to be derived based on Key figures & Character

Scenario is as like below.

In the below mentioned cross tab "Character to be Derived " column to be derived based on below mentioned condition

a. if Reaso = # & Order Qty = Invoice qty then Character to be derived as 'Y' else #

OrderNo OrderItem Reaso Charactertobederived OrderQty InvoiceQty

O1 10 X X 10 0

O1 20 # # 10 5

O2 10 # Y 10 10

Thanks

-Ram

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 02 at 04:49 AM

    You can use BADi RSROA_OLAP_BADI for creating virtual characteristics with your logic :

    https://wiki.scn.sap.com/wiki/display/BI/Virtual+Key+Figures+and+Characteristics

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Lancev,

      This BADI is Working fine..

      It's working on Composite Providers also - Cool Feature.

      I'd applied that logic also at BADI Level only...

      But how to use on the below is ??

      Moreover, Does it work only Key figures or CKF also can be utilized in the calculations.

      Thanks & Regards,

      Ram.

  • Posted on Jul 03 at 11:25 AM

    Dear Lancev,

    This BADI Will work only on Info Cube or does it work on Composite Providers also.

    Thanks & Regards,

    Ram.

    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.