Configuring Smart Push for a Simple Form

To configure Smart Push for a simple form:

  1. From the Home page, click Navigator Navigator icon, and then under Create and Manage, click Forms.
  2. Expand Forms, and then select a simple form.
  3. With the simple form selected, select Edit icon.
  4. Click Smart Push.

    The defined mappings for the form are displayed. Click create icon to add new mappings if desired.

  5. Expand each mapping.
  6. For each dimension shown under a mapping, specify the Smart Push region for the dimension:
    • Select Use Form Context to move data for all the members that were selected (and excluded) for the dimension on Layout.

    • Clear Use Form Context, and then next to Overwrite Selection, click Edit Arrow:

      • 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.

        • Exclusion of a base member won't exclude any shared members, so you must explicitly exclude both the base and shared members.

        • 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 in order 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 Member Selector icon 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 Remove icon or Remove All icon.

      • 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.

  7. For each mapping, define whether Smart Push will be automatic or manual:
    • Select Run After Save to automatically move the data when the simple 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.

  8. 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. This option is available for simple forms only.

      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)
  9. Click Save to save the Smart Push configuration for the form.