Analysis Office SAPInsertLine

The API command SAPInsertLine is available since version 2.2 SP3 of Analysis Office. With this function you can insert a new line into a crosstab. There are five input-parameters available:

  • RuleID
  • Data Source Alias
  • Position
  • PositionBy
  • PositionBy parameters

You can define the RuleID, if you do not define an ID, the system generates one automatically. As Data Source Alias, you have to enter the data source alias, e.g. DS_1. As Position you can choose between Before, After, BelowHeader or BesideHeader. For PositionBy you can enter one of the following elements:

  • Dimension
  • DimensionResult
  • DimensionGroup
  • DimensionMember
  • HierarchyNode
  • Tuple

Here is an example code, more detail information can be found in my book. This code insert a new line after the dimension 0Material.

 

Dim ret As String

ret = Application.Run("SAPInsertLine", "NewLine1", "DS_1", "After", "DIMENSION", "0MATERIAL")

Analysis Office SAPInsertLine After Dimension
Analysis Office SAPInsertLine After Dimension

This example code insert a new line before the dimension 0Material.

 

Dim ret As String

ret = Application.Run("SAPInsertLine""NewLine1""DS_1""Before""DIMENSION""0MATERIAL")

Analysis Office SAPInsertLine Before Dimension
Analysis Office SAPInsertLine Before Dimension

More examples can detailed information can be found in my book SAP BusinessObjects Analysis Office - The Comprehensive Guide.

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0