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.

PlantDateQuantity
100125.10.201510
100225.10.201510
100324.10.201515
100425.10.201538

How can I display 1003 value?

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

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

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