Skip to Content

Change BICS connection to all webi reports BI4.2 SP03

Hi All,

Can I maintain two BW entitlement systems ?

->Yes, I can.

Now I would like to make a copy of all existing reports and BICS connections and point them to the new BW system on the same BO server so that I can slowly phase out reports based on old BW server.

-> can i achieve this.

any suggestion would be helpful.

I have thought of overrides however that would only help if the source and destination is different.

I am trying to avoid manual work here.

-----------------------------------------------------------

I thought of creating a new parent folder and copy all reports to it then similarly create new parent folder in OLAP connections and copy all connection to it and modify them all to point to the new BW server.

Now if I link each copied report manually to the new connection then this might work however again this is too much manual work.

Any thoughts or suggestion?

Environment details:

BI4.2 Sp03

Standalone environment

Default tomcat

AIX6.1

Oracle 11g CMS DB

Dev server

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 21, 2017 at 06:46 PM

    you need to have dev and prod systems as making changes like that in prod is a very bad idea.
    if you have single server then only manual change is possible.

    Unless you're good with coding and can use BOE SDK to make a script that changes connection.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 28 at 07:06 PM

    Hi,

    We also got similar issue...

    We are in process of BOBJ Upgrade from 4.1 to 4.2 SP5, as part of this migration we want to change all our existing multiple BICS connections to point a single connection. We have around 300 reports which would take much time to change manually for each report and we want to avoid this manual work.

    So do we have any mass update thing like changing multiple connections to a single connection ? Need your help and inputs on this please ?

    Our Current environment: BOBJ Dev -> BOBJ Prod

    New 4.2 Environment is: BOBJ Dev - QA - Prod.

    Down the line we want to develop/changes only in Dev and promote across QA and PROD. As part of this we moved our existing BOBJ reports content from BOBJ Prod to existing BOBJ Dev 4.1 and started cleaning. In this regard, we need suggestions on how to change multiple connections to a single BICS connection.


    Thank you,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded