Context/Global context

“Context” is the designer that limits the data which you’re watching. It is located to the left of the table:

You can drag dimensions into context (the same when you do it with columns and rows).

Let’s assume we are interested in sales for “Miami”. Drag the dimension “Geography” from the “Dimensions” into “Context”. The member selector dialog will pop up:

Select “Miami” and press «OK». You will get such report:

There is an item “Geography” in the context. It means that the table is currently displaying data for one city – Miami. In the same way you can drag other dimensions into context for making the selection narrower.

“Global context” is the context which is applied to all the pages of the report:

You can revert yours changes quickly by pressing the button .

You can switch on/off the display of global context in the “Workbook” menu:

Global context has lower priority over the context of the page:  if the same hierarchy is present in the global context and  in the page context, the MDX query will take into account the page context.