s it possible to set a filter condition in a cross product group in matrix reports?

1 Answer

Answer :

No

Related questions

Description : How can a group in a cross products be visually distinguished from a group that does not form a cross product?

Last Answer : A group that forms part of a cross product will have a thicker border.

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

Description : What is an organization structure in which each employee reports to both a functional (or division) manager and to a project (or group) manager, known as ? (A) Strategic business unit (B) Departmentation by customer (C) Matrix structure (D) Departmentation by territory

Last Answer : Answer: Matrix structure

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

Description : What is the lock option in reports layout

Last Answer : By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .

Description : How can I message to passed to the user from reports?

Last Answer : By using SRW.MESSAGE function. (Continued on next part...)

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

Description : What are the two repeating frame always associated with matrix object?

Last Answer : One down repeating frame below one across repeating frame.

Description : What is difference between Tablular and Matrix report? OR What are the different styles of reports?

Last Answer : Tablular report: A tabular report is the most basic type of report. Each column corresponds to a column selected from the database.

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Last Answer : True

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

Description : ON WHICH ENTITY IS THE CROSS-VALIDATION RULE APPLICABLE?

Last Answer : - It’s a feature of Key flexfield, applicable on Value Sets. 

Description : CROSS VALIDATING VALUES

Last Answer : - For key flexfields with multiple segments, we can define rules to cross check value combinations entered with in the key flexfield segments. This option is referred as Cross Validation rules.

Description : The Manufacturer of aeration devices reports the oxygen transfer rate of the device obtained through laboratory tests carried under standard conditions. Such standard condition are : (a) Wastewater at zero DO, 25°C and 760 mm ... DO, 20°C and 760 mm Hg (d) Wastewater at zero DO, 0°C and 700 mm Hg

Last Answer : (c) Tapwater at zero DO, 20°C and 760 mm Hg

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

Description : which system variables can be set by users?

Last Answer : SYSTEM.MESSAGE_LEVEL SYSTEM.DATE_THRESHOLD SYSTEM.EFFECTIVE_DATE SYSTEM.SUPPRESS_WORKING

Description : What is the built-in used to get and set lov properties during run-time?

Last Answer : Get_lov_property Set_lov_property Record Group

Description : What database events can be set? (for DBA

Last Answer : The following events are frequently used by DBAs and Oracle Support to diagnose problems: " 10046 trace name context forever, level 4 Trace SQL statements and show bind variables in trace output. " 10046 ... . On Unix, you can type "oerr ora 10053" from the command prompt to get event details.

Description : What is a database EVENT and how does one set it? (for DBA

Last Answer : Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these ... changes to the INIT.ORA file will affect all sessions once the database has been restarted.

Description : Atleast how many set of data must a data model have before a data model can be base on it?

Last Answer : Four

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

Description : VALUE SET LIST TYPES

Last Answer :  List of values (10 to 200)  Long list of values (> 200)  Poplist (> 10)

Description : A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B a) is in 1NF b) is in 2NF c) is in 3NF d) is in BCNF

Last Answer : a) is in 1NF

Description : Name the three major set of files on disk that compose a database in Oracle

Last Answer : There are three major sets of files on disk that compose a database. All the files are binary. These are ∙ Database files ∙ Control files ∙ Redo logs The most important of these ... actual data resides. The control files and the redo logs support the functioning of the architecture itself.

Description : What is Set-at-a-time or Set-oriented?

Last Answer : The High level or Non-procedural DML can specify and retrieve many records in a single DML statement. This retrieve of a record is said to be Set-at-a-time or Set-oriented.

Description : What is Relationship set?

Last Answer : The collection (or set) of similar relationships.

Description : What is Weak Entity set?

Last Answer : An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

Description : What is an Entity set?

Last Answer : It is a collection of all entities of particular entity type in the database.

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Description : What is the use of break group? What are the various sub events a mouse double click event involves?

Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

Description : What is a Query Record Group?

Last Answer : A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns ... rows retrieved by the query associated with that record group. What is a Non Query Record Group?

Description : How many number of columns a record group can have?

Last Answer : A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

Description : Can a formula column referred to columns in higher group?

Last Answer : Yes

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

Description : Can object group have a block?

Last Answer : Yes , object group can have block as well as program units.

Description : What are object group?

Last Answer : An object group is a container for a group of objects. You define an object group when you want to package related objects so you can copy or reference them in another module.

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE