Configuring Smart Push for a Form

Smart Push enables you to use data maps defined in the application to synchronize data automatically when you change data in forms. In this way, Smart Push enables you to access the functionality of a data map for real-time data movement.

When configuring smart push on a form having multiple segments, Oracle recommends you use an overwrite selection and provide the appropriate selection for the overwrite selections instead of using the form context. This limits the data transferred to only the necessary data to move, which promotes better performance.

If the form context option is selected, then the final selection is the cumulative selection from all segments of the selection as well as any excluded selections.

For example, if you choose three segments with selection such as:

Segment-1 --> ILvl0Descendants(Q1)

Segment-2 --> ILvl0Descendants(Q2) Exclude Selection: Feb

Segment-3 --> ILvl0Descendants(Q2) Exclude Selection: Mar

the final selection using form context is:

ILvl0Descendants(Q1) , ILvl0Descendants(Q2) Exclude Selection: Feb,Mar

If a segment is hidden in the form and the smart push is configured to use a form context, then the smart push also transfers data from the hidden segments to the target cube.

If the final selection is not a desired selection to move data, then configure the smart push to use the overwrite selection.

To configure smart push for a form:

From the Home page, click Navigator , and then under Create and Manage, click Forms.
Expand Forms, and then select a form.

The form can also be edited once the run-time view of the form is launched from a Navigation Flow or through the Data Card.
With the form selected, select .
Click Smart Push.

The defined mappings for the form are displayed. Click to add new mappings if desired.
Expand each mapping.
For each dimension shown under a mapping, specify the Smart Push region for the dimension:

Note:
The Use Form Context for dimensions on rows and columns uses the form design members to push, not the members on the form. For the POV and Page dimensions, Use Form Context uses the member shown on the form at run time.
- Select Use Form Context to move data for all the members that were selected (and excluded) for the dimension on Layout.
  
  The Page Dimensions use the member selected on the form.
- Clear Use Form Context, and then next to Overwrite Selection, click :
  - Select Edit to use the member selector to select the dimension members you want to work with.
  - Select Add Exclusion to use the member selector to define the dimension members you want to exclude from the Smart Push process. Remove Exclusion removes the entire exclusion; not just one member.
    Note:
    - Smart Push exclusions honor any exclusions defined in forms if the Use Form Context option is selected for Smart Push.
    - When excluding members from a dimension, the member list for the dimension must contain at least one member that is not on the excluded member list for the Smart Push process to successfully complete. For example, if the only Account member defined for Smart Push is Cash/Bank Account, you can’t exclude Cash/Bank Account from the Smart Push process. You must correct the selection so that Smart Push results include at least one member.
    To remove a member from the excluded list, click next to the excluded list of members. Remove the member(s) from the member selector by selecting the member in the right pane, and then clicking or .
    
    See Excluding Members from a Data Map
  - Select Clear to remove selections.
  Note:
  
  You can override a mapping definition on source cube dimensions only. You can override dimension members if you take the context from a form by selecting Use Form Context. You can also override dimension members if you specify members in the Member Selection dialog box, or if you leave Overwrite Selection blank.
  
  Tip:
  
  Smart Push makes incremental updates to the reporting cube. To achieve this, you can select the Use Form Context or Overwrite Selection options to limit the amount of data being moved to the current context or to limit the data movement to the section that you are updating or calculating.
If the Smart Push region isn't specified using one of the above options, then member selection is taken from the data map.
For each mapping, define whether Smart Push will be automatic or manual:
- Select Run After Save to automatically move the data when the form is saved.
- Leave Run After Save cleared to manually move the data.
  
  For information on how to manually move the data, see Moving Data After Configuring Smart Push.
Select from these additional Smart Push options:
- Run Smart Push in Background—Allows you to continue using the application while Smart Push runs in the background.
- Use Database Suppression—Enables you to apply row suppression at the database level instead of at the application level, which eliminates the impact on query thresholds and improves Smart Push wait times.
  
  The Use Database Suppression option is recommended if you are using Smart Push to load large amounts of data from a block storage cube and while using the missing block and row suppression options.
  
  If you use Groovy rules to configure Smart Push with the Use Database Suppression option, there is an additional parameter to specify this option for Smart Push execution:
```
public void execute(Map<String, String> overrideMembersMap, boolean suppressMissingRowsNative)
```
Click Save to save the Smart Push configuration for the form.