New Dimension not populating data on the cube

Question

Question

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.

Product version: IRIS 2020.2

$ZV: HealthShare 2020.2 [HealthShare Modules: Active Analytics:20.0.8620 + Core:20.0.8620] - IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2020.1 (Build 217_1_20418U) Tue Nov 17 2020 15:48:44 EST

Discussion (1)2

Log in or sign up to continue

score 0 · Answer 1 · 2024-01-08T10:47:01-05:00

Hi Ephraim,

It looks to me like you have defined the Region level with a source expression of "sourceRegion". The source expression will be interpreted as an ObjectScript expression to be computed for each record when you build the cube. In this case, it is being interpreted as a literal string, so the value of the level for every fact is "sourceRegion".

Do you have a property in your source class called Region or sourceRegion? Assuming your source class has a property called Region, you can select the Property option in the level details (above the Expression option), and enter Region (without quotes) there. This is equivalent to using the Expression option and entering %source.Region (again, no quotes).

If you are still having trouble with this level after trying this, please feel free to open a WRC issue to get support.