WebI report returns incorrect data...
I have created an OLAP Universe on top of the BEx query and no issues with the Universe. However when I build the webi query on top of the universe, it's returning incorrect data. Looks like it's doing cartesian join.
For example I created a BEx query on the following fields...
. Course Code
. Course Comp Date
. Course Taken By
For a given course BEx query returning the data correct when run it via BEx analyzer. However when I try to reproduce the same query it's returning course code data for all the dates and for all people.
It's kind of cartesian join between "course taken by" and "Course comp date".
I would greatly appreciate any help. And also detailed information L00 and L01 stuff also would be appreciated.