Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need distinct rows in BO XiR3 Webi report

I have a report which is similar to below example. Report has multiple other columns like Issue owner, created date, target date etc which are different (means data doesnt repeat in any row and all are dimensions)

1. User wants one single row for each ID. How to achieve this in BO Webi XiR3?

IDIssueSeverity
11.1

High

11.2High
22.1High
22.2Medium
22.3Low
33.1High
33.2Medium
33.3Medium

2. Above table is a detail tab. There is also summary tab which is as below. Requirement is that Count for High, Medium and Low in Summar tab should match with the count in detail tab and also should match with the row count in detail tab. This means only when ID column is unique, it will match with row count

Original Target DtCurrent Target DatePrimary OwnerHighMediumLowTotal
1-Jan15-JanA43714
30-Jan14-FebB6208
24-Feb17-MarC56718
Total:15111440

Please help me to achieve the above target in BO report

Former Member
Not what you were looking for? View more on this topic or Ask a question