New Dimension not populating data on the cube

Hi Community,

I hope this message finds you well. I am reaching out because I have encountered an issue with a new dimension I created, named "Region," and I could use your assistance in resolving it.

The problem is that when I open the cube analyzer, the "Region" dimension does not populate data as expected. Instead, it merely displays the text "sourceRegion," which I specified as an expression in the architect. 

To provide a bit more context, my intention in creating this dimension was to incorporate data from the Health care facility relational table into the cube. However, it seems that something may be amiss, as the data is not appearing as intended.

I wonder if there might be a step or configuration that I overlooked during the creation of this dimension. I used the expression "sourceRegion" in the architect, but it appears to not be pulling the data from the relational table as expected.

If you could spare a moment to review the setup and provide any insights or guidance on where I might have gone wrong, I would greatly appreciate it. I am not entirely sure if I missed a crucial step or if there is a specific configuration that needs adjustment.

Thank you in advance for your time and assistance. I look forward to your guidance on resolving this issue.