Dynamics Community Forum Thread Details

Adding Dimension Members to Facts

I've come across a situation and would like to know whether this is by design, or a change in the design and implementation is planned.

I'm trying to create facts for reporting headcount by region and gender. I've created the following Dimensions and Dimension Members:

Gender
- Male
- Female
Region
- APAC
- EMEA

I've followed the instructions in the documentation. The first fact is ok - I've created the following:

Fact: EMEA Male Headcount 2023
Dimension members:
- Dimension Link called 'Region - EMEA' where I've selected the 'EMEA' dimension member.
- Dimension Link called 'Gender - Male' where I've selected the 'Male' dimension member.

The problem arises when I'm creating the second fact that references the same dimension member. In this case, I'm trying to create the following:

Fact: APAC Male Headcount 2023
Dimension members:
- Dimension Link called 'Region - APAC' where I've selected the 'APAC' dimension member.
- For the gender - the system doesn't allow me to select the existing 'Gender - Male' Dimension Link, and it doesn't allow me to create a new Dimension Link with the same name. So, I'm forced to create a Dimension Link with a different name.

Similarly, to create a fact for EMEA Female Headcount 2023:

Fact: EMEA Female Headcount 2023
Dimension members:
- Dimension Link called 'Gender - Female' where I've selected the 'Female' dimension member.
- For the region - the system doesn't allow me to select the existing 'Region - EMEA', and it doesn't allow me to create a new Dimension Link with the same name. So, I'm forced to create a Dimension Link with a different name.

It would be ideal to link one Dimension Member to multiple Dimension Links. Otherwise given the current structure, a new Dimension Link has to be created for every single instance where a Dimension Member is used (as below).