Connecting Xcelsius to BW gives error #2170 with Flash 9.0.124

[Former Member]

Hi,

I am currently trying to have Xcelsius calls a web service (query_data_view) from the BW system to retrieve data to build up charts. However, once i export my charts to swf and run it with a browser i get the error #2170. A quick look on google has BOBJ support gives the following solution: [url]http://technicalsupport.businessobjects.com/cs/forums/thread/22717.aspx[url]

It states that a crossdomain.xml file must be stored on the server (root directory) where the Web Services is hosted. I found out Flash is looking for the crossdomain.xml file located on the web server is at this address: http://usai3q75.wdf.sap.corp/ . However, that file is non existant there, and i certainly do not have access to put files on that server.

So the big question is, how do i solve this problem?

Does anyone have a solution?

Thank you,

Best regards,

Van

PS. I'm also open to other ways to connect Xcelsius and SAP BW sytems.

[Former Member]

Check out this link where it was resolved on another forum:

http://www.forumtopics.com/busobj/viewtopic.php?t=110827

Hope this helps!

Xcelsius Gurus

_______________________

http://www.everythingxcelsius.com

"Xcelsius Gurus share tips, reviews, tricks and much more!"

[former_member184494]

Hi All,

We also faced the same issue regarding the crossdomain.xml file.

Since we were only testing ... a workaround is ...

use the directions mentioned in

http://technicalsupport.businessobjects.com/cs/forums/thread/21295.aspx

where you will have to register a location...

< No Access to root directory , multiple approvals , testing , security yada yada...!!! >

The crossdomain.xml file is the permanent solution , but this workaround is less tedious in terms of working with the app server.

Raja: as for integrating with xcelsius with SAP Bi - we have used the restful BSP given by you and it works fine ... we are yet to integrate based on the query view web service.. we have integrated BI data using the restful BSP service and Excel XML maps...

Arun

[Former Member]

Hi Arun and Raja:

I have tried the RESTful bsp method, and what i had to do after getting the xml string from calling the RESTful, write it to a file and use xslt to transform it to a format (or schema) that xcelsius understands, which is the following:

<row>

<column>10$</column>

<column>20$</column>

</row>

Did you have to do the same, or did you use the returned value from the RESTful directly?

@Arun: I have tried your suggested workaround but it seems to not help.

Thanks.

Edited by: Huynh Van Du Tran on Jun 25, 2008 4:26 PM

Edited by: Huynh Van Du Tran on Jun 25, 2008 4:27 PM

[athavanraja]

thanks Arun for the update. do keep us informed, how it goes.

Raja

[athavanraja]

you have to use the URL of the service in EXCEL as XML map

Raja

[Former Member]

Hi Raja,

I tried your RESTful but seems not be able to use the 'parameters' passing.

This is the url:

http://usciq76.wdf.sap.corp:50029/sap/bc/bsp/sap/zrestful/restful.xml?infocube=0IPM_C09&query=0IPM_C...

This part: "&VAR_NAME_1=0IPM_LICNSR&VAR_VALUE_EXT_1=27001001" does nothing, i essentially get the same resulting xml with or without the parameter part above.

I've read the online help, but still cannot figure out what's wrong. Do you have any idea?

[athavanraja]

only if 0IPM_LICNSR is single value parameter type , the syntax you have used will work. if its a type range (like select option in abap) then the syntax is different which is explained in the online help link provided in the wiki

[former_member184494]

Raja,

Did the RESTful service and XML maps and it worked out fine. But there seems to be a niggling issue. When I tried it on a non unicode system looks like there is an issue with the XML formats like UTF-8,UTF-16 . If the format is ISo the BSP works fine .. otherwise it gives a XML cannot be displayed.

I tried a conversion to xstring for the XML_OUT string ... but then the HTTP-SET_CDATA accepts only a string...

Any way out ??

Arun

[athavanraja]

just change the call transformation code in the BSP to remove the encoding.

call transformation (`ID`)

options XML_HEADER = 'WITHOUT_ENCODING'

source meta = meta_data[]

output = <ltable>[]

result xml xml_out.

this will work in all systems.

Regards

Raja

[athavanraja]

Arun,

Did it help?

[former_member184494]

Raja,

It worked...

However a couple of questions :

1. The service has a URL like

http<server>:<port>......

In our development server .. this is allright... but in the production servers ... the ports are not open and access happens through a load balancing URL without specifying any Port. This is the URL specified in HTTPURLLOC table...

Is there anyway I can get that in...

Usually we go for the GET_VIRT_HOST.... function module and if there are entries in HTTPURLLOC then build the URL based on that.....

2. Is there any different setting if HTTPS is enabled... we have implemented the same in a HTTPS configured system and the initial view opens without any problems and flashes an error message saying "Enter Query/View Name"

however if we try and run the same with a query / View ... it says that the Link is not valid. I am looking into this to see if there was any mistake by the DEV team in creating th BSP in itself .. just wanted to bounce it off you...

Warm Regards,

Arun Varadarajan

[athavanraja]

1. you mean the webdispatcher, if yes, just use the webdispatcher url, it should work. are you trying the get the url dynamically?

2. it should work in HTTPS as well. "Enter Query/View Name" will happen if the url parameter for query/view name is not passed to the application

[former_member184494]

I will use the webdispatcher URL.... seems to be working fine otherwise..

As for HTTPS... should we check the HTTPS checkbox in the BSP Page ? without using the checkbox also we are getting the messages .. but wanted to check if the checkbox was mandatory....

Arun

P.S is there anyway I can use the query_view_data web service directly in xcelsius by passing such parameters...?... seem to end up getting the WSDL definition always.....

Edited by: Arun Varadarajan on Jul 13, 2008 11:44 AM

Edited by: Arun Varadarajan on Jul 13, 2008 11:45 AM

[athavanraja]

As for HTTPS... should we check the HTTPS checkbox in the BSP Page 

i have never used that, not sure whether you should check it,

about using query_view_data

are you saying that thru url parameters you want to pass values and consume the webservice?

seem to end up getting the WSDL definition always

may be you are trying to call the wsdl url along with variables? try with

sap/bc/srt/rfc/sap/query_view_data

(i have not tried this)

Edited by: Durairaj Athavan Raja on Jul 13, 2008 9:41 AM

[former_member184494]

Raja,

What I am trying to do is :

http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?sap-client=100&infocube=YUNAG_C09&query=Yf...

Here the query does not have any variables...

I am not too sure as to what to do with the ? in between.

I tried with the following URLs as well...

http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA&sap-client=100&infocube=YUNAG_C09&query=Yf...

http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA&infocube=YUNAG_C09&query=Yfcs_test_01

http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?&infocube=YUNAG_C09&query=Yfcs_test_01

no dice... I see an error which says...

<faultstring xml:lang="en">SRT: Wrong Content-Type and empty HTTP-Body received</faultstring>

- <detail>

- <ns:SystemFault xmlns:ns="http://www.sap.com/webas/710/soap/runtime/abap/fault/system/">

<Host>undefined</Host>

<Component>COREMSG</Component>

- <ChainedException>

<Exception_Name>CX_SOAP_CORE</Exception_Name>

<Exception_Text>SRT: Wrong Content-Type and empty HTTP-Body received</Exception_Text>

</ChainedException>

</ns:SystemFault>

</detail>

</soap-env:Fault>

Either I have missed a configuration step or something is wrong or I am unable to call the web service through the URL...

Arun

[athavanraja]

try with 
sap/bc/srt/rfc/sap/query_view_data

sorry about this, you cannot do this way. if you want to achive this kind (http get) then that has to be implemented in the system.

if you want the results same as ws, then you can modify the bsp i had provided and just expose the results returned by RRX_QUERY... FM

Edited by: Durairaj Athavan Raja on Jul 13, 2008 12:06 PM

[former_member184494]

Got through the SOAP_CORE error

used the following URL...

http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?wsdl&sap-client=100&sap-user=<userid>&sap-...;

but when I give

http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?wsdl&sap-client=100&sap-user=<userid>&sap-... .. still end up getting the wdsl

Arun

[Former Member]

Hi Arun,

I have read somewhere that it is not possible to use Query_view_data "as is" since it will return the values in multi-dimension, while Xcelsius can only read two dimension.. so

Have any of you tried the XMLA method? Since i guess that one will be the standard to be used..

[athavanraja]

have a request: i see that you are using query_view_data web service with xcelsius. would you mind trying the following https://wiki.sdn.sap.com/wiki/display/BI/ExposeBIQueryasRESTful+Service

instead of the standard webservice and share your experience.

Regards

Raja

[Former Member]

Hi Raja,

Thanks for the tip, i will try it out (RESTful)! But for now, i need authorization to make changes to the Virtual Host, currently i do not have the user auth to edit stuffs in sicf so i cannot have the crossdomain.xml set up yet.

Besides, do you have any idea how to use <b>XMLA</b> instead of query_view_data and the RESTful service you suggested?

[athavanraja]

not much experience with XMLA, but check out this weblog.

/people/prakash.darji/blog/2006/09/04/work-with-xmla-web-service-for-bi-data-in-external-applications

Regards

Raja

Hope by now you would have realized that by searching SDN you can find answers to almost all your SAP related questions

[athavanraja]

to place the crossdomain.xml on the WAS server root you can follow the approach explained in this thread

Regards

Raja

[Former Member]

Hi Durairaj,

Thanks for the link! I have followed it, but somehow am lost here:

In SICF transaction : in the Default servcie Tab, I Select the ZROOT BSP application, i just created. Then I re Activated the default host (right clik Activate Virutal Host)

.

I do not know what he meant by "Default service Tab". What i see after running SICF is a "Maintain Services" page with an execute button.

Edited by: Huynh Van Du Tran on Jun 16, 2008 4:47 PM

[athavanraja]

double click on the default_host service (in SICF) in the resulting pop up you can see the "default service" tab

Raja