#format Error In Business Objects
Contents |
SAP BusinessObjects Web IntelligenceWhere is this place located?All Places SAP BusinessObjects Web Intelligence 11 Replies Latest reply: Mar 22, 2011 3:22 PM by Praveen Kumar Tweet Date Format
Datasync Error In Business Objects
in Webi Reports - Error Praveen Kumar Nov 17, 2010 8:10 AM #multivalue error in business objects Currently Being Moderated Hi , I am using a date dimension in my webI report, but the
Computation Error In Business Objects
dimension value is not populating correctly, it shows some constant value for all fileds. I checked the format of the dimension in the universe. It is in perfect incompatible error in business objects format as date.can anyone guide me on this.Thanks Praveen 5974Views Re: Date Format in Webi Reports - Error Efstratios Karaivazoglou Nov 17, 2010 8:19 AM (in response to Praveen Kumar) Currently Being Moderated WHat kind of data source are you accessing?Which version of BOBJ do you use?Regards,Stratos Alert Moderator Like (0) Re: Date Format in Webi context error in business objects Reports - Error Suresh Babu Aluri Nov 17, 2010 8:36 AM (in response to Praveen Kumar) Currently Being Moderated Hi,Try the following ways1.If you think there is no default in Business objects the try to check out its corresponding data base table colum value and compare its values to BO report column values.2. Check out if any formulas used for that date object at report level.3. Goto Object properties and set your date format and check out.Cheers,Suresh Aluri. Alert Moderator Like (0) Re: Date Format in Webi Reports - Error Praveen Kumar Nov 17, 2010 11:22 AM (in response to Suresh Babu Aluri) Currently Being Moderated Hi , I am creating a webi report <-universe- Business Intelligence Jump to: navigation, search Contents 1 Some Issues with Using Dates in Prompt Responses: 2 How BusinessObject Treats the Dates You Enter in a Prompt: 3 Formulas that work to Resolve the Issues with Date Prompt Responses: 4 This is all way too cumbersome... [edit] Some Issues with Using Dates in Prompt Responses: When sbo0001 error in business objects building a Business Objects application, it is often desirable to incorporate a User-provided date (prompt response) as an element within either a title or formula. Typically, in regards to titles, what the application builder and/or user finds is that they are limited to prompt-response date expressions that look like either 7/1/2008 or 7/1/2008 12:00:00 AM; and that the expression will https://scn.sap.com/thread/1831604 appear in one format when you have just refreshed the query, and another one if you have just opened a previously refreshed/saved version. In none of these several cases are you able to see a date that looks like – July 1, 2008. And, as far as using Prompt response dates in formulas - i.e., If((UserResponse ([Rev/Exp Jnl's];" 3. Start Date (e.g. 07/1/2007):")>[PG Start Date];… - well…when was the last time you even tried. After all, http://webservices.itcs.umich.edu/mediawiki/Business%20Intelligence/index.php/Dealing_with_Time_Stamps_on_Dates_in_Business_Objects who has time to figure out how to resolve invalid data type error messages. After you finish reading the paragraphs below you will understand why date responses work the way they do; more importantly, you will also understand what you can do to make these date responses work they way you want them to, and you will even find a formula model that you can adapt for your own repeated use in the future. [edit] How BusinessObject Treats the Dates You Enter in a Prompt: Firstly, you need to understand that all of your prompt responses are used within query criteria in terms of what the responses indeed represent. So, if you respond to a prompt for a start date, your response date will be the criteria date against which all queried transactions will be measured against. HOWEVER, the actual prompted date response that you provided is saved within the application as a text string element. So, when you refer to the prompt response itself within the reporting application (as opposed to within the data provider query criteria), all the application “sees” is a batch of alpha-numeric characters. While BusinessObjects can express a functional date in a number of ways, it can only format a text string’s font. Similarly, a formula comparing one value to another requires that all value elements be expressed in t 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.All Places > CA PPM > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.AnsweredAssumed AnsweredWrong date https://communities.ca.com/thread/108142299 format while running WebI report from ClarityQuestion asked by GB_Pawel_Krystosiak on Jan 23, 2014Latest reply on Jul 2, 2014 by Swathi_Excers Like • Show 0 Likes0 Comment • 10 Dear All, I have a custom WEBI report, which I deployed and configured to run from within Clarity. It has two parametes of the DATE type. When running, I always set them to: param_start = 1st of April 2013, param_finish = 31st business objects of March 2014 (always through the date picker - to avoid the formatting issues). When I try to run it with the Clarity user Locale set to English(United Kingdom) it returns RPT-0007: Specified report did not execute properly. From CMC, History reveals the error: The date for the prompt 'param_finish' is invalid. (WIS 10706) Then, when I switch the user locale to English(United States) and re-run it - it executes fine! error in business Through CMC i can see that Clarity has passed date parameters to Business Objects differently for the two cases: 1) for English(United Kingdom), they were: 01/04/2013;31/03/2014 2) for English(United States), they were: 4/1/2013;3/31/2014 So, it seems like Clarity sends the same parameters differently for users with different Locale settings (by the way, browser settings have nothing to do with it - I double checked that). It is just Business Objects, which is not ready to get parameters in different date formats than US. All Clarity users in my company have their locale set to English(United Kingdom). I tried to play with different BO server settings (including Windows Regional settings, through CMC properties, Universe settings, WEBI document settings) but it only resulted in how the date values were displayed in the report itself, NOT what the expected date parameters format was. Does anybody know how to deal with it? I would be extremely grateful! Thanks, Pawel No one else has this questionMark as assumed answeredOutcomesVisibility: CA PPM4604 ViewsLast modified on Jan 23, 2014 1:39 PMTags:clarity_business_objectsContent tagged with clarity_business_objectsThis content has been marked as final. Show 10 comments10 RepliesNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website AddressSuman Pramanik Jan 23, 2014 4:59 PMMark CorrectCorrect Answer Hi Pawel, One thing to overcome thesRciras0546 Error Business Objects
Frm0008 Error Business Objects