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

The application SAP BusinessObjects Planning and Consolidation version for Netweaver (SAP BPC_NW) provides the ability to create offline copies of input schedules and reports.  These schedules and reports contain “EV” functionality that is continues to work even though the document is offline.  This is facilitated by the system converting “EV” functions into a special offline version, such as “EV_”.  For example: EV<\/strong>DES is converted into EV_<\/strong>DES in the offline Park-n-Go version.  In addition, the associated dimension data is cached into hidden sheets within the offline workbook.  <\/p>\n

These hidden sheets can be accessed using the following Visual Basic code entered into the marcro of the offline file.  The full procedure is as follows: <\/p>\n

Open Offline Park-n-Go template and note number of workbook sheets visible (in the example show there is only one sheet visible): <\/p>\n

\"1\" <\/p>\n

Access Visual Basic (Alt+F11), this is located in the “Developers” tab for Excel 2007: <\/p>\n

\"2\" <\/p>\n

Select the “ThisWorkbook” object and add the following Visual Basic (VB) code to the right screen: <\/p>\n

Sub showAllSheets()<\/em><\/strong> <\/p>\n

Dim i As Integer<\/em><\/strong> <\/p>\n

For i = 1 To Sheets.Count<\/em><\/strong> <\/p>\n

Sheets(i).Visible = -1<\/em><\/strong> <\/p>\n

Next i<\/em><\/strong> <\/p>\n

End Sub<\/em><\/strong> <\/p>\n

Your screen should look similar to this: <\/p>\n

\"3\" <\/p>\n

Run the script by selecting F5 or   \"4\". <\/p>\n

The VB code exposes the cache sheet generated when the Park-n-Go offline options were executed: <\/p>\n

\"5\" <\/p>\n

In this example: EVDRE, EVGET, EVCOM, and EVPROPS data were all cached to allow for the proper display of all EV function in this workbook. <\/p>\n

Examples of the cached data: <\/p>\n

\"6\" <\/p>\n

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

Business Planning and Consolidations (BPC) The application SAP BusinessObjects Planning and Consolidation version for Netweaver (SAP BPC_NW) provides the ability to create offline copies of input schedules and reports.  These schedules and reports contain “EV” functionality that is continues to … 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-15","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\/15","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=15"}],"version-history":[{"count":0,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=\/wp\/v2\/posts\/15\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sapbpc.sapag.co.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}