Global Dimensions

Global Dimensions is a feature that makes it possible to link otherwise unrelated hierarchies. Doing so enables you to perform only one filtration in the criteria bar, this filtration will then take effect on all the hierarchies in the same Global Dimension.

You create an XML file in which you connect hierarchies in a "global dimension" element.

Prerequisite:

The hierarchies must have the same structure, i.e. same type, same amount of levels, and same content. Anexample to clarify this: if you have a time hierarchy of 'YMD' you cannot combine it with a hierarchy with a 'YQMD' level, they have to be the same. Please note:

  • To create a Global Dimension you must provide it with a unique id.
  • Hierarchies that should be linked must be included in the same "global dimension" element. You can link as many hierarchies as you wish.

There is no user interface for creating Global Dimensions, so you must create an XML file and create the "global dimension" elements you need. Please follow the steps below and take a close look at the example on the next page, this should enable you to create your own Global Dimensions.

  1. Create a folder for your XML file. This folder must be located in the 'Settings' folder on the TARGIT Server.
    Default path is: 'C:\ProgramData\TARGIT\ANTServer\Settings'.
    The folder must be named 'GlobalDimensions'.
  2. Create an XML file named 'GlobalDimensions.xml' and save it in the folder above.
    You are now ready to create Global Dimensions in the XML file.


On the next page you will find an example of an XLM file with two global dimensions elements: 'time_hierarchy" and "time_month".

Use the example and the information below to create your own Global Dimensions.

Below is an example of an XML file with two global dimensions elements: 'time_hierarchy" and "time_month":

<?xml version="1.0" encoding="utf-8"?>
<globalDimensions>
<globalDimension id="time_hierarchy">
<metadata database="DemoData" cube="Sales" dimension="Period" hierarchy="Period" />
<metadata database="CasualClothing" cube="Clothing" dimension="Posting Period" hierarchy="Hierarchy" />
</globalDimension>
<globalDimension id="time_month">
<metadata database="DemoData" cube="Sales" dimension="Period" hierarchy="Month" />
<metadata database="CasualClothing" cube="Clothing" dimension="Posting Period" hierarchy="Month" />
</globalDimension>
</globalDimensions>

The global dimension with id="time_hierarchy" in the example above links the "Period" hierarchy (in the "Period " dimension in the Sales cube) with the "Hierarchy" hierarchy (in the "Posting Period" dimension in the "CasualClothing" cube).

Likewise, the "Month" hierarchies in the "Period" and "Posting Period" dimension are linked in the global dimension with id="time_month".

 

Note: Remember that the hierarchies must have the same structure.

Was this article helpful?
1 out of 1 found this helpful

Comments

2 comments
  • It would be nice to have another interface in order to work with the global dimensions, kind of the way we work with Data Discovery in form of a sort of "drag and drop" way of connecting the different dimensions across the various cubes.

    0
  • Hi John,

    See my reply to the Topic post here: Global dimensions

    BR / Ole

    0

Please sign in to leave a comment.