Views not available as source for SF BusinessObject when database is Oracle...?

Kari Paukku — Mon, 16 Oct 2006 14:21:54 GMT

Hi,

would you kindly check this: I don't to see Oracle views in the list of possible data sources when configuring Business Objects. When using SQL Server the views are available as data sources.

There is an easy way of testing this (this is what I did)

Using the SCOTT scheme I created a view

CREATE VIEW EMP_VIEW AS SELECT * FROM SCOTT.EMP

N.B. You must grant SCOTT the rights to create a view (GRANT CREATE ANY VIEW TO SCOTT;)

Just to show the point I created an other table using
CREATE TABLE EMP_TABLE AS SELECT * FROM SCOTT.EMP;

Now if you try to set the data source for BO the EMP_TABLE is available but the EMP_VIEW is missing.

The second phase of the test was to look at SQL Server and try to configure a BO based on a SQL Server view. That worked fine (used the SFSUserPermissionInfo-view).

The Oracle database is 10G and the SF is 1.5 (released 10-10-2006).

It may be that the problem is in my environment but I'm quite sure that the views were available in the SF 1.5 version prior 10-10-2006 update.

Thanks,

Kari

StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Views not available as source for SF BusinessObject when database is Oracle...?

Views not available as source for SF BusinessObject when database is Oracle...?