Skip to Content
0

How to change a BOBJ report's OLAP Connection from BWQ to BWT

Oct 12, 2016 at 09:32 PM

120

avatar image

Hi All,

We have two sources BWQ and BWT for a QA BOBJ System OQ2.

We have created two OLAP Connections in OQ2: BWQ_OLAP and BWT_OLAP.

We have currently the "Trial Balance Report" under the "Reporting" Folder, pointed to BWQ_OLAP connection, and running successfully.

We would like to run this report at the same time against BWT_OLAP connection.

So, we have created a new folder "Reporting2" and copied the "Trial Balance Report' from "Reporting" folder into the new folder. The only change that we need to do now for this new report is to point it to the 'BWT_OLAP' connection.

Thanks for the help in advance,

- SP

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Rajendra Dasari Oct 13, 2016 at 11:43 AM
0

hi Shashi

You need to ask your developer to create report for both BICS(OLAP) connections and promote it to OQ2. That way you can execute the report in your OQ2 to pull data from BWQ or BWT backend BW applications.

Share
10 |10000 characters needed characters left characters exceeded
Abhi K Oct 13, 2016 at 01:57 AM
0

hi Shashi,

Please have a look on the below;

https://archive.sap.com/discussions/thread/3394612

Share
10 |10000 characters needed characters left characters exceeded
Rajendra Dasari Oct 13, 2016 at 11:41 AM
0

You need to ask your developer to build the report with both the BICS(OLAP) connections. Then you can execute the report in OQ2 with both BWQ_OLAP or BWT_OLAP to pull data from your backend BW application

Share
10 |10000 characters needed characters left characters exceeded
Shashi Paleti Oct 13, 2016 at 02:29 PM
0

Hi Rajendra, Abhi,

Thanks for your suggestions.

Looks like there is no simple alternative than rebuilding the report against the new OLAP connection. I will let you know once we tested this out.

Best Wishes,

-Shashi

Share
10 |10000 characters needed characters left characters exceeded
Shashi Paleti Oct 13, 2016 at 02:30 PM
0

Hi Raj,

Is it the same case with the Crystal Report or Analysis for Office Report?

I think we can change the source for a Crystal Report or Analysis for Office, easily.

- Shashi

Share
10 |10000 characters needed characters left characters exceeded
Rajendra Dasari Oct 14, 2016 at 11:34 AM
0

Hi Shashi,

The other work around is, you have to keep BICS connection name(BWQ_OLAP) as it is but you can point the backend BW connection to BWT and you can test over there. Just make sure which system it connects to and revert it after testing.

That would be my best suggestion without much hurdles or double work.

Thanks

Raj.

Share
10 |10000 characters needed characters left characters exceeded
Loic DE L'EPREVIER
Jan 19, 2017 at 10:48 AM
0

Hi,

Question is already 3 months old, but I thought it would be good to let you know how to do it, in case other people are interested.

  • Open Central Management Console
  • Browse in Folders to find Analysis for OLAP Workspace you want to modify.
  • Select context menu item "Connections" (see below)

  • Click on link "Replace Connection"
  • You can execute your change source and save it.

Regards,
Loic
Analysis edition for OLAP development team


Share
10 |10000 characters needed characters left characters exceeded