Stack Overflow
Stack Overflow

Questions tagged [webi]

Webi is the shorthand name for Web Intelligence, a reporting tool within the SAP BusinessObjects suite.

171 questions
0
votes
0 answers

SAP BOE Webi Track Changes features identifies changes as Delete/insert instead of change

Trying to use SAP BOE Webi's Track changes feature and it is not working as expected. I created a simple two column report and turned on track changes since the last refresh. Then I updated the value of one of the columns on one of the rows in the…
Janet
  • 1
0
votes
0 answers

How to share the link of a web intelligence document to others

I've opened a SAP (BO) Webi riport which is interesting for some of us. Therefore I wanted to share the link of the specific Webi riport in outlook, so we could all talk about the same document. In the webrowser url I only see the same url, so I…
András Czeitner
  • 61
  • 6
0
votes
1 answer

SAP WEBI sharing link for webi document as a User

As a User when Open a webi document how can I share the link of the document ? In the browser header i only see the login URL so I cannot copy it from the browser.
András Czeitner
  • 61
  • 6
0
votes
0 answers

SAP BO Publication - sending emails to recipients from report

I have created publication based only on Excel file. Source report got one tab where I have created some kind of personalised message per contract. Put section on Contract IC and WEBI report is showing 9 pages (each page for each unique contract ID…
bekart
  • 66
  • 3
0
votes
1 answer

Webi 4.1 BO variable not aggregating

I have created a measure variable: = If IsNull([OBJECT 1]) And IsNull([OBJECT 2]) Then 0 ElseIf Not(IsNull([OBJECT 2])) Then DaysBetween([DATE 1];[DATE 2]) Else DaysBetween([DATE 1];[DATE 3]) This works fine when the Unique Object is…
ECEUK
  • 1
  • 1
0
votes
1 answer

WEBI: Trying to get a value based off of 2 other values being true

I have a formula that shows when an account has purchased an item : placement=Sum(If(([Sale Qty]+0>0 And ([Sale Items Qty]+0>=1));1)ForEach([Customer Nbr])) The issue I am having is that I need to show when a customer has purchased both possible…
Jonathan Roach
  • 1
  • 3
0
votes
0 answers

Error: RWI 00313 Error: INF When Assigning Reference

I have created a column in business objects that gives the count of information a column in which I used Concatenate to merge two numbers to create a unique number. When I assign reference to this column, so that I can then edit the formula for the…
Paige Rusch
  • 1
0
votes
1 answer

SAP Webi - Evaluate record for multiple conditions

Using webi 4.2: Each record contains I've created a variable, Category, using if conditions, but it only evaluates the record once. For example, ID 24 is identified as only New when it should be identified as both New and Termed. I need to identify…
hlock
  • 11
  • 4
0
votes
0 answers

Fill a column with a date that satisfies an id statement in Sap Phoenix Webi

I am trying to fill in the date needed column with the date that has 1 in Match comment and Rank columns. More specifically from all the comments I only need the ones that satisfy a pattern and then I ranked those based on activity date. I need to…
KateB
  • 76
  • 6
0
votes
1 answer

How do I get two rows of data when merging queries and the second contains multiple lines

I'm just started working with Webi (4.3) using the universe. I've created two queries using the drag and drop interface and filters and got it to display most of the data I am interested in by merging two queries from different classes(tables).…
JK36
  • 853
  • 2
  • 14
  • 37
0
votes
1 answer

Return only first of the month from column webi business objects

I have a column as below, what can I do to only return only the rows that are the beginning of the month when the query is called. In the case of the image shown it would return 01/04/2017. I dont have the option to convert the date column to the…
shazma
  • 55
  • 6
0
votes
0 answers

Web Intelligence - Countifs

I am trying to use an excel like 'Countifs' function in Business Objects, but it always outputs 1 which is incorrect. How do I replicate this to Business Objects? =IF(COUNTIFS('TabOne'!A:A,[@[Account Number]],'TabOne'!H:H,[@[Order…
N30C0rt3X
  • 31
  • 7
0
votes
1 answer

SAP webi 4.3 get first and last date of a selected month & year

I have a report that’s connected to oracle database. This report takes 2 prompts Month (in number) Year Is there a way that I can get the first date and last date of the selected month & year ? enter image description here
Hessa
  • 1
  • 3
0
votes
1 answer

How to export Structure from WeBI report

I want to get the technical name of the fields that are used in the WeBI report. Is there a way to export the structure of my report to retrieve the details. Thanks Niki
Niki
  • 1,161
  • 1
  • 20
  • 37
0
votes
1 answer

Show only last occurence of the field

I have an issue with a report I am trying to make in SAP. The problem is that I want to only show each SR NUM only once. But there are many appearances in my report. I saw that each number has multiple activities and comments and that is why there…
KateB
  • 76
  • 6
1 2 3
…
11 12