Assignmen 11 - Exercise 3

 Emerged

1998 with the first appearance of commercial applications  Created to query OLAP databases  Query multidimensional data sources (cubes)  Two capacities: › Expression language to calculate values › Query language to retrieve data

 Tuple

› A tuple is a collection of members, each

selected from a different dimension › The tuple is the basic unit to form an axis › Only one member from each dimension can exist in a tuple › Square Brackets ‚[]‘ are used as delimiting characters

 Axis

› An axis is a group of members from one or

more dimensions, organized as tuples › Principle use is placing or filtering specific cube values along the dimension members with which they are associated. › Axis specification takes place after the SELECT-Keyword

 Set

› Enclosed by curled brackets ‚{}‘ › Often appear in the SELECT part of a

query, acting to specify the cells of a cube that are to be returned by the query › Typically consists of a group of one ore more tuples where the ordering of the tuples is significant

 Output

of a MDX-query is a cube which can have one or more axes  A query has one or more axes ( the first three axes are known as COLUMNS, ROWS and PAGES)  Each axis contains a set of members of a dimension or a group of dimensions  When more than one dimension is mapped on an axis we talk about ‚tuples‘

 You

will hear about

› The syntax of a MDX-query › How to form tuples and sets on a specific

axis › Basic functions and operators › Solution for exercise 3

SELECT NON EMPTY{([Measures].[Internet Sales Amount], [Customer].[Gender].Members)} ON AXIS(0), NON EMPTY{([Sales Territory].[Sales Territory Country].Members, [Date].[Fiscal Year].Members)} ON AXIS(1) FROM [Adventure Works]

Got questions?

More detailed information can be found here.

Thank‘s for your attention!