Create a Dataset Using a MDX Query Against an OLAP Data Source

Publisher supports Multidimensional Expressions (MDX) queries against OLAP data sources.

MDX enables you to query multidimensional objects, such as Essbase cubes, and return multidimensional cell sets that contain the cube's data. You create MDX queries by manually entering the MDX query or by using MDX Query Builder to build the query.

• Create a Dataset Using a MDX Query

• Use MDX Query Builder

Create a Dataset Using a MDX Query

You create MDX queries either by manually entering the MDX query or by using MDX Query Builder to build the query.

In your OLAP data source, do not use Unicode characters from the range U+F900 to U+FFFE to define any metadata attributes such as column names or table names. This Unicode range includes half-width Japanese Katakana and full-width ASCII variants. Using these characters results in errors when generating the XML data for a pixel-perfect report.

To create a dataset using a MDX query:

1. On the toolbar, click New Dataset and then select MDX Query.

   The New Dataset - MDX Query dialog is shown below.

   
   

   
   Description of the illustration xdo11g_dm_mdx_ds.gif

   
   
2. Enter a name for the dataset.
3. Select the data source for the dataset. Only the data sources defined as OLAP connections are displayed in the list.

   Any private OLAP data source connections that you created will also be available in the Data Source drop-down list.

4. Enter the MDX query or click Query Builder.
5. Click OK to save. The data model editor validates the query.