Multi-environment Dashboards

[vincent_pisano]

Hi SCN people.

I'm managing a group of developers of dashboards and related Web Services, based on latest istance(s) of Report(s).

The developers group works in Develop environment with .xlf dashboards, Qaaws Services and source web-i reports (used to generate the qaaws).

At the end of the develop task, I promote the objects (.xlf or .swf, report and qaaws) in the Production environment.

Here's the problem: The Qaaws promoted in the Production environment is pointing to the develop environment, i.e. it has as source the last istance of the original report present in the develop environment. The target, in Production environment, is to use the last istance of the report located in Production environment.

The only solution I see is to regenerate the QaaWs service,  modifying the web-i report present in Production environment, and change the connection parameters of the xlf dashboard, but: The developers group  can't make changes on Production environment (public documents, nor Qaaws).

The QaaWs client doesn't work with .unx universes, and not allow changes to this kind of Qaaws (based on a web-i report).

Is there another way to solve this problem?

Thanks in advance

[DayaJha · Accepted solution]

Hi Vincent,

You can use Relative Path instead of the absolute path. When designing the Dashboard using QAAWS connection, we need to make sure we just pass the relative path in the web service URL.

(a) 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.

Make sure that you do not change the WSDL url.

Please refer the KBA also.

1541041 - How to get QAAWS connection based Xcelsius file (.xlf) point to the new server after migrate QAAWS
https://service.sap.com/sap/support/notes/1541041

1288566 - Migration of Xcelsius dashboard based on QAAWS.
https://service.sap.com/sap/support/notes/1288566

and You can also use CELogon Token as well please refer the below link

Retrieve current system in Xcelsius from InfoView via the CELogonToken and pass parameters
http://just-bi.nl/retrieve-current-system-in-xcelsius-from-infoview-via-the-celogontoken-and-pass-pa...

Thanks,
Daya

[vincent_pisano · Accepted solution]

Hi, Daya,

thanks for quick answer.

I can't use a relative path, because the qaaws is not generated by the "Query as Web Service Designer" (it's not able to create qaaws from .unx universes), but it's generated from a table of a web-I document (modify document->select a table of a report->publish as web service).

Also I can't change it, after generated.

I have seen the note https://service.sap.com/sap/support/notes/1541041 but it's not useful for me: it talks about Xcelsius 2008 under BO XI 3.1, where there was only .unv universes

May be there's another way to manage the qaaws objects (with .unx universes), or modify the WDSL link, but I don't know how.

[Former Member · Accepted solution]

Hi Vincent,

As Daya has suggested, the only way is to use relative URL, with the help of which the dashboard would automatically get data from the same environment from where it is being viewed.

It is not necessary to make any modifications in the QAAWS or the BI web services. Only change required is in the dashboard, which is, to change the Web service URL from absolute to relative using Data Manager. Once that is done, simply promote the dashboard along with the necessary dependencies (BI web service, WEBI report, Universe, Universe connection) from the development to production environment. After successful migration, the dashboard would get data from the production environment, when viewed in this environment. You only need to make sure that the latest instance of the WEBI report is present if you intend to get data from latest instance through the BIWS.

Hope this helps.

Regards,

Niraj

[vincent_pisano · Accepted solution]

Hi, Niraj

I think your solution is ideal! but forgive my ignorance: what's the "data manager"? is it a client tool? or a function of dashboard / rich client / other?

thanks,

Vincenzo

[vincent_pisano · Accepted solution]

Excuse me, Niraj

I found Data Manager (changing Dashboard language on English): Clicking "Manage Connections" I obtain the "Data Manager" Panel.

But here's another problem:

1st attempt:

I try to change the imported WDSL Url from:

http://bo-as-svil.lispa.local:8080/dswsbobje/qaawsservices/biws?WSDL=1&cuid=FkDZ2VSfYw4A2mAAAECZoNwu...

to

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

All parameters of panel became blank and selecting "Import" I obtain a dialog error: "Unable to load URL"

2nd attempt:

I don't change the imported WDSL Url, but I change only the Web Service URL, from:

http://bo-as-svil.lispa.local:8080/dswsbobje/qaawsservices/queryasaservice/biws?cuid=FkDZ2VSfYw4A2mA...

to

/dswsbobje/qaawsservices/queryasaservice/biws?cuid=FkDZ2VSfYw4A2mAAAECZoNwuAFBWmEWb&authType=secEnte...

I run in Preview and obtain a Flash Error as follows:

An error has occurred.

For more information, contact the file creator or your system administrator.

Error: Error #2032

Connection Type: Web Service

What can I do?

[former_member646011 · Accepted solution]

Hi, Vincenzo.

Did you try to publish the .xlf with changes you made at 2nd attempt ( /dswsbobje/qaawsservice ...) and run it from the browser on both environments ?

Claudio

[Former Member · Accepted solution]

Hi Vincent,

You have to just make changes in Web Service URL as-

And after this you will not be able to generate swf in preview mode as this relative url means it chceks the ;local host of the environment you are in.

So you have to publish this to browser and from there it will be pointed to your env in which you would be viewing it.

Hope this explains!.

Regards,

Rohini Haksar

[vincent_pisano · Accepted solution]

Yes,Rohini, you explain right, and I already applied your method (is my 2nd Attempt).

Ok for error in preview mode, but I don't understand why when I cut the webservice string "http://bo-as-svil.lispa.local:8080/"

leaving the relative url "/dswsbobje/......"

The dashboard .xlf object falls in error. I made another dashboard with same method.

When I export the dashboard with these strings on the connection, I obtain:dashbord

Here's the full strings:

WDSL: http://bo-as1-prod.lispa.local:8080/dswsbobje/qaawsservices/biws?WSDL=1&cuid=FmLi3VSQSQEAVD4AAEBp4w4...

Web service URL: http://bo-as1-prod.lispa.local:8080/dswsbobje/qaawsservices/queryasaservice/biws?cuid=FmLi3VSQSQEAVD...

So, I change the Web service URL to:

/dswsbobje/qaawsservices/queryasaservice/biws?cuid=FmLi3VSQSQEAVD4AAEBp4w4JABshpOAD&authType=secEnterprise&locale=en_US&timeout=60&ConvertAnyType=true

as you suggested, I save the .xlf on the same repository ( where I previously picked), replacing the previous (right running) version. When I retrieve the updated .xlf this is the result:

What's my error?

Vincent

[former_member646011 · Accepted solution]

Hi Vincent. This is a Flashplayer problem: must update to 16.0.0.305 to work with BI 4.0.

Update it from the Control Panel -> FlashPlayer 32 ->Advanced-> check now.

Hoping you solve

Claudio

[Former Member · Accepted solution]

Hi Vincent,

I believe that for connecting to QAAWS you have added a "Web Service connection"?

Please make sure that you use "Web service Query (Query as a web service)" connection type for QAAWS.

Regards,

Niraj

[vincent_pisano · Accepted solution]

Yes, thanks Niraj Bhise! I used "Web service Query (Query as a web service)". But now I've just solved updating FlashPlayer, as Claudio suggested, and now runs.

Vincent

[vincent_pisano · Accepted solution]

Thanks Claudio! You're right!

It's incredible: updating FlashPlayer to the actual release, the "relative" web service runs ok, now I see the data with no errors! If I use the absolute Web Services (generated by the original WSDL) there was no need to update it.

Ok. The solution to avoid this error is:

Update Flashplayer 32 for Internet Explorer (Active X), Chrome (PPAPI) and Firefox (NPAPI) and the error doesn't occur. The release must be 16.0.0.305

Thanks. Claudio!

Vincent

[Former Member · Accepted solution]

Hi Claudio,

I have developed few dashboards in SAP BO 4.1 by using QAAWS as Data source. These dashboards are working fine when moved from Dev to Test env. through promotion management in the form of BIAR file. I have made all the Web service URLs as relative, and its working fine.

However, When trying to do the same and moving it to Client environment, It throws 'Failure' in promotion management, saying 'Java error'.

"java.lang.noclassdeffounderror:org/apache/xmlbeans/xmlobject"

below is the screen shot of the error:

Please help !

Thanks in advance.

Sujay M

[former_member646011 · Accepted solution]

Hi,  mr Sangiai

The error you mentionned, I see, is an LCM error (from the promotion management). I don't know why does it occur. Often, during Promotion jobs similar errors occurs. After I try to restart services, change parameter on CMC or restart the entire SIA, unsuccesfully, I change server where launch the promotion jobs. I.E: If I get an unrecoverable error launching a Promotion job from the Development BI4 Server, I try to create and launch the same job in the Production BI4 Server and yhe error often doesn't occur. It's a workaround, but after I surely create a message to the SAP Support.

Hoping to help you!

Claudio