BusinessObjects Board

How can I use the Activity univers with Oracle data base?

server administration XI Server Discussion
#1

Hello,

I am using BO XI3.1 with Tomcat and Oracle data base.

I want to use the Activity Univers, So I create my new data base and redirect my old connexion for the audit data base from the my sql data base to the Oracle data base.
The problem I am facing now is when I refresh the structure of the univers I lose all joins of the derived tables and also the syntaxe is not correct for many objects in univers (for oracle syntax).

Could you please help Me.

Thnaks a lot. :wink:

Sam

samouber (BOB member since 2007-11-24)

#2

Hi Sam,
There are 5 database specific Activity universes in the samples area.
If your backend is Oracle then you need to use the Activity universe placed under

D:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Samples\universe\oracle

Export the new Activity universe(oracle based) to Repo and refresh the reports.
Please refer to this Post1 and Post2

Thanks
-Satish

forgotUN (BOB member since 2006-12-13)

#3

Thanks a lot, :lol:

I exported the univers and now it is working fine.

thanks a lot for your help :+1:
Sam.

samouber (BOB member since 2007-11-24)