Business Planning and Consolidations (BPC) Tips -5 [Hidden Park-n-Go Cache]
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: EVDES is converted into EV_DES in the offline Park-n-Go version. In addition, the associated dimension data is cached into hidden sheets within the offline workbook.
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:
Open Offline Park-n-Go template and note number of workbook sheets visible (in the example show there is only one sheet visible):
Access Visual Basic (Alt+F11), this is located in the “Developers” tab for Excel 2007:
Select the “ThisWorkbook” object and add the following Visual Basic (VB) code to the right screen:
Dim i As Integer
For i = 1 To Sheets.Count
Sheets(i).Visible = -1
Your screen should look similar to this:
The VB code exposes the cache sheet generated when the Park-n-Go offline options were executed:
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.
Examples of the cached data: