Creating MDX Forms

The displayed rows, columns, and slice members of MDX forms are defined using MDX queries. All other properties remain similar to how they are set for Classic simple forms. The resulting grid retains member access filtering and cell attributes.

To create an MDX Form, configure the form in the Form Designer, validate its query, and verify the saved form at the intended user context. You can also convert and save an existing Classic form to create an MDX form, in which case, the Classic form will be removed from the application.

To create an MDX form:

In the Navigator, click Forms under Create and Manage.
From Actions, select Create simple form. Alternatively, select an existing simple form and then click Edit.
On Properties, enter required information such as the form name and select the cube that will be the data source for the form.
Click Layout.
Add at least one dimension each to the row and Column axis.
In Grid Properties, select MDX as the value in Grid Mode.
Enter the MDX query that sets the form design. Specify what needs to be present in the form's columns, rows, and so on. The following is a sample well-formatted MDX query that identifies the application, cube and members, and the additional dimensions required by the target cube:
```
SELECT
  {[Jan], [Feb], [Mar]} ON COLUMNS,
  {[West].[CA], [West].[NV]}
    DIMENSION PROPERTIES MEMBER_UNIQUE_NAME ON ROWS
FROM [SampleApp].[Plan1]
WHERE (
  [Account].[Sales],
  [Actual],
  [Working],
  [FY26],
  [USD]
)
```
Optional: Click Validate to verify that the MDX query is valid.
Click Save.