Need only Duplicate Records in Bex Report

[Former Member]

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

[former_member194898 · Accepted solution]

Hi,

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

Just an idea

Regards, Leszek

[Former Member · Accepted solution]

Hi Leszek,

Can you please explain clearly what's  your Idea how to approach ...

Regards,

Ravi

[former_member194898 · Accepted solution]

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