Skip to Content

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:

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

 

image

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”


image 

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.

 

 

image 

Figure 4

In Figure 4, select New button

 

image 

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.

image 

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:

image 

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)

 

 

Related Information:

Experiences of a Ramp-up Customer of SAP BusinessObjects Analysis, MS Edition for Office, Version 1.1

Analysis Page

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

To report this post you need to login first.

2 Comments

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

    1. Tammy Powlas Post author
      Thanks Derek!

      And to think, Alex covered this at ASUG Annual Conference – who says technical items aren’t covered at ASUG Annual Conference?

      Alex showed us it was easy to use.

      (0) 

Leave a Reply