BusinessObjects Board

How to handle Qaaws- Migrating from BO 3.1 to BI 4.0

other Xcelsius - Crystal Dashboard Design
#1

Hello Gurus,

Could someone please explain how to migrate Qaaws (Which are being used by Xcelsius Dashboards) from 3.1 to 4.0. Can we folow the same approach as we migrate other traditional BO objects or is there a different approach?

Thanks for your suggestions,
Bob

bob96 (BOB member since 2012-02-02)

#2

When designing the Dashboard in Xcelsius using QAAWS connection, we need to make sure we just pass the relative path in the web service URL.
The change which needs to be made is as follow:
Original Web service URL: “http :/< server name>/dswsbobje/qaawsservices/queryasservice”.
The Changed URL should be: /dswsbobje/qaawsservices/queryasservice.
Import the changed swf to new server and the data shows in Info view.

RUC :us: (BOB member since 2010-05-03)

#3

Why wouldnt you switch all QaaWS to webi BIWS connections ? Your life will become much easier, and you will never have another migration issue . Qwaas is somewhat of a dead application.

Cairmor :us: (BOB member since 2008-06-05)

#4

Hello RUC,

Thanks for the reply.

After making the changes you suggested to the Web service URL in the connections tab, I exported this to our old server (Just to see if it works). When I opened this flash file in Infoview, there was an error: 2032 (cannot access external data).

Original URL:

 http://server name/dswsbobje/qaawsservices/queryasaservice?&amp;cuid=ARkkbtBdGW1EgQfH9TfQr1I&amp;authType=secEnterprise&amp;locale=en_US&amp;timeout=60&amp;ConvertAnyType=false

Modified URL:

 /dswsbobje/qaawsservices/queryasaservice?&amp;cuid=ARkkbtBdGW1EgQfH9TfQr1I&amp;authType=secEnterprise&amp;locale=en_US&amp;timeout=60&amp;ConvertAnyType=false

Is this an expected thing? or did I do something wrong?

The same file without changes to the Web Service URL is working fine on the same old server.

Hi Cairmor,

How can we switch QaaWS to Webi BIWS? Can you elaborate please?

Thanks
Bob

bob96 (BOB member since 2012-02-02)

#5

1.create a webi
2.make a webi block that produces the same results as your QaaWS values. Create a block for each QaaWS on separate Webi reports in the same webi document.
3.right click the edge of the each webi block and choose Publish
4. In the BI Services window, which is seen after publishing, you will have a Web service address that looks like a Qwaas address
5 Use the address to set up the xcelsius file connector…just like you used to do with QaaWS

For more information, use Webi help on BI services. Its very detailed.

Cairmor :us: (BOB member since 2008-06-05)

#6

Thanks Cairmor, we have already spent a lot of time in designing these and its a huge task to create webi reports.

Hello RUC, can you comment on my question above, please? Is that the way I have to modify the Web service URL?

Thanks
Bob

bob96 (BOB member since 2012-02-02)

#7

Dont know is this helps but I use QaaWS in BOBJ 4 and my URL’s look like this.

/dswsbobje/qaawsservices/biws?WSDL=1&cuid=AcWzZZAzZ1ZpZmfIga_8h4

Mine migrated without issue.

Ozzy_BOBJ :australia: (BOB member since 2013-03-20)

#8

Hi Ozzy,

In the Data Connections tab, there are two things…1 is WSDL and the other is Web Service URL…

As per RUC’s suggestion, I changed the Web service URL but not the WSDL.

The change which needs to be made is as follow: 
Original Web service URL: "http :/< server name>/dswsbobje/qaawsservices/queryasservice". 
The Changed URL should be: /dswsbobje/qaawsservices/queryasservice.

Can you check those two things in your connection and let me know, please?

Thanks
Bob

bob96 (BOB member since 2012-02-02)

#9

You will end up converting your QaaWS to Webi BIWS someday anyway ! Ive never met BOBJ dev who thought creating webis is a huge task. But your relative link looks fine. You are getting the #2032 for another reason…if you want to know why, d/l Fiddler and use the software to discover where the bottleneck is.

Did you read the Tutorial yet for Migrating QaaWS to 4.0 ?
http://wiki.scn.sap.com/wiki/display/BOBJ/How+to+Migrate+and+Upgrade+Dashboards

There are some extra steps listed in this guide that are not normal for a simple migration due to crossing version platforms.

Cairmor :us: (BOB member since 2008-06-05)

#10

Why is it so? :shock:

bob96 (BOB member since 2012-02-02)

#11

because in 4.0 there is no reason to use QaaWS any longer.

It is a much weaker version of BIWS, not to mention…Qaaws was never migration friendly…there are many more reasons not to use it. But most importanly, It has been replaced and only exists for legacy dashboards files. No one should be using QaaWS in 4.0 +

Cairmor :us: (BOB member since 2008-06-05)