3

Not sure if I am doing something wrong. But in the BUILDER I defined a dimension with the "Unknown Member" field set to 'Unknown'. The facts table - based on an in memory file - has some empty values for the key that is used.

Now I expect icCube to use the 'Unknown' member for these when the schema is deployed and loaded but I get the error message:

Data table 'Changes', line '2' : The column 'priorityId' has no value in the facts table (hint: null foreign key)

(I understand the error, that is why I have the "Unknown Member" set in the dimension).

When I set the 'If Null/ Empty' field in the selected table to a value, for example 'aap' and I deploy and load, I get the error message:

Data table 'Changes', line '2' : Processing facts 'Cube.Facts', no member found for key 'aap' in dimension 'ChangePriorities' and level 'name' - fact key column(s) = 'priorityId'.

(Also, this specific situation (a member that is not present in the dimension) should have been taken care of by setting the "Unknown Member".) Am I doing something wrong here?

Arthur
  • 1,692
  • 10
  • 14

1 Answers1

3

Perhaps you missed the property 'Use Unknown Members in Facts' in Properties

icCcube snapshot 2

Hope that helps.

ic3
  • 7,917
  • 14
  • 67
  • 115
Marc Polizzi
  • 9,275
  • 3
  • 36
  • 61