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.

Questions by vvatrapu

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions