Skip to Content
0
Former Member
Jul 21, 2016 at 02:54 AM

dimension selection/filtering of data in script

28 Views

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

Attachments

product data.PNG (3.9 kB)