Latest Answer: Hi,I can explain why a report performance is increased when we apply a filter at the universe level rather than at the report levelWhen we apply a filter in the universe level,after the query is fired,the data is filtered and then the required rows returnedBut ...
Latest Answer: Additionally-- Follow naming convention -- Objects and conditions in a class should be either hierarchial or alphabetical-- Classes/ Sub Classes should be logical-- Organize the schema, no clutters of joins ...
Latest Answer: BO automatically generates the SQL query when objects are selected into query panel. When you run the query, the query is processed to database based on your connectivity.for ex: If you run query using, Local Machine Full Client (BO reporter), ...
drill up : One level up in the HirearchyDrill down: One level down in the Hirearchydrill by : direct selection of level in the Hirearchydrill trough : to drill data from one Hirearchy to another Hirearchy
Latest Answer: Drill up : UP-one levelDrill down: DOWN-one levelDrill by : selection of level HierarchyDrill trough : Hirearchy to another HirearchyCheers,Sithu ...
Latest Answer: Did u mean that Measure objects??Ravi Kumar Garre ...
A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
Latest Answer: An alias is identical to base table with different name. The data in alias is
exactly same as original table/but the different name tricks SQL into accepting
that we are using 2 different tables.
An alias breaks the loop by using the same table ...
Expresses the minimum and the maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0,1, or
Latest Answer: Cardinality describes a join between 2 tables by stating how many rows of one table will match with rows of another table. It is very important to detect join problems and to create the contexts to correct the limitations of a target table. BO designer ...
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 logical grouping of objects and conditions within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.
Latest Answer: A Category is grouping of certain entities [reporting objects]. A class is a category of reporting objects. A object is an instance of class or a reporting field [entity]. A class can be further divided into sub classes. Ex: Sales class may contain sub-classes ...
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 ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 Next >>
Go Top
