Saturday 1 December 2012

Commbined 2 Subject Areas Common Things In OBIEE11g

When You Combined 2 subject areas we need to follow Below things

1.The number and data types of the columns to combine must be the same. The number of rows that are returned for each column can differ.

 2.You can select columns from the same subject area or from a different subject area, but the columns must have some commonality.

 3.You can specify one Set operation for one collection of criteria. For example, if you create criteria from the A-Sample Sales subject area, you can apply only one Set operation to those columns. You cannot apply different Set operations to different columns in the collection of criteria.

 4.You cannot use hierarchical columns, selection steps, or groups when you combine criteria.

No comments:

Post a Comment