Business Objects Error No Data To Retrieve
Contents |
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. [Webi 4.x] "no data to retrieve" issue Search this topic...|Search WebIntelligence XI...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered no data to retrieve in query 1 webi Posts Register or Login to Post Forum Index -> Building Reports -> WebIntelligence
Suppress No Data To Retrieve Web Intelligence
XI Author Message rudoceForum MemberJoined: 13 Nov 2013Posts: 2 Posted: Wed Nov 13, 2013 7:03 amPost subject: "no data to retrieve" no data to fetch business objects issue Hello. I am facing a weird situation when i run any report either in Infoview or in Webi Rich Client. From time to time, when i run an Infoview report, or a Webi Rich Client pointing webi report no data to retrieve to the Infoview report, the system launches the message "no data to retrieve in query 1", indicating the query couldn't fetch any row of data. But if i edit the query and get into the query panel to refresh it, surprisingly it returns the correct data and, yet more, when after refreshing the query i run the report it executes correctly. So it seems that in order to fetch data the report must to be refreshed in the query panel first... which makes no sense. This behavior occurs when login for the first time, or when has passed some time since last run. Also occurs if the report has no filters (just the option "refresh on open") or if some filter is applied. The queries have been checked in the SQL Server database (source) and always retrieve data. I know i have something wrong configured, but i cannot guess what. Could you help me solve this situation? Any clue? Thank you very much in advance!!! Back to top HenkKForum AssociateJoined: 02 Mar 2004Posts: 854Location: Zwolle, The Netherlands Posted: Fri Nov 15, 2013 10:11 amPost subject: Re: "no data to retrieve" issue Welcome to Bob Is there only one query in the query or more? HenkK_________________BO 4.1.6 ~ XI, Cognos 8 BI , Microsoft BI 2005/2008/2012 , Oracle/SQL Server Back to top rudoceForum MemberJoined: 13 Nov 2013Posts: 2 Posted: Wed Nov 20, 2013 4:26 amPost subject: Re: "no data to retrieve" issue Hello HenkK, thanks for your response. I've been narrow down the issue and having a look to the queries generated by BO i saw that a filter generated in Information Design Tool, which collect in a LOV the last five years of the time dimension, does not work
AdvocacyBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)HelpCommunities TipsCommunities YouTubeBMC Social Central (BMC Only)CommunitiesFree TrialsLog inRegisterCommunities Free TrialsSupportDocumentationAbout BMCNewsLog inRegister Products Events BMC Engage CommunityAgenda & RegistrationDevelopersDeveloper CommunityDeveloper PortalPartners Partner DirectoriesTechnology Alliance Program (TAP)Solution Provider Portal (SPP)User Groups All groupsLocal User GroupsEvent CalendarCustomer ProgramsBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)Help Communities TipsCommunities YouTubeBMC Social Central (BMC Only)Search the BMC CommunitiesSearch the BMC CommunitiesCancelError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. http://www.forumtopics.com/busobj/viewtopic.php?p=971477&sid=e023c408cb85ab28b674e7190f926799 Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in BSM Dashboards and Analytics All PlacesProductsAtriumBSM Dashboards and Analytics 1 2 Previous Next 19 Replies Latest reply on Sep 25, 2014 5:48 AM by Lisa Singh No data to retrieve- Business Objects Nagesh Godale Jun 19, 2014 9:49 AM Hello Folks,After installing https://communities.bmc.com/thread/109247?tstart=0 analytics, setting up the universe, users and permissions I'm trying to view a report through infoview.The report initially shows sample data, when I click "refresh data" I get "No data to retrieve" message.I am not getting why this is happening. I copied the query from reports and tried to run at SQL management studio unfortunately I am not getting data there too.I tried to run reports from multiple user accounts as well as admin ID's but no luck.Need help. I have the same question Show 0 Likes(0) 1181Views Categories: Applications, Analytics, Dashboards, Reports Tags: none (add) boContent tagged with bo, infoview_errorContent tagged with infoview_error, analyitcsContent tagged with analyitcs, sboContent tagged with sbo This content has been marked as final. Show 19 replies 1. Re: No data to retrieve- Business Objects James Halligan Jun 19, 2014 9:52 AM (in response to Nagesh Godale) The username you use in Business Objects must exist an Remedy user account...JamesJemstar Consulting Like Show 0 Likes(0) Actions 2. Re: No data to retrieve- Business Objects Nagesh Godale Jun 19, 2014 10:01 AM (in response to James Halligan) If you are
BusinessObjects BI for SAPWhere is this place located?All Places BI Platform BusinessObjects BI for SAP 9 Replies Latest reply: Mar 18, 2013 8:03 AM by Sanket Shah http://scn.sap.com/thread/3320860 Tweet No data to retrieve from Query 1 in Webi ,BO 4.0 SP04 Sanket Shah Mar 7, 2013 7:33 AM Currently Being Moderated Hi,I am facing this http://www.infosol.com/web-intelligence-show-message-when-no-data-to-fetch/ error of "No data to retrieve from Query 1 in Webi" whenever i refresh the webi from BI launch-pad, using administrator as user-id, also it is giving no data the same error for other users , but when the first time webi is opened it has the data.I am getting this error for all the webi's The data for all the queries is there in the BI.Also I am using BO 4.0 SP04 Patch 9 Build 936 2948Views Re: No data to retrieve from no data to Query 1 in Webi ,BO 4.0 SP04 PRABAHARAN BALAKRISHNAN Mar 7, 2013 7:43 AM (in response to Sanket Shah) Currently Being Moderated Dear sanket, this problem has been coming due to Default RFC connection not refersh.Goto SPRO-->sap reference IMG-->planning and consolidate---> configuration parameter-->Global parameter-->execute--> Curse RFC_DESTINATION -->chanage--->enter default rfc connection BPC_SERVICE_USER_TEST_REAL-->saveI hope that it will solve ur issueRegards,Prabaharan B
Alert Moderator Like (0) Re: No data to retrieve from Query 1 in Webi ,BO 4.0 SP04 Sanket Shah Mar 7, 2013 7:54 AM (in response to PRABAHARAN BALAKRISHNAN) Currently Being Moderated Thanks Prabhakaran,But i am not able to find "planning and consolidate" under sap reference IMG. Alert Moderator Like (0) Re: No data to retrieve from Query 1 in Webi ,BO 4.0 SP04 PRABAHARAN BALAKRISHNAN Mar 7, 2013 8:10 AM (in response to Sanket Shah) Currently Being Moderated Hi... please use belwo linkhttp://www.forumtopics.com/busobj/viewtopic.php?p=595256http://www.forumtopics.com/busobj/viewtopic.php?p=760829http://www.forumtopics.com/busobj/viewtopic.php?p=652139&sid=614900abf67ceb9cf0f52269b14fb56ehttp://www.forumtopics.com/busobj/viewtopic.php?p=923209&sid=5c4bf8c85b065e7cdeb96a891623adfchttp://www.forumtopics.com/busobj/viewtopic.php?p=852234Regards,Prabaharan B Alert Moderator Like (0) Re: No data to retrieve from Query 1 in Webi ,BO 4.0 SP04Development COBOL & Migration Education View the Course Calendar BO Training InfoBurst Training Events Upcoming Events AZBOCUG BusinessObjects User Group Meetings IBIS 2017 InfoSol News - Newsletter Let's Speak BO Webinar Series What's New Helpdesk InfoSol Blog Breaking News Visit InfoSol at the 2016 ASUG BI + Analytics Conference - Booth #300 IBIS 2017: Save the Date Visit InfoSol at the Mastering Business Analytics with SAP Solutions Conference in Australia Webinar: Creative Linking in Web Intelligence Regional BO User Group Meetings Are Coming Up InfoSol UK Labs Launches New Dashboard Add-Ons Site InfoSol Supports the New ASUG GBN “Mastering BusinessObjects” Mini-Series InfoSol’s 2016 Best Dashboard Awards Open For Submissions Home / Tech Tip / Web Intelligence - Show Message When "No Data to Fetch" Web Intelligence - Show Message When "No Data to Fetch" ckruger June 16, 2008 Tech Tip, Web Intelligence Tech Tip Leave a comment 3,523 Views Related Articles Webinar: WebI 4.1 SP06 Free-Hand SQL Queries, New Input Controls, and More September 18, 2015 Let’s Speak BO Webinar: Charting Data in Web Intelligence 4.1 - July 28th - 10AM PT/1PM ET July 9, 2015 Display Forecast Values in Gray in Xcelsius November 14, 2012 How to Show a friendly message when "No Data to Fetch" When your data provider(s) return no data, the document looks pretty ugly. It will typically show column headers without any content, zero totals, and some formulas may even display embarrassing error messages. So let's use conditional blocks (see "Get rid of the noise" tech tip) to make this look a little better. First of all, we need a variable that will tell us when the data provider returns no rows. Let's call it "NumRows," it will yield the number of rows returned by a data provider. This is what it might look like: =NumberOfRows(DataProvider(< Order Date >)). Then define a block that will be displayed when there is no data in the document. We chose here to display the in put to the prompt, but you are free to put anything you want. You may wish to position this block in the same position as your results, again this is up to you. Finally, make the blocks conditional. Your block containing data should be displayed only when NumRows is greater than zero: The message displays when it is zero (for example, a misspelled value as a response to a prompt). tech tip 2008-06-16 ckruger Share tweet Tags tech tip About ckruger Previous Crystal Reports - Selecting all Values in a Dynamic Prompt List Next Web Intelligence XI R2- Modifying Color Palettes Check Also Usin