Skip to Content
Author's profile photo Former Member

Grouping and Linking Dimensions in Analysis for Office

A cool new feature that is offered by Analysis for Office versions 2.4 and above is the ‘Combine’ functionality. You use several data sources in a workbook and any action performed on a dimension affects the same dimension in other data sources in the same way. It allows you to stick/link two crosstabs together so that they look and behave as one single crosstab.
On performing ‘Combine’, the crosstab from which you trigger the grouping is defined as master and the other one is servant crosstab.

Two functionalities that include Combine are:
1. Link/ Synchronize dimension member
2. Group Crosstabs

Link Dimension

The linked dimensions behave simultaneously, especially with regards to filters, hierarchy navigation and drilldown.
Let us take up a scenario where a dimension “Region” is merged between two data sources.

For example, you want to have the above dimension to be filtered by the same member (Region) or have the same hierarchy drill operation.
Select a dimension in the crosstab.
• Choose Combine –> Link Dimension –> Region

• Filter Region on R_01

• The result of linking dimension looks like below

On the Analysis tab in the design panel, you can recognize linked dimensions by an icon that is displayed next to the dimension name.

Group Dimensions

Grouping allows sharing axis from one master crosstab to several dependent crosstabs. Crosstabs will be rendered next to each other, having only one dimension block as below.

This is achieved by following,
Choose Combine –> Group Crosstab –> <Crosstab 3>

Once done,
Grouped cross-tabs use master attributes to drive grouped cross-tabs which is “Region” in the above scenario.


The major difference between linking and grouping is that grouping will have only one dimension block, whereas this is not the case for linking. In linking process, the slave cross tab will be moved adjacent to the master crosstab.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for the nice write up.  I have run into instances where I've linked dimensions, but then after  saving and reopening the file, the links will not be there anymore.  Seems to happen if I am not careful about refreshing the reports before saving the file after reopening.  Have you experienced this?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Matthew,


      Sorry about such delayed response.Grouping and linking are retained on saving and re-opening. No such issues so far.

      Author's profile photo Sethu Balaram Chowdary Deveneni
      Sethu Balaram Chowdary Deveneni

      Hi Soujanya,

      Can we do addition of Dimensions from Query2 to the Cross tab created on qUERY 1 and Query 2 here is  the example , Is it possible to get the Supplying Vendor also along with Purchasing Document,Notification in the final Group Crosstab.

      Author's profile photo Juan pablo Montero de Blas
      Juan pablo Montero de Blas

      Hi all,


      Anyone know whether is it possible to group crosstabs of queries that contains a structure in rows?


      I'm facing some problems with those cases in which queries with structures are involved.


      I'm using Analysis for Microsoft Office 2.6 SP3 P0.


      Thanks in advance and regards!



      Author's profile photo Dehua Liu
      Dehua Liu

      Hi all,

      I have 2 querys with the same dimension in columns but different structure in rows.

      I'm trying to link the dimension in columns and seems not working properly. Is possible what I'm trying to do?

      Thanks in advance and best regards.