Design Studio SDK installation

The information what you need to use Design Studio including the SDK can be found on many places. My problem was there is no guide where you find everything and here is a list:

  1. Download the newest version of Design Studio
  2. Download Eclipse IDE for Java EE Developers
  3. Download Design Studio SDK

The actual developer guide can be found here:

read more 0 Comments

Design Studio Settings

The Preferred Startup Mode of Design Studio decides where an application is developed and saved.

Design Studio Settings
Design Studio Settings
read more

Settings for the Analysis Office Plug-in

In Analysis Office 2.2 SP3 some new interesting parameter for Ao_app.config were delivered. The following parameter are interesting and in some case maybe very useful.

  • MaxNumberOfParallelThreads

Use this setting to define the maximum number of parallel threads that can be used to open the SAP HANA DataSources of a workbook. This only works with SAP HANA.

Use this setting to specify the mode of the prompting dialog when you open a workbook from the NetWeaver that contains exactly one DataSource.

In Analysis Office 2.3, which was released on 23th May also brought some new parameter.

  • ShowSsoLogonDialogBip

Use this setting to specify whether the logon dialog box should be displayed when using SSO with the BI platform. This maybe is interesting, if you want to change the logon language.

  • CancelPopupDelay

Since Analysis Office 2.3 it is possible to cancel a query execution. This parameter defines how long the cancel dialog should be displayed. I think this is a really nice option of Analysis Office.


There are a lot of more settings for Ao_app.config in the Admin Guide of Analysis Office. Like for example:

Some I am testing at the moment and will be review them very soon.

read more 0 Comments

Analysis Office Infofields, formulas & Dashboard functions

Analysis Office provides own Microsoft Excel formulas to show information of your data source. I want to explain some of the functions and how to use them in a dashboard or a report.

  • SAPGetVariable
  • SAPGetMember
  • SAPGetInfoLabel
  • SAPGetSourceInfo
  • SAPGetWorkbookInfo
  • SAPGetDimensionInfo
  • SAPListOF
  • SAPListOfDimensions
  • SAPListOfEffectiveFilters
  • SAPListOfDynamicFilters
  • SAPSetFilterComponent


The function SAPGetVariable returns the value for a specific BW variable. For example:

Cell A2: =SAPGetVariable("DS_1";"0S_CUS";"VALUEASKEY")


This formula returns the key for the variable 0S_CUS. You can use this key to fill another formula to get other information. For example:


Cell A3: =SAPGetMember("DS_1";"0SOLD_TO=A2;"0NAME")


If you don't want to have two formulas you can merge them like this.


Cell A4: =SAPGetMember("DS_1";"0SOLD_TO="&SAPGetVariable("DS_1";"0S_CUS";"VALUEASKEY");"0NAME")


The result is still the same.

read more 0 Comments

Design Studio crashes during start

Sometimes Design Studio crashes during start after installation of a new version. I found two threads in the SCN. The simple solution is to uninstall Design Studio, rename the following folder:

  • C:\Users\<user>\Analysis-config
  • C:\Users\<user>\Analysis-workspace

and reinstall Design Studio again. Maybe sometimes it is enough to rename only the folders. More Design Studio troubleshooting can be find in the Design Studio Wiki.


Analysis Office Filter Data by Member

A feature of Bex Analyzer was the upload of selections, so you haven't to type the selections all the time. This feature wasn't available for Analysis Office until version 2.2 SP3. So I looked deeper in this function and want to share my knowledge.

BEx Analyzer Upload Selection
BEx Analyzer Upload Selection
read more 4 Comments

Analysis Office Workbook vs. DataSource Variants

Analysis Office has different two kinds of variants. One is a workbook variant and the other is a DataSource variant. So what is exactly the difference?


If you have a workbook you can save your variants in the prompt dialog.

Analysis Office Save Variant
Analysis Office Save Variant
read more 0 Comments

Analysis Office Variable Operator Contains Pattern

Analysis Office Prompt without Pattern
Analysis Office Prompt without Pattern

Since Analysis Office 2.0 the administrative settings are moved from the registry to the file system. These settings are now maintained in a XML file. As in my article “Analysis Office 2.2 SP2” mentioned the Ao_app.config is repeatedly expanded and sometimes there are new commands available.


In this context the admin guide is always very useful. On this Topic there is also a SAP Note 1920589. To use “Contains Pattern” as it is described in the Analysis Office Help under “Syntax for Entering Values”, it must be activated in the Ao_user_roaming.config file.

read more 0 Comments

Error while executing function module BICS_PROV_OPEN

I just got access to a NetWeaver 7.5 SP2 and I want to test it with Analysis Office 2.3. So I open Excel and insert a query. And here we go first error: "unable to open data source", so I thought maybe the query is broken and I developed a new query and insert it. Here we go, same error. Maybe queries don't work, so I insert a InfoCube directly. Same error…..  


Now I refresh the insert query and got an Analysis Office message: Error while executing function module: BICS_PROV_OPEN

In the explanation was one line with the hint "wrong parameter type in an rfc call", so I looked into st22 and saw a dump which the message: CALL_FUNCTION_ILLEGAL_P_TYPE

The explanation of this dump is "This error appears if parameters submitted incorrectly in a Remote Function Call."  


I searched but found nothing which should help me. After a longer research I found in the SCN this thread and the simple solution is:  


Delete all contents in C:\Users\<your_user>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\cache  


After deleting the content, close Analysis Office and it works. Either the Analysis Office message or the BW dump explain the solution. But maybe someone has the same issue, this is the solution.

read more 0 Comments

Analysis Office Table Design, API and Design Rules

Since Analysis Office 2.0 you have the option Table Design. You can now create new empty rows and columns.

Analysis Office Table Design
Analysis Office Table Design
read more 0 Comments

BEx Query Designer: No Authorization for Query

The other day I had a very strange phenomenon. I was at a client, where I had created several queries a month ago. The query information shows me as owner of these queries. In the meantime the Department has made some small changes, so that I was no longer the last user who changed the query. 

BEx Query Properties Last Changed
BEx Query Properties Last Changed
read more 0 Comments

Analysis Office SAPOpenWorkbook

A new feature of Analysis Office 2.3 is a macro called SAPOpenWorkbook. Some of you maybe know the old sapbex.xla!SAPBExReadWorkbook or the BExAnalyzer.xla!runWorkbook command.


The user guide explanation for this macro is:


You can use this API method to open an Analysis workbook. The workbook that should be opened can be stored on a SAP NetWeaver server or on a BI platform.

The workbook is opened in the same Microsoft Excel instance. After the command execution, the opened workbook is active.


As you know the sapbex.xla!SAPBExReadWorkbook respectively BExAnalyzer.xla!runWorkbook command needed either an established connection from the addin or you created your own connection with the following code:

Dim R32 As Object 'Connection Object

Set R32 = CreateObject("SAP.Functions")


With R32.Connection


    .system = "ABC" 'system

    .client = "001" 'client

    .user = "reyemsaibot" 'user

    .Password = "4711" 'password

    .Language = "EN" 'language

    .systemnumber = "00" 'systemnumber

    .hostname = "" 'hostname


End With


'Test Connection

If R32.Connection.logon(0, True) <> True Then

 Exit Function

End If

read more 0 Comments

Design Studio 1.6 SP2

The new Design Studio version will be released on 8th June. New features will be only available on BI platform, not on SAP NetWeaver. Here is a short Overview of the Roadmap.


  • End user
    • Waterfall Info Charts
    • Display scaling factors in Info Chart
    • Resizable, moveable dialogs
  • Analyst
    • Ad-hoc currency conversion
    • Build virtual hierarchy of stacked dimensions
    • Cascading Filter for Universe and CSV as Data Source
  • Designer, developer, admin
    • New standard components, e.g. Dialog, Filter Bar, Link, Multi-Line Text Input, Switch, Progress Bar (only in Fiori Library)
    • Info Chart Enhancements
    • Initial View Editor: Simple Calculations

More information will be available on 8th June.


BEx Query Average vs. Excel Average

When I was recently creating a new query at a customer, I have found a strange phenomenon. The query should show the average ticket number of a department. First you see the explanation and then I provide the solution of the problem.


The query should show the individual, cumulative and average monthly values, as you can see in the screenshot.

BEx Analyzer Average false values
BEx Analyzer Average false values
read more

Analysis Office 2.3 features

Here is a short overview about the new features of Analysis Office 2.3

  • The Analysis Office API has been extended. It is now possible to save data and to open workbooks.  So you are now able to open workbooks via VBA macro, as then with sapbex.xla!SAPBExReadWorkbook or BExAnalyzer.xla!runWorkbook .
  • It is now possible to cancel long-running queries
  • You can now rename dimensions, attributes and measures
  • There is now an option in the context menu of the components tab, which allows you to logoff from a BW system. This was previously only via VBA API possible. According to this SCN thread it isn't the identical as in Bex Analyzer 3.5/7.0 because you have to replace the system and then reconnect to another system.
  • It is now possible to add filter values via upload of a text file. I believe it was already in Analysis Office 2.2 SP3 available. I will create a detailed post soon.
  • You can create restricted measures on the fly in Analysis Office, but you need BW 7.5 SP4 to do this
  • The sheet protection is provided for the next release in Q4
  • There is a new report type in the transaction RSBBS called "Analysis Office" available, which allows you to jump from Design Studio into an Analysis Office workbook.
  • There is also a new Table Design Rule Editor.

I think there is some cool new stuff in AO 2.3 available. Can't wait to see the next version.


Analysis Office 2.3 is available

Since yesterday Analysis Office 2.3 is available. You can download it here, to download it you need a S-User with download credentials.


The admin and user guide isn't available at the moment. I hope SAP will release it in the next days. First impressions can be made at this SCN article from Tammy Powlas.


I just download the version and hope to write more in the next days.


Analysis Office Save Query View

As in the BEx Analyzer you can save also query views in Analysis Office. Currently in version 2.2 SP2 you can find this option under Tools >> Save View.

Analysis Office Save Query View
Analysis Office Save Query View
read more 0 Comments

Analysis Office Data Analysis Advanced Calculations

Since Analysis Office 2.1 you have a formula editor. You can find this function in the group Data Analysis >> Calculations >> Add Advanced Calculation.

Analysis Office Add new advanced calculation
Analysis Office Add new advanced calculation
read more 0 Comments

Change Requests after release

  1. Open transaction se38
  2. Open program RDDIT076
  3. Execute (F8)
  4. Enter a request or task number
  5. Execute (F8)
  6. Doubleclick on a selected entry 
  7. Switch between Display and Change (F9)
  8. Change your request
  9. Save (CTRL + S)
Change request after release
Change request after release
read more 0 Comments

Process Chain Change Process Type

  • Call transaction sm30
  • Open Table/View RSPROCESSTYPES
Maintain Table Views RSPROCESSTYPES
Maintain Table Views RSPROCESSTYPES
read more 0 Comments