Skip to Content
avatar image
Former Member

Need only Duplicate Records in Bex Report

Hi Experts ,

We have requirement like need only repeated Key values to display in report Out Put..

I have Fields Company Code ,Vendor , Document date ,Fiscper and Reference Number  in my Cube which gets data from 0FI_AP_4

Sample data .


Company Code     Fisc Per      Vendor            Doc.Number   Ref No.         Amount

AB11                    012.2008      112555              29.09.2008     6726116      -165.00

AB11                    012.2008      112555              29.09.2008     6726117       -125.00

AB11                    012.2008      112555              29.08.2008     6726118        -135.00

AB11                    012.2008      112555              29.08.2008     6726119        -135.00

AB11                    012.2008      112555              29.08.2008     6726120        -135.00

from the  above data I want data  of repeated key values I means  -135.00 data.

How to Achieve this in Bex or Modelling ..?

Regards,

Ravi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 16, 2015 at 09:27 AM

    Hi,

    What about creating a characteristic from the KF you use, then aggregate/count on that characteristic.

    Just an idea 😊

    Regards, Leszek

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      As far as I know it's impossible to aggregate/count on keyfigures.

      So create a characteristic that contain values from Amount KF (in text) that you can use while aggregating/counting). <= I hope this is possible, please search SCN.

      Then create a KF that you would use to count (set it's value to 1 so that it would be possible to count records using it).

      Hope that helps,

      Leszek