on 09-10-2014 10:05 AM
Dear all,
We have converted 1 universe from UNV to UNX.After converting we are facing the context error.we have 5 context in universe but out of 5,two context is getting error.But the same is fine in UDT.
Error:
The Context"Context name" in data foundation "Universe name" contains an excluded join that generates a cartisian product error.
Please help to resolve the issue.
Thanks in advance
Regards,,
Manjunath.
Hi Every one,
One join is missed in each context ,we have identified that join and included in context.
Issue has been resolved
Thanks,
M.Manjuanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is not migration, this is conversion issue.
You have couple options :
1. Fix context in question manually in UNX universe (or fix the joint in original)
2. Continue using original UNV universe and create new UNX universe for new developments, then slowly phase out original UNV and reports based on it.
There is really no good business case for converting UNV's into UNX's as UNV's are fully supported for considerable future.
And if you do convert - you still have to manually switch all the reports or the original will still be in use by them.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Denis.
We have verified all the joins which are included in the context as in .UNV file. Even in .UNX file the joins in the Context remains same as in .UNV file. But we are getting this error only in .UNX but not in .UNV. Please advice.
Customer requires the .UNX file only, keeping in mind that SAP might retire .UNV in future.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.