Ramp-up Experience: SAP BusinessObjects Analysis, MS Edition for Office 1.1 New API’s

[TammyPowlas]

At the end of Eric Schemer’s (SAP) presentation on the tammy.powlas3/blog/2011/05/23/latest-news-and-roadmap-for-the-sap-business-objects-analysis-solutions-reporting-from-asug-annual-conference-2011, 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 – Analysis Help, Source: SAP

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.

 

Figure 4

In Figure 4, select New button

 

Figure 5

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.

 

Figure 6

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 14^thWhat's New in SAP BusinessObjects Analysis 1.1 Edition for Microsoft Office? (ASUG logon required)

Related Information:

tammy.powlas3/blog/2011/05/01/experiences-of-a-ramp-up-customer-of-sap-businessobjects-analysis-ms-edition-for-office-version-11

Analysis Page

What's new in Analysis 1.1, edition for Microsoft Office?