on 07-21-2016 3:54 AM
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
Hi Srikanth,
It is best to create such measures directly in the universe. Is there a reason why you are not doing that?
Regards,
Mustafa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Mustafa for your response.
I'm trying out ways of achieving some requirements. I will have to show the counts of products as KPI's based on these flags (multi KPIs for Products shown on dashboard). Also on click of these KPIs I will have to filter the scorecards/crosstabs and other charts based on these products KPIs (say a crosstab showing all products for that region, and on click of "# Flag A Products" KPI on the dashboard, the crosstab will show only those Flag A products.)
My intention of trying this approach is to see if I can achieve counts in script as well get the concatenation of all those Flag A products and Flag B products in some global variables and pass them as setFilter to the respective chart Datasources.
Thanks,
Srikanth
Hi Srikanth,
One approach to achieve your requirement would be to use the SCN Design Studio Development Community Data Iterator component to loop through the rows of your data source result set and then increment corresponding flag counter variables as well as building a concatenated product string based on an if then statement.
Regards,
Mustafa.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.