Skip to Content

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

Listing plants with no sale data on yesterday

Hi Experts,

I try to create a webi report using bex olap conection from bw. The table shows the plants in which there is no sales yesterday.

(BO   4.1. sp 4)

(BEX 7.3. sp 9)

For example, today is : 26.10.2015 and sample data(Query1) is below.


How can I display 1003 value?

I can use "result from another query" option but this does not work with olap connection.

Former Member
Former Member replied

When the flag is dimension this option does not work. However, when I define the flag as measere and write the code as "=Sum(If ([Date] = [Yesterday]) Then 1 Else 0" it works after filtered as "flag EQ 0" value of this measure.

0 View this answer in context

Helpful Answer

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