Skip to Content

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):

   1

Access Visual Basic (Alt+F11), this is located in the “Developers” tab for Excel 2007:

 2

Select the “ThisWorkbook” object and add the following Visual Basic (VB) code to the right screen:

Sub showAllSheets()

Dim i As Integer

For i = 1 To Sheets.Count

Sheets(i).Visible = -1

Next i

End Sub

Your screen should look similar to this:

3

Run the script by selecting F5 or   4.

The VB code exposes the cache sheet generated when the Park-n-Go offline options were executed:

5

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:

6

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply