Jump to content
ftucker

Webi Report for duplicate values

Recommended Posts

Trying to create a report in Webi that lists duplicate values for particular records (such as duplicate Serial Numbers or Asset Numbers for Configuration Items) and it has been suggested that i need to do a self join to accomplish this. Has anyone done this in Webi (3.2) using the CA Service Desk (12.5) out-of-the-box universe? Would this be done by selecting "custom SQL" in the Edit Query view? Thanks!

Share this post


Link to post
Share on other sites

I usually do 2 separate queries and then do a either an explicit 'merge dimension' from WebI (the equivalent from the 'join' in SQL) or just use as a query filter a results from the 1st query.

Share this post


Link to post
Share on other sites

I have a column in SAP Webi that contains many duplicates numbers which is expected.  How can I add a unique character to each duplicate so the duplicates are now unique.

example

10

10

10 

should be 

10-1

10-2

10-3

thanks,

DaveC

Edited by DaveC

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...