SUMMARY
This issue has been classified as a defect by Strategy. The impact is limited to Strategy 9.x reports using a specific schema design. No workaround is available at this time. A solution/code fix for this issue is not available in the current releases but is being reviewed for a future Strategy release.
SYMPTOM
When running a report in Strategy Analytics Enterprise 9.4.1, the following error is seen:
Status: Initialization Failed Error: SQLEngine got an Exception from DFC: [DFCENGINE] Engine Logic: Fail to join to ancestor or descendent.
A,B,C,D,E are all attributes, A is parent of B, C is parent of B, C is parent if D, E is parent of D.
Attribute group (B, C, E) can join together because C can join with B and E separately. After C and B are joined, the key for the joined table is B, which has no relationship with E. And an exception is thrown out.
ACTION
Strategy will continue to investigate and post updates as soon as they are available. A solution/code fix for this issue is not available in the current releases but is being reviewed for a future Strategy release.
The Strategy Internal Reference Number for the issue discussed in this knowledge base article is 632206.
