Listing plants with no sale data on yesterday
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.
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.