Error on building a model "no member found for key ... but dimension has an "Unknown member" (icCube)
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?
Perhaps you missed the property 'Use Unknown Members in Facts' in Properties
Hope that helps.
- C++ executable builder
- Stream map over classes with Lombok SuperBuilder
- How to fix: Lombok builder() method does not seem to be recognised in IntelliJ?
- how to refresh ListView.builder flutter
- Ant Builder Build Failed eINSTANCE
- Create TermsQuery with List<String> using elasticsearch java api client
- Example of Builder Pattern in Java API?
- Can a Lombok builder be used fluently?
- Is it possible to auto complete a builder in Intellij?
- Is Lombok's builder thread safe?
- Lombok's builder with mandatory parameters
- Multiple constructors annotated with Lombok @Builder cause a problem?
- How to create a step builder in Kotlin that supports repeatable steps
- condition based lombok building of objects
- Is there a convention that objects created using the Builder pattern be immutable?
- Slack Workflow Builder url formatting
- Groovy merge 2 builder classes
- Typed builder pattern: bypassing invariants runtime
- Error: The named parameter 'child' is required, but there's no corresponding argument. Try adding the required argument
- Is there an essential difference in using of `Widget` or `WidgetBuilder` to pass widget as parameter to another widget in flutter
- Lombok @Builder How create a field with timestamp of value change?
- how generic type with a recursive type parameter along with the abstract self method allows method chaining to work properly?
- How can I enforce the first method used in builder pattern (C#)
- Can I use the builder pattern on a Java Enum
- XML parsers should not be vulnerable to XXE attacks. Best way to solve with ZERO impact?
- Jackson Xml - how to use builder
- How to Create a Incremental Array to Make a Bulk Insert?
- Fluent way (builder style) of creating a Mockito mock with method stubs
- Flutter ListView.builder creates an infinite scroll. How can I set it to stop at the end of content?
- Spring Boot Builder with abstract classes