I have a report I created in webi 2.6 and when I run it, I am getting a cartesian product warning. I am using 1 table that doesn't like to the others in my universe and that is what causing the warning. Is there a way to fix the error or just suppress the warning? Thanks...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cartesian product warning
- Thread starter jaburke
- Start date
- Thread starter
- #3
My earlier post should have said that I have one table that is not LINKED to the others - I think I typed 'like' instead. Oops. So, I have five tables that are linked together and then I have this one other table that isn't linked to anything. It doesn't relate to the others directly, but I want to include it in the universe. That is where i am getting the error - I have an object created that is pointing to a field in that table. Thanks.....
You can have it in the universe, but you can't really use it them in a single data provider.
Try this. Build a context that encompasses all your joins. Then see what happens if you include an object from your "orphaned" table.
If that doesn't work, add a join in a context all by itself that simply forces a value. Something like City <> 'X'
This should force BO to take the data provider and break it into 2 queries.
Steve Krandel
Symantec
Try this. Build a context that encompasses all your joins. Then see what happens if you include an object from your "orphaned" table.
If that doesn't work, add a join in a context all by itself that simply forces a value. Something like City <> 'X'
This should force BO to take the data provider and break it into 2 queries.
Steve Krandel
Symantec
- Status
Similar threads
- Locked
- Question