cancel
Showing results for 
Search instead for 
Did you mean: 

Webservice For XCelsius returning only zero values?

Former Member
0 Kudos

Hi,

I followed the manual "How to Use Business Objects Planning and Consolidation (Version for SAPNetWeaver) Data in Xcelsius".

But it seems the webservice only returns zero values. Seems more people have this problem in the forum, but I didnt find any solution yet.

Data is definetly in the cube and can be displayed both with BOPC Web Reporting and BOPC Excel input schedules.

The web service seems to be running at the location I am using, bc. it will inform me if I pass a Application name that doesn't exist in the Application as argument.

I tried the following URLs in XCelsius as data source.

http://thecomputer.de/OSoft/App/XcelsiusService/QueryResults.asmx/Results?AppSet=MyAppset&App=MyApp&showRowHeaders=true&showColumnHeaders=true&Query=MyRange:IBS_Time:2002,2003,2004,2009,2010,2011|IBS_Entities:73,74,75,1,2,3

as well as the one following that should overwrite the "current view":

http://thecomputer.de/OSoft/App/XcelsiusService/QueryResults.asmx/Results?AppSet=MyAppset&App=MyApp&showRowHeaders=true&showColumnHeaders=true&Query=MyRange:IBS_Time:2002,2003,2004,2009,2010,2011|IBS_Entities:73,74,75,1,2,3|IBS_ACCT:None|IBS_Category:R|IBS_Status:Extern

If I log on to bpc web, paste the URLs in the browser to check the web service, it displays some xml, including the passed row and column members, but only 0-values for data.

If I continue to follow the manual, upluad .swf and create a web page in BOPC Web, I also get only zero values in the displayed Xcelsius dashboard.

Is there something wrong with the URLs I am using?

What is the meaning of the "Range-parameter" - is it just the name used in the XCelsius xml data connection or does it play a more important role? (since I am using 6x6 members as data just as in the how-to-example, I only changed dimension names, ws-address and member names...)

Thanks for your help!

Edited by: Florian Pitschi on Sep 10, 2010 11:04 AM

Edited by: Florian Pitschi on Sep 10, 2010 11:05 AM

Edited by: Florian Pitschi on Sep 10, 2010 11:06 AM

Edited by: Florian Pitschi on Sep 10, 2010 11:07 AM

Accepted Solutions (1)

Accepted Solutions (1)

esjewett
Active Contributor
0 Kudos

Florian,

I believe (not sure, but I'm remembering this) that you need to query for at least one value for every dimension in your application. Are you doing this? Specifically, are there more dimensions in your application than the following?

IBS_Time

IBS_Entities

IBS_ACCT

IBS_Category

IBS_Status

Also, is "None" a valid member of IBS_ACCT? If you have not already done this, I recommend you also double-check capitalization and spelling on all dimensions and members.

Ethan

Answers (1)

Answers (1)

Former Member
0 Kudos

Yes,

"None" is a member of the IBS_ACCT dimension, and the other dimensions are all that are used for this Application and I assign a value to each of them in the 2nd version of the URL (the howto says members are taken from the current view if not specified.).

For testing: If I call the webservice via browser (not embedd in xcelsius swf) just using the URLs (see above) and specify a member for each dimension, the result values should be returned in xml format and displayed in the browser, right?

Do I need to add something in addtion for the measure? e.g. |MEASURES:periodic ?

esjewett
Active Contributor
0 Kudos

Hi Florian,

I'm a bit stumped. I don't think that your method of debugging using just the URL will work, because there is no authentication - Xcelsius should be sending something that identifies you (I think a logon ticket of some sort). It is probably in the headers of the request that you took the URL from, so you may want to look there.

But it seems like your Xcelsius should work. Maybe it's upset at your for not calling it "SAP Crystal Dashboard Design" or "SAP BusinessObjects Dashboard Design".

You might try specifying a measure, but I'm not sure if that will help. Maybe someone else can chime in.

Ethan