Jump to content

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!

Link to post
Share on other sites
  • 4 months later...

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.

Link to post
Share on other sites
  • 8 years later...

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.





should be 






Edited by DaveC
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.

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...