 Related Questions A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate Latest Answer : Table A having m records and Table B having n records then the cartesian prodcut is mXn. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in ... A component that controls the type and the amount of data returned by a specific object in a query. A condition created in the Designer module is referred to as a predefined condition.
Latest Answer : Lets you create a condition. The conditions that you define appear within the Universe window. From the Query Panel, a user can drag the conditions from the Classes and Objects box to the Conditions box.CheersSithu ... A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. In Designer you create Latest Answer : A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. In Designer you create a list of values by running a query from the Query ... In Designer a query is a technique for creating or modifying a list of values associated with an object. From the Query Panel, a designer builds a query from the classes, objects, and conditions of a universe. Latest Answer : the values what exactly the user need is queryCheers,Sithu ... Latest Answer : right click on any object,go to the properties.specify the query in select and put the next query in where clause,like select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2) ... Latest Answer : select @@version is the command that will give the said details ... Read Answers (1) | Asked by : PRAVEEN KUMAR Product date salesp1 20/Jan/1999 100p1 20/Feb/1999 200p1 20/apl/1999 100p1 20/DEC/1999 50p1 20/Jan/2000 100p1 20/mar/2000 500now i want query like product ,sum of actual year ,sum of business yearp1 450 750here actual year means 1 Jan 1999 to 31 st Jan 1999business year means 1 st APR 1999 to 31 st mar 200pls give me answer as early as possible.. Read Answers (1) | Asked by : reddepa Hello Guys,I am creating a WEBI from my universe which is using ORACLE database as backend. I have the following query which i need to automate. For that i need to create a filter in the unvierse i don't Latest Answer : Hi,This can be handled as a condition object. Understand from the filter name (as of date) The condition object query should only contain the below statement. But of course.. you should have the associate objects in the class only then u can use them.make ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
