Access table directly from database in BO 4.0 WebI Report without using Universe

[Former Member]

Can i use the table avilable in database directly to make BO 4.0 WebI Report without create any universe. 

I realy appeiciate your help.

Thank you in advance.

[Former Member · Accepted solution]

Hi Tridal,

which environment table you want to use in BI 4.0 to generate webi report.

You can create webi report using SAP BW (Bex query) without creating the universe.

[Former Member · Accepted solution]

Hi Ravi,

But, I am using oracle database.

I can not use BEX query for oracle database.

so, is there any way to access table directly in WebI Report without using universe ?

[Former Member · Accepted solution]

Hi Tridal,

Its not possible to access tables directly in webi report without creating universe using oracle database.

Should create universe for non-sap data sources.

[former_member184594]

You need to create a universe for Relational SQL databases. Universe is a must. The reason you create universe is for the end users. WebI is designed for end users to create their own reports. It is a self service reporting tool. In order to do that, you need universe which allows users to query database using SQL without knowing SQL language.

If you don't want to create a universe for reporting then you can use Crystal Reports instead of WebI