Problem with WebIntelligence and Universe Designer Derived Table

[Former Member]

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,

Reynaldo

[Former Member · Accepted solution]

If I understand you correctly, it sounds like you are getting an inner join where you want an outer join? You have several options:

1. You can do an outer join in the universe, or even embedded in your derived table (if that is what you are trying to do)

2. You can have a derived table that is not joined with any other tables in the Universe. But you will have to merge the dimensions in the Webi report, and then be sure to put the correct dimension(s) on the report in order to reflect the outer join you want.

I hope that helps.

[Former Member · Accepted solution]

Thanks for the answer. I created a derived table using left outer joins because i need all the data, with or without movements of materials. The thing is when i join it with a standard table it created internally a inner join.

You wrote that it is a way a to do and outer join in the universe. It is using the cardenalities? if i'm correct can you make an example because i'm new working with Webi and Universe Designer.

Thanks in Advance.

Reynaldo

[Former Member · Accepted solution]

Hi,

Double click on the join between your derive table and the standard table.

There will be two boxes below cardinalities where it is written as outer join, you can click on the check box on whihc side you are using outer join.

Regards,

Learner007

[Former Member · Accepted solution]

Yes you should be able to do it the way Learner007 said in the universe. If that doesn't work for you you may need to adjust your merged dimensions in Webi.