Closed.

Thank you all for your reply. I m going to check with the information you shared. Any other ideas will be appreciated before the discussion close.

Hi Actually we have several requests union together, some of them have positive measure, the others have negative measure. When we calculate '/10000' for each request on the same measure, the union result is not same as output 'all sum amount/10000'(sum all measure first, then do '/10000' on total). That is what we…

Thank you Jerry. "add a result column" option is working fine. This solution resolve my problem. 

Hi, OBIEE are actually installed on both B and C physically. A is a virtual IP which is to balance between B and C.