Hi Experts,
Iam using BO 4.1 sp3, BW 7.4
Bex Designer:
* Formula variable is created for an Quantity Key figure which has reference characteristics as Plant AGGREGATION SET TO SUM.
KF2 Which is based on Quantity Key Figure formula variable defined in BEx Designer.
BO:
* when i use this CKF Quantity KF in the formula variable as:
sample = if Quantity <> 0 then 0 else 1 - Number Type Measure //
* Webi Output of Quantity KF:
54.22
0.83
2633.88
-328.65
0
323.82
-346.82
0
* Now in an report block filters i am adding an filter with the formula variable as:
sample not equalto 0 // kindly note that the sample webi formula variable using the Quantity Key figure above //
* KF3= Count([Plant]) // the count will vary depend upon the above filter formula variable
1) My Summary webi Report output with filter applied as sample not equalto 0 is below but when i drag and drop the detail plant.key into the report block the records are not in aggregation which is not my expected output:
DimHier KF3(hyperlink to detail report) KF1 Quantity KF2
XX 5 233 #unavailable #unavailable
xx1 2 346 #unavailable #unavailable
xx2 3 579 #unavailable #unavailable
2) My Summary webi Report output with filter applied as sample equalto 0 is below but when i drag and drop the detail plant.key into the report block the records are not in aggregation which is not my expected output:
DimHier KF3(hyperlink to detail report) KF1 Quantity KF2
XX 2 454 #unavailable #unavailable
xx1 1 232 #unavailable #unavailable
xx2 1 222 #unavailable #unavailable
Both the above cases structure is same. I wanted to show/toggle only one output at any time based on the filter selection either sample not equalto else sample equalto 0 outputs in webi and also iam getting same numbers in the KF3 count column field for both the cases.
Appreciate your Help. Kindly let me know if my above issue is not in understandable meaning.
Thanks,
Dinya