Procedure
- The relational database we want to query contains five columns: media, drink, unit_sales, store_cost and store_sales.
-
The query aims at retrieving the unit_sales,
store_cost and store_sales
figures for various media / drink
using an MDX query such as in the example below:
- Back on the Basic settings tab of the tMondrianInput component, set the Catalog path to the data warehouse. This catalog describes the structure of the warehouse.
-
Then type in the MDX query such as:
"select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns, CrossJoin( { [Promotion Media].[All Media].[Radio], [Promotion Media].[All Media].[TV], [Promotion Media].[All Media].[Sunday Paper], [Promotion Media].[All Media].[Street Handout] }, [Product].[All Products].[Drink].children) on rows from Sales where ([Time].[1997])"
- Eventually, select the Encoding type on the list.