BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

IBIS 2014: Limitless BI 2.0 
IBIS 2014: Limitless BI 2.0 (Opens a new window)  

General Notice: Upcoming Events: BONYMAUG: May 14, BI2014 Nice, France: May 21.

Xcelsius QAAWS blank output not clearing destination cells


 
Search this topic... | Search Xcelsius - Crystal Dashboard Design... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design  Previous TopicPrint TopicNext Topic
Author Message
banums
Senior Member
Senior Member



Joined: 20 Aug 2002

Posts: 52



PostPosted: Wed Jun 13, 2012 10:33 am 
Post subject: Xcelsius QAAWS blank output not clearing destination cells

I have a qaaws data connection in Xcelsius 2008, which is not clearing / overwriting the destination cells when the web service result set is blank

I have a menu list component tied to these cells and it is showing the previous results when the result set is blank


Can anyone please suggest a solution.


Thanks

banums
Back to top
delphine35
Forum Member
Forum Member



Joined: 05 Jun 2012

Posts: 3
Location: MONTREAL, CANADA


flag
PostPosted: Wed Jun 13, 2012 2:38 pm 
Post subject: Re: Xcelsius QAAWS blank output not clearing destination cel

You can test "Fetchedrows" in the output value of your QAAWS connexion.
Back to top
banums
Senior Member
Senior Member



Joined: 20 Aug 2002

Posts: 52



PostPosted: Wed Jun 13, 2012 4:11 pm 
Post subject: Re: Xcelsius QAAWS blank output not clearing destination cel

I see "nbLines" & "nbColumns" in output values but not "Fetchedrows"
The "nbLines" is retrurning 1 even when the result set is empty
Back to top
yourajai
Principal Member
Principal Member



Joined: 09 Mar 2011

Posts: 202


flag
PostPosted: Thu Jun 14, 2012 8:32 am 
Post subject: Re: Xcelsius QAAWS blank output not clearing destination cel

As you know, QaaWS data is dynamic, It is hard to see, while designing.

I had same kind of issue with QaaWS result set, and then i realized the spreadsheet for the QaaWS was corrupted.

How to identify this peculiar issue:

1.Use the Spreadsheet table component and see the values dynamically.

2.If your spreadsheet corrupted, then values won’t change for the subsequent query.

Delete the spreadsheet cell and recreate the part alone. It will work.
If you need any more clarifications, post it here. I may help you.
Back to top
banums
Senior Member
Senior Member



Joined: 20 Aug 2002

Posts: 52



PostPosted: Thu Jun 14, 2012 10:59 am 
Post subject: Re: Xcelsius QAAWS blank output not clearing destination cel

Hi,

I checked with the spreadsheet component, the values are changing when the Qaaws retrurns data, but the values are not changing when the Qaaws returns empty result set, the cells are still displaying the previous non-empty results

Thanks for you help
Back to top
xguru
Senior Member
Senior Member



Joined: 09 Apr 2011
ASUG Icon
Posts: 90



PostPosted: Sun Jun 17, 2012 1:42 am 
Post subject: Re: Xcelsius QAAWS blank output not clearing destination cel

Hi,
This was a bug in the old version and it's fixed. Which version of BOBJ and Xcelsius are your using. If you are BOXI 3.x platform, I would recommend to use atleast SP3 versions.

_________________
Available for Contract

BusinessObjects XI 4.0, SAP Dashboards, IDT, Webintelligence, Explorer
Back to top
bergkemp
Senior Member
Senior Member



Joined: 15 Nov 2006

Posts: 49



PostPosted: Mon Jun 25, 2012 10:10 pm 
Post subject: Re: Xcelsius QAAWS blank output not clearing destination cel

When ur not able to pass empty values. just try to use an additional component to overwrite the destinations.
else, you can create a query which has all rows as "#" or something. overwrite this on the location and handle these values using excel logic.

AND Remember.....For a Developer there is no such thing as NOT Supported, in case the Requirement is frozen.You have to do it! So try above methods and check.


Bergemp.

"I can show the way, but you have to tread the path"
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0465 seconds using 17 queries. (SQL 0.0046 Parse 0.0341 Other 0.0077)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo