This is regarding Business Objects Univers creation.There are two objects which will be counting number of partners from table A based on two different conditions. Third object will calculate percent of (first object /second object). Example Z% = (X / Y) * 100When the same logic is implemented in BO, a query is being generated automatically and it is incorrect. It will be Select count (A.NBR)/ count (B.NBR) from A, B (It is alias of table A) where condition1 and condition2. Here condition1 and condition2 are mutually exclusive. Instead of generating this query, Business Objects should calculate based on the values returned by the queries of first two objects. We are not able to place a customized SQL into Business Objects.Anyone have any idea how to resolve this problem.Thanks in advance.RegardsSatish.

vvatrapu
Profile Answers by vvatrapu Questions by vvatrapu
Oct 11th, 2006
1
1676

Showing Answers 1 - 1 of 1 Answers

Sandhya Rani

Feb 16th, 2007

Hi Satish,Instead of creating a object what you mentioned above(x/y)*100., better to create an variable so that it will solve the problem as for as my knowledge goes.lets say1, object (x)2, object (y)create a varible naming (% of x & y)you will get the proper report.Thanks & RegardsCheers,Sandhya