Datatype Error Webi Report
Contents |
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. #DATATYPE error in webi report Search this topic...|Search WebIntelligence XI...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register webi change data type or Login to Post Forum Index -> Building Reports -> WebIntelligence XI Author Message
No Data To Retrieve Error In Webi Report
rao_marapatlaPrincipal MemberJoined: 06 Aug 2008Posts: 142 Posted: Thu Mar 17, 2011 7:09 amPost subject: #DATATYPE error in webi report Hi, I have data sync error in webi data in CSV and am loading to SQL server on the top of it i build universe....there is one calculation field in csv file which is XXX,when i am loading to sql server values are shwoing correct
#multivalue Error In Webi Report
(XXX= 1234) and in universe values are showing correct for that object (XXX= 1234),but when i am using same field in report i am seeing error for this object XXX= #DATATYPE.. any thoughts much appricated. Back to top Mark PForum DevoteeJoined: 03 Feb 2003Posts: 10295Location: Manchester, UK Posted: Thu Mar 17, 2011 9:10 amPost subject: Re: #DATATYPE error in webi report This typically means that there is an incorrect data type being used - #unavailable error in webi report expecting a number and getting alpha for example._________________Current version I'm using: 4.1 SP3 Next available for contract or consultancy work: October 4th 2016 ______________________________________ Note to clients: The bitterness of poor quality remains long after the sweetness of low price is forgotten Back to top rao_marapatlaPrincipal MemberJoined: 06 Aug 2008Posts: 142 Posted: Thu Mar 17, 2011 10:40 amPost subject: Re: #DATATYPE error in webi report i have checked in sourcfile there are no alphnumeric values only numeriv and decimal values. Thanks Back to top Mark PForum DevoteeJoined: 03 Feb 2003Posts: 10295Location: Manchester, UK Posted: Thu Mar 17, 2011 11:45 amPost subject: Re: #DATATYPE error in webi report What is XXX? How is it held in SQL Server? How are you pulling the data from SQL Server? With a universe or freehand/custom SQL?_________________Current version I'm using: 4.1 SP3 Next available for contract or consultancy work: October 4th 2016 ______________________________________ Note to clients: The bitterness of poor quality remains long after the sweetness of low price is forgotten Back to top JMuldersForum EnthusiastJoined: 20 Jun 2002Posts: 1253Location: San Carlos, CA Posted: Thu Mar 17, 2011 11:55 amPost subject: Re: #DATATYPE error in webi report Sometimes values from Excel are treated as text (character) even though they are numeric. Have you tried explicitly converting them to a number in the universe or report? Judy_______
ERROR Environment:WebIBO XI R3.1 SP 4 You got thi error when you are using a wrong data type . For example if your data is numerical but it is throwing char
#div/0 Error In Webi Report
or date then Business Objects will expose this error. Often it happens, when you
Refresh Error In Webi Report
mix string and number or string and date/time data types. If these data types are mixed, the function returns a multi value error in webi report string. As Date/time and number data types cannot be mixed the results is a #DATATYPE error. Solution: In Webiyou must create a variable in which you have to convert and cast the data types in http://www.forumtopics.com/busobj/viewtopic.php?p=801450&sid=f358a76a39289ac911f6ae94c3c6fce2 order to make them all homogeneous as datatype. Check also: Business Objects errors list Pubblicato da Giuseppe Quinto a 3:30 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Etichette: Errors No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Groupon TOP Countries Blog Archive ► 2015 (3) ► May (2) ► April (1) ► 2014 (19) ► November (1) ► May (2) http://businessobjectsbi4.blogspot.com/2013/04/datatype-error-in-webi.html ► March (2) ► February (5) ► January (9) ▼ 2013 (54) ► December (6) ► November (4) ► October (3) ► September (5) ► August (1) ► July (2) ► May (2) ▼ April (8) Error RFC 00101 - No server was available to proce... SAP BI 4 WebI - Connecting to a Bex Query with hie... Dependent Prompts and Input Control on SAP Busines... New Layout features in the SAP BusinessObjects Mo... #DATATYPE ERROR in WebI SAP BO Design Studio Integrated with SAP Business... SAP BusinessObjects Design Studio (a.k.a. ZEN) Error ERR_WIS_30270 ► March (10) ► February (6) ► January (7) ► 2012 (113) ► December (13) ► November (59) ► October (31) ► September (9) ► January (1) Pages Home page Labels Errors (57) SAP Business Objects BI 4 (49) SAP HANA (29) SAP BO Dashboards (28) Tools (24) CMC - Servers (20) SAP BO XI 4.0 - 4.1 Errors (17) SAP BI MOBILE (15) SAP BW BEX (10) Auditing (7) SAP BO ANALYSIS (6) SAP LUMIRA -SAP Visual Intelligence (5) Translation Manager (5) Designer (3) Information Design Tool (3) QaaWS (3) Performance and tuning (2) Performance Management (1) SAP BUSINESS OBJECTS DATA SERVICES XI.4 (1) Popular Posts SAP Business Objects
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX http://businessintelligence.ittoolbox.com/groups/technical-functional/businessobjects-dev-l/error-function-uses-invalid-data-type-5617168 Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi bluesguyAZ59 Iqbalyk Clinton Jones blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning webi report View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Business Objects The Business Objects group is a forum where peers share technical expertise, solve problems, and discuss issues related to Business Objects. Home | Invite Peers | More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create error in webi your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error: Function Uses Invalid Data Type newbouser asked Oct 31, 2014 | Replies (6) I have created a variable XXX and YY. Both are dimension Qualification and string type. Reason of creating two variables is better readability. Now I want to merge two variables with AND operator like : XXX and YY in If else condition but getting an error "and function uses invalid data type". Please let me know what I am missing. Join this group Popular White Paper On This Topic Self Service Business Intelligence 6Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... marekchladny replied Oct 31, 2014 Hi, Can you post an exact formula t
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 14:20:36 GMT by s_hv987 (squid/3.5.20)