At the end of Eric Schemer’s (SAP) presentation on the Analysis Roadmap at ASUG Annual Conference, one of the questions was “where are the new API’s for BusinessObjects Analysis 1.1”?
Alex Peter, SAP, explained this later in the ASUG Analysis Influence Council Annual Conference session. They are available in the Analysis Help. In Analysis, click Help, Creating Workbooks, Working with macros:
Figure 1 shows an image of the Help, and the navigation path. Eric said in his presentation that you could use these for planning sequences or predefined navigation for the consumers of your workbook.
An example follows – see sample workbook below:
Figure 2 – Sample Analysis Workbook
In Figure 2, notice that the workbook displays project before WBS (work breakdown structure). In my example, let’s say I don’t want the consumer of the workbook to have use the Analysis Display panel, so I define a button where the project (column A of workbook) is moved after WBS (column B). This is an example of “pre-defined navigation”.
First, I look at the help shown in Figure 1 and use the SAPMoveDimension macro:
“With this API method, you can define the position of a dimension in the crosstab, swap the dimension with another one or position a dimension relative to another one. “, Source: SAP
Using the help as a reference I can see the syntax:
Dim lResult As Long
lResult= Application.Run(“SAPMoveDimension”, “DS_1”, “0COUNTRY”, “AFTER”, “0CALMONTH” )
“If you you execute this command, dimension 0COUNTRY will be inserted in the crosstab to the position after dimension 0CALMONTH”
Figure 3 – Developer Tab
I copy the syntax to the clipboard and then go to the Developer -> Insert -> Button tab as shown in Figure 3.
In Figure 4, select New button
In Figure 5, I cut and paste the syntax from the Help and then change it for my data elements, ZPROJ and ZWBS as I want to move Project after WBS.
When the consumer/user of this workbook clicks Button 2 shown in Figure 6 then Project will be moved at WBS in the worksheet:
Figure 7 Project has moved after WBS
Figure 7 shows the result of the user pressing the button. This is an example of providing predefined navigation in a workbook for your user.
My take away: the new API’s are easy to use if you use the Analysis Help to copy and paste the syntax and make it relevant for your Analysis workbook.
Are you interested in learning more? Then visit the Analysis pagewhere there is help, recordings, and what’s new. Also join Alex Peter, SAP, for his ASUG Webcast on Tuesday, June 14thWhat’s New in SAP BusinessObjects Analysis 1.1 Edition for Microsoft Office? (ASUG logon required)