Skip to Content
Former Member
Apr 23, 2010 at 11:55 PM

Problem with WebIntelligence and Universe Designer Derived Table


Hi people, i have an issue with a report in WebIntelligence that i want to build. Here it goes:

I created a derived table that brings every material that has or not any movement. The thing is that when I build the report using other information like Material Name, for example. The report filters by the coincidence between materials in the derived table and the SAP Standard table. I tried to modify the SQL query but, Oracle does not allow it.

So here are my questions:

1)Is any way to do a Left outer join in order to have any single material and do not allow WebIntelligence to do Inline views?

2)Do i have to modify the derived table? and use the standard tables?

3)Can i work with a derived table that does not have any join with the standard tables?

Thanks in advance,