The following list describes how you can customize the components that are to appear in a
QueryBuilder. The methods that are listed are contained in the
oracle.dss.queryBuilder.QueryBuilder
class.
setApplyAllowed
-- Specifies whether to display the Apply button.
Note: The Apply button applies all previously unapplied changes without closing the QueryBuilder.
setCalculatedMeasuresCreationAllowed
-- Specifies whether to display the
Calculated Measures button in the Items panel.
Note: The Calculated Measures button displays the CalcBuilder, which allows a user to create a calculated measure, such as Sales minus Quota.
setConditionGroupingEnabled
-- Specifies whether to group the available conditions in the
Conditions panel into folders.
setDefaultAction
-- Specifies the default action (that is, Add, Keep, or Remove)
to appear in the Action box in the Members, Conditions, and the Favorites
panel.
Note: If you do not use this method, then the default action for the Members and Favorites panels is Add, while the Conditions panel uses the default action for the QueryBuilder.
setDimensionVisible
-- Specifies whether to display the Choose
box in the Dimensions panel.
Notes: The Choose box allows a user to specify the dimension for which to specify a set of members.
In a QueryBuilder whose mode is set to Wizard, a separate Dimensions panel appears for each dimension. Because this eliminates the need for the Choose box, set this method to false when using the Wizard mode.
setHierarchyVisible
-- Specifies whether to display the
Hierarchy/Levels box in the Conditions panel.
setQualifierVisible
-- Specifies whether to display, for each measure in a condition,
the For box and the Qualify button in the
appropriate Edit Step dialog box.
Note: The Qualify button displays the Qualify Measure dialog box, which allows a user to qualify a measure in a condition.
setSaveAllowed
-- Specifies whether to display the Save
button in the Dimensions panel.
Note: The Save button displays the Save dialog box, which allows a user to save a selection as a favorite.
setSortAllowed
-- Specifies whether to display the Sort
button in the Dimensions panel.
Note: The Sort button displays the Sort Items dialog box, which allows a user to specify the sort criteria for members of a particular dimension.
Customizing a QueryBuilder
Customizing QueryBuilder Behavior
Customizing QueryBuilder Panels
Customizing the Display of Folders in QueryBuilder