Jedox Web Actions: Element Selection

As a Jedox Report Designer, you can give the end users the ability to select elements from a dimension and use that selection as a part of a planning process. This eliminates the need to build specific reports, like those seen in the AIssisted Planning Wizards.

You can use the Element selection Action in the Jedox Spreadsheet and Canvas. To set up this Action in a spreadsheet, you should first select a form element (Button, Checkbox, List box, DatePicker, or ComboBox), and in a Canvas, you should add a native component that has Actions (Combobox, Button, Checkbox).

Below are the steps for setting up the Element selection Action for a Button in a spreadsheet. These steps are also applicable for configuring this Action in Canvas.

  1. In the Insert menu, click on the Button icon.
    Insert menu with Button option highlighted

  2. Click on the Actions tab and click on Add action. Select the Element selection action.

  3. The next dialog offers several options for the Action. Using the close button, you can close the action, and by clicking on the Bin icon you can delete the action.

    In the pull down menus, you can select a Named Range, Range, Static value, Settings key, or a Variable for the different options of the Element selection action. You can also merge the Server and Database. In the dimension section, you can choose between normal and virtual dimensions.
    In the Subset section, you can choose between an already defined subset or build a new subset.

  4. Label and format the button as desired.

Element Selection Confirmation dialog

When you choose the Element selection action in the Type of action dropdown menu, you can see the Confirmation dialog option at the end of the Action dialog.

In the Confirmation dialog, you can customize a confirmation message for the end user. You can add a Title, Body, Primary button label, Secondary button label, and an Icon to your customized message. The screenshot below shows a confirmation message:

Note: if you rename a sheet after setting up the action, you must reset the action too, or it will not work.

Action failure

You can choose between two options in case an action fails. First, choose to show a pop-up feedback dialog, and second, ignore the failure and go to the next action.

Updated April 9, 2024