[Cloud release: 2023.11.16]
[On-prem release: 2023 November 2]
[On-prem build: 23.11.21518]
A Mashup dimension is a mapping that aligns identical dimension members across multiple cubes and data connections.
Its purpose is to provide a single location for defining criteria that can be applied consistently across these different sources.
Mashup dimensions function similarly to the previous Global Dimensions feature, but they include a dedicated interface in the TARGIT client to support creating and maintaining the mappings.
Mashup dimensions are created from the User Dimensions dialog in the Tools menu:
Add dimensions from different cubes and connections to design the Mashup dimension:
Note that not all dimension members need to be present in all connections. Ideally, if not all, then at least as many as possible of the dimension members should be present and identical across the connections to get the most out of a Mashup dimension.
The Mashup dimensions can be used from the Source Data Smartpad, e.g., adding them to the Criteria bar:
Applying a filter from the Mashup dimension will now apply as a filter across all dimensions where the same key exists:
Notes:
- The mapping happens on the Key values of the dimensions, so it is important that you check that keys are of the same type and contain shared values across the mashed up dimensions.
- Only single-level dimensions are supported by mashup dimensions. Hierarchies are not supported.
- Mashup dimensions are always shared among those cubes from where they have been created.
- When you add a Mashup dimension to the criteria bar, the drop down list will show dimension members from the currently select cube. In the example above, the drop down list will show dimension members from the Country dimension in the Northwind Order cube.
Video tutorial:
Comments
I can't get any audio on this tutorial. It's working fine on others tutorials in the Targit community.
Hi Anna,
You are quite right. This video is missing Audio. I have uploaded a new version - with audio.
Thanks for making us aware of this. :-)
BR / Ole
Please sign in to leave a comment.