Understand MDX Worksheets

You can have one or more MDX Insert worksheets in an application workbook. With these worksheets, you can create corresponding MDX files in the cube, and you can optionally execute the MDX at the time you build the cube.

• To execute the MDX when you build the cube, indicate Yes in the Execute MDX field on the MDX worksheet in the application workbook.
• To execute te MDX after the cube is created, run the MDX script from the Essbase web interface, from Jobs.

The following image shows an MDX Insert worksheet in a sample application workbook.

The name of each MDX worksheet is MDX.scriptname, for example, for the mdxTest1 MDX script, the MDX worksheet is called MDX.mdxTest1.

The contents of the MDX worksheet are used to create an MDX Insert script in the cube. The MDX script uses the file name specified in the definitions area of the MDX sheet and has an .mdx extension. For example, filename.mdx.

Property or Field	Valid Values	Description
File Name	A valid MDX script file name.	The File Name field defines the MDX script name. The MDX script is created in Essbase when the cube is created. The script name in Essbase is the file name with an .mdx extension.
Execute MDX	Yes No	If you enter Yes, then the MDX script is executed at the time you build the cube. If you enter No, then the MDX script is not executed right away. In either case, each MDX worksheet creates an MDX script in Essbase, using the specified file name with a .mdx extension. That way, any of the MDX scripts can be executed at a later time.

You can create and delete MDX worksheets in the Designer Panel. See Work with MDX Worksheets in Cube Designer.

To learn more about MDX Insert, see Insert and Export Data with MDX and MDX Insert Specification.