{"id":13,"date":"2010-07-20T16:45:00","date_gmt":"2010-07-20T16:45:00","guid":{"rendered":"http:\/\/www.sapbpc.sapag.co.in\/?p=13"},"modified":"2010-07-20T16:45:00","modified_gmt":"2010-07-20T16:45:00","slug":"business-planning-and-consolidations-bpc-tips-3","status":"publish","type":"post","link":"https:\/\/www.sapbpc.sapag.co.in\/?p=13","title":{"rendered":"Business Planning and Consolidations (BPC) Tips -3"},"content":{"rendered":"
Business Planning and Consolidations (BPC)<\/a>  <\/h5>\n

The REC <\/strong>Statement provides a convenient method to create and manipulate the values of new records using Script Logic.  The basic format of the REC <\/strong>statement is as follows: <\/p>\n

            …<\/em> <\/p>\n

            *WHEN Dim1<\/em> <\/p>\n

            *IS *<\/em> <\/p>\n

            *REC(FACTOR=1, Dim2=”A”)<\/em> <\/p>\n

            *ENDWHEN<\/em> <\/p>\n

            …<\/em> <\/p>\n

NOTE: The REC <\/strong>statement requires the selection of an existing record to process, hence the mandatory inclusion of the WHEN \/ ENDWHEN statements. <\/p>\n

The new record(s) created by the REC <\/strong>statement inherits the same values of all dimensions from the original record.  Any dimension specified within the REC <\/strong>expression will override the original dimension value and will be substituted by the REC <\/strong>definition for that dimension.  In the example above, the REC <\/strong>statement inherits each record’s dimension values except <\/strong>for Dim2.  Regardless of the original record’s Dim2 value, the new record will have Dim2 set to the value “A”.   <\/p>\n

The REC <\/strong>can accept multiple dimension assignments, each dimension assignment must be separated with a comma.  Example: <\/p>\n

            …<\/em> <\/p>\n

            *REC(FACTOR=1, Dim2=”A”,Dim3=”C”,Dim4=”D”)<\/em> <\/p>\n

            …<\/em> <\/p>\n

The keyword FACTOR<\/strong> allows the definition of a numeric value that is used to determine the new record’s value. Factors are multiplied against the original record’s values.  In the example provided, a FACTOR=1 essentially keeps the original value in the new records being created.  A FACTOR=2 will double the value of the new record, and a FACTOR=0.5 will reduce the new record’s value by half.   Example: <\/p>\n

            *WHEN ….<\/em> <\/p>\n

            *IS ….<\/em> <\/p>\n

            *REC(FACTOR=.5)<\/em> <\/p>\n

            *ENDWHEN<\/em> <\/p>\n

A FACTOR<\/strong> can be positive or negative values: <\/p>\n

            …<\/em> <\/p>\n

            *REC(FACTOR=-2)<\/em> <\/p>\n

            …<\/em> <\/p>\n

A FACTOR<\/strong> can contain simple calculated values: <\/p>\n

            …<\/em> <\/p>\n

            *REC(FACTOR=3.6\/4.7)  <\/em> <\/p>\n

            …<\/em> <\/p>\n

In this case, the factor that will be applied is 3.6 divided by 4.7 or 0.765957. <\/p>\n

The keyword EXPRESSION<\/strong> may also be used to modify the REC <\/strong>generated record values. The EXPRESSION<\/strong> formula can include regular arithmetic operators, fixed values and the keyword %VALUE%<\/strong> (representing the original retrieved value). <\/p>\n

Examples: <\/p>\n

            …<\/em> <\/p>\n

            *REC(EXPRESSION=%VALUE%+1500)<\/em> <\/p>\n

            …<\/em> <\/p>\n

In this example, the value of the new record is determined by adding the value of the original record (%VALUE%<\/strong>) by a fixed amount (1500).<\/p>\n","protected":false},"excerpt":{"rendered":"

Business Planning and Consolidations (BPC)  The REC Statement provides a convenient method to create and manipulate the values of new records using Script Logic.  The basic format of the REC statement is as follows:             …             *WHEN Dim1             … 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-13","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\/13","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=13"}],"version-history":[{"count":0,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}