468,167 Members | 1,959 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,167 developers. It's quick & easy.

SAP Business Objects BO3 Webi Report

Good Afternoon,

If anyone is familiar with Webi reports in BO3, I am trying to write a variable which will only display rows with duplicate values of a particular object.

Example: I would only like to display the rows in which ID = 01.

ID Name Code Dupe Variable
00 Ted Bundy SRK Not
01 Jim Jones KLD Dupe
01 Jim Jones KLD Dupe
01 Jim Jones KLD Not
02 Den Rader BTK Not

I have tried using Previous in a variable but that does not indicate all duplicate rows as "Dupe"

=If([SSAN with Hyphens])=Previous([SSAN with Hyphens]) Then "Dupe" Else "Not"

However, the third row for ID 01 will still reflect as "Not".

I just need a variable that will somehow group like IDs together and only display those rows.

Thank you.

Mike M
Jun 7 '18 #1
1 720
Hello,

I found the answer on a SAP related forum. The variable is a measure (let's call the measure DUPES):
=Sum(Count([object with multiple values]) In Body) In ([Object with multiple values])

Then just do a simple report filter where DUPES is greater than 1.

Awesome
Jun 8 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

25 posts views Thread by Stuart Hilditch | last post: by
5 posts views Thread by G. Stewart | last post: by
25 posts views Thread by Penelope Dramas | last post: by
1 post views Thread by gcdp | last post: by
reply views Thread by kamranasdasdas | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.