A qualified data reference (QDR) is a reference to a subset of the values in a data source. For example, a QDR might refer to a Sales measure, but only to those values in a specific month. In another example, a QDR might refer to a Units measure, but only to the single value that represents the units of TVs that were sold by catalog in June in New York. It is also possible for a QDR to refer only to a dimension. For example, you might want a reference only to the Product dimension. In this case, the QDR refers to all of the members in the Product dimension.
BI Beans includes the following qualified data reference objects:
oracle.dss.util.QDR
-- Specifies a qualified data reference that can be used in rules formatting for presentation beans.
oracle.dss.util.OlapQDR
-- (Extends oracle.dss.util.QDR
) Specifies a qualified data reference that is used when creating Selection
objects. In addition to the information that is included in a QDR
object, an OlapQDR
object can include level, hierarchy, or both level and hierarchy information.
Qualified data reference objects are structured as a set of dimension-member pairs with the following characteristics:
Each dimension is a non-null String
, which identifies the dimension that is being limited.
Each member is either a QDRMember
object or an OlapQDRMember
object. The member objects identify what the dimension is being limited to.
The following classes represent member objects for qualified data references:
oracle.dss.util.QDRMember
-- Specifies the members of a dimension that a QDR
object should consider
oracle.dss.util.OlapQDRMember
-- (Extends oracle.dss.util.QDRMember) Specifies the members of a dimension that an OlapQDR
object should consider
To construct a QDR
object, you can add QDRMember
objects of the following types:
Fixed -- Refers to a single dimension member, such as the "Shoes" or "Tokyo".
List -- Refers to a list of dimension members, such as "Paris, "London", and "Madrid".
Varies -- Refers to all members of a dimension. This type is used for dimension-only QDR objects and for ranking reports.
As an example that uses type Varies, consider a ranking report that displays the top three products based on Sales, in June, by Direct channel for each city. The product dimension is limited to top three by Sales value for a given city; the Time dimension is limited to June; the Channel dimension is limited to Direct. However, the Geography dimension is not limited because the report should display the specified data for all cities in Geography. Therefore, Geography varies.
To construct an OlapQDR
object, you can add OlapQDRMember
objects of the following types: Fixed and Varies. OlapQDRMember
objects do not include members of type List.
The following methods are available in both QDR
objects and OlapQDR
objects for comparing qualified data references:
equals
-- Specifies whether this QDR
or OlapQDR
is equivalent to the specified QDR
or OlapQDR
.
isProperSupersetOf
-- Specifies whether this QDR
or OlapQDR
is a proper superset of the specified QDR
or OlapQDR
. For one object to be a proper superset of another object, the first object must refer to all of the values of the specified object and to additional values.
isProperSubsetOf
-- Specifies whether this QDR
or OlapQDR
is a proper subset of a specified QDR
or OlapQDR
. For one object to be a proper subset of another object, the first object must refer to some, but not all, of the values of the specified QDR
or OlapQDR
.
isSubsetOf
-- Specifies whether this QDR
or OlapQDR
is a subset of a specified QDR
or OlapQDR
. A subset differs from a proper subset in that a subset can be equivalent to the specified QDR
or OlapQDR
of which it is a subset.
isSupersetOf
-- Specifies whether this QDR
or OlapQDR
is a superset of a specified QDR
or OlapQDR
. A superset differs from a proper superset in that a superset can be equivalent to the specified QDR
or OlapQDR
of which it is a superset.
For additional details and examples, consult the javadoc for these methods in the QDR
and OlapQDR
classes.
Creating Measure Condition Steps
Creating Rules for Formatting Dataviews