{"id":18,"date":"2010-07-20T17:14:00","date_gmt":"2010-07-20T17:14:00","guid":{"rendered":"http:\/\/www.sapbpc.sapag.co.in\/?p=18"},"modified":"2010-07-20T17:14:00","modified_gmt":"2010-07-20T17:14:00","slug":"using-javascript-in-sap-businessobjects-planning-and-consolidation-version-for-netweaver","status":"publish","type":"post","link":"https:\/\/www.sapbpc.sapag.co.in\/?p=18","title":{"rendered":"Using JavaScript in SAP BusinessObjects Planning and Consolidation, version for Netweaver"},"content":{"rendered":"

General Syntax:
The data to be converted is initially identified in the system variable %external%. JavaScript functionality can be accessed by preceding any command with the key “js:” to indicate a JavaScript command will follow next. <\/p>\n

To use JavaScript, ensure that the CONVERT_INTERNAL parameter is set in the calling Transformation file as follows:
If the transformation option Convert_Internal = NO, JavaScript can be used in the Internal column.
Example: the function js:parseInt(%internal%) placed in the internal column of the conversion sheet will return the Integer portion of the converted data. <\/p>\n

If the transformation option Convert_Internal = YES, JavaScript can be used in the External column.
Example: the function js:parseInt(%external%) placed in the external column of the conversion sheet will return the Integer portion of the incoming data. <\/p>\n

JavaScript can also be used in the FORMULA column of the Conversion sheet. The system variable “Value” is defined as the initial value of the string before processing:
js:Math.round(Value) and Value =0.60 returns the quantity “1”
js:Math.round(Value) and Value =0.50 returns the quantity “1”
js:Math.round(Value) and Value =0.49 returns the quantity “0”
js:Math.round(Value) and Value =-4.43 returns the quantity “-4”<\/p>\n

Example: <\/p>\n

\"\"<\/p>\n

Wildcards
You can use the asterisk (*) and question mark (?) wildcards in the External or Internal columns.
An asterisk (*) stands for any character, while a question mark (?) stands for any single
character. For example, if you want to reference all members, use the asterisk (*). Example: <\/p>\n

\"\"<\/p>\n

JavaScript function: parseInt()
<\/strong>This function parses an input string and returns an integer value. For example:
js:parseInt(%external%)and %external%=”10 ” returns the value 10
js:parseInt(%external%)and %external%=”10.00″ returns the value 10
js:parseInt(%external%)and %external%=”50.33″ returns the value 50
js:parseInt(%external%)and %external%=”000000010″ returns the value 10
js:parseInt(%external%)and %external%=”C000010″ returns the value “NaN”<\/p>\n

Tips and Notes:
1. Only the first number in the string is returned!
2. Leading and trailing spaces are allowed.
3. If the first character cannot be converted to a number, parseInt() returns NaN (“Not a Number”). <\/p>\n

Example: <\/p>\n

\"\"<\/p>\n

JavaScript function: if…then…else
Use the if\/then\/else statement to execute some code if the condition is true and another code if the condition is false.
See example above: js: if(isNaN(%external%)) then %external%.substring(0,6);else parseInt(%external%) . <\/p>\n

JavaScript function: toUpperCase()
This function coverts all characters in the input string into upper case characters.
Example:<\/p>\n

\"\"<\/p>\n

JavaScript function: replace
This function finds a match between a substring (or regular expression) and a string, and replaces the matched substring with a new substring.
Example:<\/p>\n

\"\"<\/p>\n

JavaScript function: split & join
This function finds a match between a substring (or regular expression) and a string, and replaces the matched substring with a new substring. <\/p>\n

Example: <\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

General Syntax:The data to be converted is initially identified in the system variable %external%. JavaScript functionality can be accessed by preceding any command with the key “js:” to indicate a JavaScript command will follow next. To use JavaScript, ensure that … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18"}],"version-history":[{"count":0,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}