SAP BusinessObjects Design Studio
Release 1.6 SP1 Patch 2 (Version: 16.1.2)
Source: Relational database, thru UNX
If i create a data source with the below structure:
Product Flag A Flag B Flag C
A 1 0 0
B 0 1 0
C 1 0 0
D 0 1 0
E 0 1 0
F 0 1 0
G 1 0 0
H 1 0 0
I 0 0 1
J 0 0 1
can we create 3 measures in script as below:
# Flag A Products = count(case when flagA = 1 then Product else null end)
flagAProductList = A;C;G;H
checked below reference links below but still couldn't solve the problem
https://scn.sap.com/thread/3490636
https://scn.sap.com/thread/3499036
Thanks,
Srikanth