Skip to Content
0
Former Member
Apr 21, 2010 at 08:47 AM

BO( WEBI,QAAWS ) can't sustain bw query : create new calculate Key Figure ?

17 Views

BO( WEBI,QAAWS ) can't sustain bw query : create new calculate Key Figure ?

I create three new calculate Key Figure : TotalQty1,Rate1,TotalRate1 on bw query. Return values:

TSAS defect1 Qty TotalQty1 Rate1 TotalRate1

weight inaccuracy 33.000 33.000 37.500 % 37.500 %

poor function 10.000 43.000 11.364 % 48.864 %

gap out of spec 9.000 52.000 10.227 % 59.091 %

scratch /crack/ dam 8.000 60.000 9.091 % 68.182 %

broken glass/mat 5.000 65.000 5.682 % 73.864 %

missing display 6.000 71.000 6.818 % 80.682 %

assembly defect 4.000 75.000 4.545 % 85.227 %

plastic deformed 4.000 79.000 4.545 % 89.773 %

no function 4.000 83.000 4.545 % 94.318 %

poor printing 5.000 88.000 5.682 % 100.000 %

But Create on universe connect to this bw query, I used QAAWS and WEBI to runat , TotalQty1,Rate1,TotalRate1 key figure values are Qty value, that is error:

TSAS defect1 Qty TotalQty1 Rate1 TotalRate1

weight inaccuracy 33 33 33 33

poor function 10 10 10 10

gap out of spec 9 9 9 9

scratch /crack/ dam 8 8 8 8

broken glass/mat 5 5 5 5

missing display 6 6 6 6

assembly defect 4 4 4 4

plastic deformed 4 4 4 4

no function 4 4 4 4

poor printing 5 5 5 5

pho:

BW QUERY: [http://space.itpub.net/attachments/2010/04/10339719_201004211645561.thumb.jpg|http://space.itpub.net/attachments/2010/04/10339719_201004211645561.thumb.jpg]

WEBI:[http://space.itpub.net/attachments/2010/04/10339719_201004211637351.thumb.jpg|http://space.itpub.net/attachments/2010/04/10339719_201004211637351.thumb.jpg]

QAAWS:[http://space.itpub.net/attachments/2010/04/10339719_201004211637591.thumb.jpg|http://space.itpub.net/attachments/2010/04/10339719_201004211637591.thumb.jpg]

Why? BO can't sustain bw query : create new calculate Key Figure ?

Who to figure out this question?

Because I can't to do create new calculate Key Figure in webi or Xcelsius ,So ,I create new calulate Key Figure on BW QUERY.

Thank you.

BestRegards,

Howard.

Edited by: flying on Apr 21, 2010 10:48 AM