You can use the graphical query designer in Design or Query mode to build a Multidimensional Expression (MDX) query by browsing the underlying data structures on the data source. At design time, you can interactively run a query from the query designer to see the results. The query you build defines fields in the dataset. At run time, the actual data is returned from the data source. Use the graphical query designer to perform the following actions:
-
In Design mode, drag dimensions, hierarchies, members, and member properties from the data source onto a Data pane to build a Multidimensional Expression (MDX) query. Drag calculated members from the Calculated Members pane to the Data pane to define additional dataset fields. For more information, see Using Hyperion Essbase MDX Query Designer in Design Mode.
-
In Query mode, drag dimensions, hierarchies, members, and member properties onto the Query pane or type MDX text directly into the Query pane. Drag calculated members from the Calculated Members pane to the Data pane to define additional dataset fields. For more information, see Using Hyperion Essbase MDX Query Designer in Query Mode.
As you build queries, the query designer automatically adds default properties to the MDX query. To include properties other than default properties, you must manually modify the MDX query. For more information, see Using Extended Field Properties for a Hyperion Essbase Cube.
For more information about the graphical query designer interface, see Hyperion Essbase Query Designer User Interface.