423,113 Members | 1,976 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,113 IT Pros & Developers. It's quick & easy.

SAP Business Objects BO3 Webi Report

P: 2
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
Share this Question
Share on Google+
1 Reply


P: 2
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.