october 2015.

Analysis for Office Goto ala BEx Query

In BEx Analyzer you could jump into another query from a query / workbook. The GoTo-Function make sense if you have one query for overview and one for detail.

Read More 0 Comments

Analysis for Office Addin crashes

When you have macros in your Analysis for Office Workbook and you remove the Crosstab of a DataSource, Analysis for Office maybe crashes. Therefore, if you need the DataSource no longer, you should remove it completely and not only the Crosstab.

Read More 0 Comments

Enable Analysis for Office Addin

Before you can use Analysis for Office with Visual Basic for Application, you have to load the Analysis Addin. The code for this is in Analysis for Office 1.4:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
Private Sub EnableAnalysisOffice()
Dim addin As COMAddIn

For Each addin In Application.COMAddIns
 If addin.progID= "SBOP.AdvancedAnalysis.Addin.1" Then
  If addin.Connect= False Then addin.Connect= True
 End If
Next

End Sub

 

In Analysis for Office 2.0, SAP has changed the name of the addin. The command is now:

 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
Private Sub EnableAnalysisOffice()
Dim addin As COMAddIn

For Each addin In Application.COMAddIns
 If addin.progID= "SapExcelAddIn" Then
  If addin.Connect= False Then addin.Connect= True
 End If
Next

End Sub

 

Now you can continue working with the SAP Analysis commands.

Read More 0 Comments