archive.

BW/4HANA Export Transports

I know that I don't publish a lot of new posts the last few weeks. The reason is I am writing on my diploma thesis. The title is "S/4HANA versus BW/4HANA - Zukunft der Datenanalyse". My deadline is in the middle of September so I have to write a lot these days. At the moment, I have access to a BW/4HANA instance in the cloud and I want to share how you could export your development before you terminate the instance. First you have to log on with the SAP* user in the client 000. Go to the transaction stms and select the System Overview.

Read More 0 Comments

Analysis Office 2.4 SP3 is released

Last week the Analysis Office 2.4 SP3 was released. Here is a short overview of notes, which may solves some problems.

  • 2460877 - Excel crashes when opening several workbooks with SAPListOfMessages
  • 2461196 - Advanced calculation editor throws error when inserting a member
  • 2468933 - Effective filter shows only # for compounded characteristic
  • 2463167 - Non-SAP (built-in) formula cells of workbook are not refreshed
  • 2467459 - Prompts dialog clears variable
Read More 0 Comments

BW Modeling Tools create advanced DataStore-Object

If you use a BW/4HANA instance, you have to use the BW Modeling Tools (BWMT) to build your data model. You could only build Advanced DataStore-Objects (ADSO). If you create a new ADSO, you have to select a BW-Project and an InfoArea. After that you have to define a technical name and a description. You could also use a template to build your ADSO.

Read More 0 Comments

Install your own SAP BW on a virtual machine

I described in a earlier post how to use BW/4HANA on Amazon AWS. But if you just need a developing system for some time and don't want to use BW/4HANA, you can use the BW 7.5 SP2 developer edition on a virtual machine.

Read More 0 Comments

Analysis Office - The Comprehensive Guide 2nd edition

After I had time in my parental leave to read proof the second edition of my book, I can say it is now finished. The second edition is now available in the store. You can download the table of content here. This version is only available here and at the moment not on Amazon.

 

If you have any questions feel free to ask and send me either an email or a comment. I hope to publish regularly in the next weeks so stay tuned.

Read More 0 Comments

Analysis Office Video Course

In this blogpost I want to know if there is an interesting about an Analysis Office Video Course. Thanks for your time and your answers. Open the survey.

Read More 0 Comments

SAP BW Visio Shapes

I want to document a BW data model and searched for a Microsoft Visio shape, but I found nothing. So I build my own Visio shapes. At the moment there are the following types available:

  • DataSource
  • Transformation
  • DataStoreObject
  • InfoCube
  • SPO
  • MultiProvider
  • DTP
  • InfoSource
  • OpenHub
  • Query

I used them in my last blogpost about Copy Queries to a new MultiProvider.

Read More 1 Comments

SAP BW Copy Queries to a new MultiProvider

In my current project, we want to separate the current MultiProvider with VirtualProvider underneath into one MultiProvider with VirtualProvider and one MultiProvider without VirtualProvider. This step is necessary, because we receive a lot of data and don't want to push all these data through the VirtualProvider. The VirtualProvider only add one field which we haven't got in our InfoCubes and it isn't necessary in all queries just a few.

Read More 0 Comments

SAP BW Analysis Process Designer (APD)

At the moment I had to deal with a special problem. I have data in a SPO from two different sources and the goal was to find the corresponding two data lines and make one out of it. This line should marked with a special character. So I decided to build an Analysis Process (APD).

Read More 0 Comments

SAP BW Check your data model

Sometimes it is necessary to check your data model if it still fit your needs. For this you can use the transaction rsrv. Select there under All Elementary Tests >> Database >> Database information about InfoProvider tables.

Read More 0 Comments

Analysis Office 2.4 SP2 is released

On 10.03.2017 a new service pack for Analysis Office was released. The main reason why you should update from SP0 or SP1 is that they fixed a lot of bugs in it (and maybe they build some new). Here is a short overview of the fixed problems:

Read More 5 Comments

SAP BW find meta chain

In my current project I had to clean up the existing process chains. A lot of process chains were created via SPOs and not really used in the system. First I had to check, if one is used in a another process chain or in which one they are used.

Read More 0 Comments

SAP BW Change Object Directory Entries

In my current project we have to transport from a maintenance system to our development system. The problem is when you now transport the objects into quality system, you have to check the option "Overwrite Originals" so that your transport is working. But you have to put this flag on every transport you make in the future from your development system to quality.

Read More 0 Comments

Analysis Office Get Calendar Week for SAPSetFilter

A few weeks ago, a colleague of mine, ask me how he can get the calendar week to use it in the Analysis Office API SAPSetFilter. I developed a short macro which defines the calendar week to use it in 0CALWEEK. Maybe someone has another solution for this.

Read More 0 Comments

Analysis Office Hide Customize User Interface

In this thread on blogs.sap.com, Michael Hamm asked how to hide or deactivate the Customize User Interface button. At first, at the moment SAP doesn't offer any checkbox which you can check and uncheck in the settings.

Read More 0 Comments

Analysis Office Insert Product Image

In the comments of this blogpost on blogs.sap.com, Stephen Hobbs showed his idea of insert a product Image besides the crosstab in combination with the new Customize User Interface function. So I make my own thoughts how I can realize a thing like this.

Read More 0 Comments

Analysis Office 2.4 Table Design features

In Analysis Office 2.4 SAP improved the Table Design Editor. You can now create and edit formulas. In an earlier post, I described how to work with Excel formulas in a crosstab. You can add a new column with the table design functionality.

Read More 0 Comments

Analysis Office 2.4 SP1 is available

Since 13.01.2017 the SP1 of Analysis Office 2.4 is available. You can download it here. You need a S-User to download it. There are three new file system settings:

  • UseDataSourceDeltaUpdate
  • EnforceDatePickerForCalendarDayVariable
  • SetEmptiedDoubleDataCellsToValue0

There are also some changes in the User Interface Customization.

Read More 0 Comments

SAP BW Transport of Copies

In my current project, we have a copy of the productive system as a maintenance system, because we made huge changes in

the development system in case of the project. So if there is an error in the production, we can easily repair it.

 

Some changes have also be transported into the development system, so we have the same state and our future request can be transported into production. For this we use the functionality Transport of Copies. All objects of the originally request are still locked. If you want to create a transport of copies, open the transaction SE01. Check the option “Transport of Copies” and click on Display.

Read More 0 Comments

SAP BW Create SPO via BAdI - Part 3

After we created in Part 1 the transparent tables and in Part 2 all BAdI implementation, we can now maintain and create our SPO. First we have to fill our table ZSPOPATTERN with a PATTERNID and a corresponding INFOOBJECT. Go to the se16 and create a new table entry. As PATTERNID enter a unique id for example CALYEAR and as INFOOBJECT 0CALYEAR. For TXTLG and TXTSM enter a useful text. Depending on how many InfoObject are used for a partition, create the other pattern.

Read More 0 Comments

SAP BW Create SPO via BAdI - Part 2

After we created in part 1 all tables and objects, we can now create a new BAdI to generate the partitions. Go to the transaction se19 and create a new implementation with the Name RSLPO_BADI_PARTITIONING.

Read More 0 Comments

SAP BW Create SPO via BAdI - Part 1

At my current project I needed a way to create Semantic Partitioning Object (SPO) via BAdI to reduce the end-of-year work. After a little search via Google (you cannot find anything on the new SAP Community Page), I found these threads.

Read More 0 Comments

BW Modeling Tools add a new project

After I started my BW/4HANA instance on cal.sap.com and everything was working, I logged on and typed RSA1. But there was no modeling tab anymore. Then I rememberd, I need the BW Modeling Tools. So I installed the latest Version of Eclipse and the BW Modeling Tools. After that I need a Project. The project is the binder for all activities in our BW system. Make a right-click in the Eclipse Project Explorer and choose BW Project.

Read More 0 Comments

Analysis Office 2.4 Workbook Protection and Styles

A new feature of Analysis Office 2.4 is workbook or sheet protection. It is similar to the Microsoft Excel Protect Sheet / Workbook function, but it is also different. When you need to protect your workbook or sheet and you use the Excel functionality, you can not refresh or drill down your Crosstab. But when you want to refresh your data or give the users the opportunity to drill down or filter, you have to use the workbook / sheet protection from Analysis Office.

Read More 0 Comments

Analysis Office 2.4 File System Settings

Analysis Office 2.4 also provides new file system settings. Especially for the new Customize User Interface function. The file Cof_app.config provides all these parameters:

  • AppBuilderDefaultProfilePath
  • AppBuilderUserProfileDirectory
  • AppBuilderCompanyProfileDirectory
  • AppBuilderReadOnlyProfileDirectories

And also these parameters:

  • CurrentCodePage
  • SapWebGuiPath
  • NwbcTicketIssuerPath

Only then AppBuilderCompanyProfileDirectory is a PerMachine parameter, the others are UserRoaming. How the other parameters exactly work has to be tested. The Ao_app.config also provides new parameters:

  • DefaultBWQueryDesigner
  • DoSelectorHierarchyExplicitSelection
  • AutoCompleteFetchMemberLimit
  • HanaHttpConnectionTimeout

So it can be possible that the user can choose between the old BEx Query Designer and the new BW Modeling Tools. The default parameter is "0", so at the moment I cannot say what exactly has to be the value for other query designers. The parameter DoSelectorHierarchyExplicitSelection should select only the child nodes of a node and the parent node is not automatically checked. But I haven't got a chance to test this. So I can't confirm this. I don't know at the moment how the parameter AutoCompleteFetchMemberLimit works, I only know the default value is 30. But as soon as possible I add these information to this post.

Read More 0 Comments

Setup BW/4HANA on Amazon AWS

So after I read a lot about BW/4HANA, I decided to create a own SAP BW/4HANA 1.0 [Developer Edition] instance on my Amazon AWS account. First I had to extend my normal AWS account with a IAM user. For this you choose under Security, Identity & Compliance >> IAM. Under Users you click on Add user.

Read More 0 Comments

Open documents from BI platfrom with .Net

After we can log on to a BI platform with our .Net application, we want to open a document for example a Analysis Office workbook. First we have to define several variables.

Read More 0 Comments

Analysis Office 2.4 Customize User Interface

A new feature of Analysis Office 2.4 is that you have a function called Customize User Interface. On the first view it looks similar to the Excel customize ribbon function. But it has more flexiblity to switch between different interfaces. First you have to open the Customize User Interface dialog via File >> Analysis. The following dialog appears.

Read More 8 Comments

What's new in Analysis Office 2.4

Since yesterday Analysis Office 2.4 is available. You can download it with a S-User under Support Packages and Patches >> By Alphabetical Index (A-Z) >> A >> SBOP Analysis Office >> SBOP Analysis MS Office 2.4.

 

The SAP help page isn't updated yet. But I think it would be updated in the next days.

Read More 0 Comments

Analysis Office - The Comprehensive Guide

After @xjhacking conviced me or say talk round, here is a one day offer for my book Analysis Office - The Comprehensive Guide. You can buy it for 9,99 € until tomorrow evening.

Read More 2 Comments

Access BI platform with a .Net Application

After we configured the BI platform with Windows Active Directory Single sign-on (SSO) we now can access the BI platform easily with a .Net application. 
First you have to install the BIP .Net SDK. You can download it from the SAP marketplace. Go to Installations and Upgrades >> By Alphabetical Index (A-Z) >> B >> SBOP BI Platform (former SBOP Enterprise) >> SBOP BI Platform 4.2 >> Installation and Upgrade >> SBOP BI Platform 4.2 SP03 ENTER .NET SDK Runtime Windows. You need a S-User with download credentials. For more information about the SDK commands you can look into the help file and the documentation.
Read More 0 Comments

Install BI Platform and setup Windows AD authentication

This week I want to test the integration of a BI Platform to my .Net program. So I want to install a test version of the BIP, but my virtual machine hadn't enough space. The first step was to extend the space of the disk. It is very easy in VirtualBox to extend the disk.

  1. Open the Windows Console
  2. Go to the path where you installed Virtual Box. (Default: C:Program FilesOracleVirtualBox)
  3. Type VBoxManage.exe modifyhd "Path to the disk" --resize 100000 (=100 GB)
  4. Press Enter and your VirtualBox will be extended

After my VirtualBox was ready I could install the BIP. But the next issue was found very soon. I need a license key.

Read More 0 Comments

How to build a RFC Server with NCo 3.0 Part 2

So it is done, Part 2 finally is written and an example is uploaded to github. It took me about 8 months to release Part 2 of these series. Part 1 was released in March 2016 and now I had time to write an example for Part 2 and upload it to github. Part 1 discover the basics about a RFC Server with the SAP NCo Connector, part 2 now explain how to build a RFC Server more flexible.

Read More 0 Comments

Design Studio Import & Export Application

If a SAP Design Studio Application has been developed in local mode or on a develop machine, these can be exported and then imported into a new system. Here is a short guide.

Read More 0 Comments

BW Modeling Tools

This week the new open SAP course BW/4HANA in a Nutshell started. It is a free course. One big thing is that BW/4HANA no longer supports the good old BEx Suite. You now have to use the BW Modeling Tools based on Eclipse. In this and further posts I will go deeper into the BW Modeling Tools and what is possible and what is not possible at the moment.

 

If you have any questions feel free to ask or correct me ;) So let's get started.

Read More 2 Comments

SAP Design Studio Update Extension

Here is a short guide how to update an extension in SAP Design Studio.

 

1. Select Help >> About

Read More 0 Comments

Design Studio setting up Eclipse

In this article I describe in a short manual how to set up Eclipse for Design Studio.

 

1. Open Eclispe and choose Window >> Preferences.

Read More 0 Comments

Migrating Analysis Office workbooks from BW to BI Platform

This week I don't have much time to write an article about Analysis Office, but I found an interesting article from Xavier about Migrating Analysis for Office workbooks from BW to BI Platform last week.

 

The topic came up yesterday as a collegue asked me if I know why he can't save a workbook to the BI platform. The workbook was opened from a NetWeaver system and than the option save to BI Platform isn't available.

 

So read this article if you have the same problem.

Read More 0 Comments

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
Read More 0 Comments

Analysis Office Cancel long-running Queries

Since Analysis Office 2.3 was released, you are able to cancel long-running queries. In the Ao_app.config you can define the parameter CancelPopupDelay. The default value is 5 seconds. You can change this setting to specify after how many seconds the cancel dialog should be displayed. The dialog could appear when you inserting a data source or navigating through the data and it took more than 5 seconds.

 

If the dialog is displayed, you could press "cancel" to cancel the server request. In the following message dialog, you can select restart to go back to the workbook and the data source is active. Or you select close to go back to the workbook and the data source is offline. If you don't cancel the request, the dialog will disappear automatically when the server request is completed.

 

Read More 0 Comments

SAP BusinessObjects Analysis Office - The Comprehensive Guide

It is done. My Analysis Office book is finished. You can now download the table of content and the release of the book is next week. Have fun and if you have feedback send it to me. 

 

Have a nice weekend.

Read More 0 Comments

Using SAPGetVariable with VBA

At the moment I am working very hard to get my book done, so this is only a short blog post how to use SAPGetVariable with VBA. The Analysis Office help provides no example so here it is:

Read More 0 Comments

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:

Read More 0 Comments

Design Studio Settings

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

Read More 0 Comments

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.

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:

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.

Read More 2 Comments

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.

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.

Read More 0 Comments

Analysis Office Variable Operator Contains Pattern

Analysis Office Prompt without Pattern
Analysis Office Prompt without Pattern
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

Read More 2 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.

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.

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:

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.

Read More 0 Comments

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.

Read More 0 Comments

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.

Read More 0 Comments

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.

Read More 0 Comments

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.

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.

Read More 2 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)
Read More 0 Comments

Process Chain Change Process Type

  • Call transaction sm30
  • Open Table/View RSPROCESSTYPES
Read More 0 Comments

Analysis Office Logoff

After SAP still doesn't provide a native button in Analysis Office 2.2 SP2 to log off from a system, I decided to make a short instruction from my article "Analysis Office 2.1 Logoff via VBA". Have fun.

Read More 0 Comments

Design Studio Install Extension on BI Platform

If you have developed your own extension with the SAP Design Studio SDK and want to publish this extension on the BI Platform, you have to click on Help >> Platform Extensions.

 

Now you see the following screen.

Read More 0 Comments

Design Studio Application Print

I just want to implement a button which should print my application. I found a tutorial, which says the code is APPLICATION.PRINT. But when I write the coding in Design Studio, .Print isn't available.

Read More 0 Comments

Design Studio Preferences

I just started working intensive with SAP Design Studio and developing own components. When you install Design Studio 1.6, it starts in local mode. In this mode you can save your design studio application only on your local maschine. If you want to use other supported platforms, you have to select the required platform in the settings.

Read More 0 Comments

Analysis Office 2.2 SP2

Since three days a new service pack of Analysis Office is available. Now you can use Analysis Office and Excel 2016. 

 

Here is a summary of new functions

  • New settings in the Ao_app.config available for example: MaxNumberOfParallelThreads or NcoTraceLevel
  • Separate tabs for Search, Area, Role and Workspaces in the Open Data Source dialog.
  • A new callback called BeforeFirstPromptsDisplay is implemented
  • More advanced settings are available for example RFCBundling, Allow Client and Language for SSO Logon

Detail information can be find in the What's new Guide.

Read More 2 Comments

How to build a RFC Server with NCo 3.0 Part 1

In some cases you want to trigger an external program from a SAP system. In this part 1 I explain how to build a RFC Server with NCo 3.0. I had several problems when I started with this topic so I decided to write a short example. If someone want the Visual Studio project files, please contact me.

 

So let's go.

 

This Post describes how to build a simple RFC Server using SAP NCo 3.0 and the app.config. Part 2 will be describe how to build a RFC Server with RFC Parameter. As example program I use STFC_CONNECTION. It is a good example, because it contains importing and exporting parameters.

 

First you have to download and install NCo 3.0 (OSS login required). Afterwards you have to start a new project in Visual Studio.

 

Setting up the Visual Studio Project:

 

In the properties of the project you have to use a new console application. As target framework I use .Net Framework 4.5.

Read More 0 Comments

Sum many ranges with ALT=

I just found a very good tip at Chandoo's blog, how you can sum many ranges with multi-select.

Read More 0 Comments

.Net Error Interop type cannot be embedded

While developing in the Visual Studio for .Net you can get an error like this: "Interop type 'CrystalDecisions.Enterprise.SessionMgr' cannot be embedded. Use the applicable interface instead." or in German: "Interop Typ 'CrystalDecisions.Enterprise.SessionMgr' kann nicht eingebettet werden. Verwenden Sie stattdessen die anwendbare Schnittstelle."

 

To aviod this error, you have to change the properties of this reference. You have to switch the "Embed Interop Types" from True to False.

 

Read More 0 Comments

Support SAP Connector for Microsoft .Net (NCo)

In the last time I had several problems with external access to a SAP BW System. The access was realized with an old version of the SAP Connector. And that is the problem. If you have a SAP Business Warehouse System version which is greater than 7.3, you maybe get troubles. For example SAP added new fields or like in 7.4 you now have the option for "Long text is XL" in the master data. So the old versions would not work with this.

 

I just found a very good table about the maintenance of all versions in Martins blog.

Read More 0 Comments

Rename and delete an Analysis Office Workbook

If you want to delete or rename an Analysis Office Workbook, you have to right click on the Workbook Opendialog.

Read More 0 Comments

Video How to maintain Master Data in SAP 7.4 

After „SAP BW 7.4 Maintain characteristics“ is one of the most read posts. I visualize this post in a short video.

Read More 0 Comments

Analysis Office: How to work with Excel formulas

In Analysis Office 2.2 a new feature was published. You can now use your own Excel formulas in a Crosstab. First you have to add a row or column in your Crosstab. The table design is a feature since Analysis Office 2.0.

 

You can add your formula.

Read More 0 Comments

Analysis Office: Best Practice Connection

After the article "Connecting error in Analysis for Office via VBA" is often read, I would like to publish a few tips and tricks about working with Analysis Office.

 

The most important thing when you are working with VBA in Analysis Office, is the refresh of the DataSource(s). Otherwise nothing works. Once a connection to the Business Warehouse is established, each DataSource needs to be refreshed.

 

If you have only one DataSource, that is the source code:

 

Call Application.Run("SAPExecuteCommand", "Refresh", "DS_1")

 

If you have more than one DataSource, this is the source code:

 

Call Application.Run("SAPExecuteCommand", "Refresh")

 

So that you know if the refresh was successful, you should use the following source code:

 

Dim lResult As Long

lResult= Application.Run("SAPExecuteCommand", "Refresh")

 

or

 

Dim lResult As Long

lResult= Application.Run("SAPExecuteCommand", "Refresh", "DS_1"

 

Therefore you can check lResult to 1 or 0. If you refresh the DataSource(s) each time, a lot of time is wasted. To counteract this, there is the following source code:

Call Application.Run("SAPGetProperty", "IsDataSourceActive", "DS_1")

 

This command checks if the DataSource is already active. Here an example source code:

Sub AnalysisOfficeStart()

Dim lResult As Long

'Connection is running?

If Application.Run("SAPGetProperty", "IsConnected", "DS_1") Then

'Active DataSource?

If Not Application.Run("SAPGetProperty", "IsDataSourceActive", "DS_1") Then

'Refresh DataSource

lResult = Application.Run("SAPExecuteCommand", "Refresh", "DS_1")

Else

'Show Prompts

lResult = Application.Run("SAPExecuteCommand", "ShowPrompts", "DS_1")

End If

Else

lResult = Application.Run("SAPLogon", "DS_1", "Client", "User", "Password")

lResult = Application.Run("SAPExecuteCommand", "Refresh", "DS_1")

End If

End Sub

 

After this you can excute your own code.

Read More 0 Comments

Analysis Office 2.1 Logoff via VBA

Since version 2.1 Analysis Office is now finally a VBA command to log out of the current system.

 

So far is nothing in the help file, but it is called in the SCN Forum under "Whats new in Analysis Office 2.1".

 

The command is:

Public Sub Logoff()

Call Application.Run("SAPLogoff",Parameter)

End Sub

 

Parameter:

  • True: With this value, the connection is restarted the system
  • False: With this value the connection will not restart the system

Result:

  • 0: faulty execution
  • 1: Successful execution
Read More 0 Comments

Analysis 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 Office Addin crashes

When you have macros in your Analysis Office Workbook and you remove the Crosstab of a DataSource, Analysis 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 Office Addin

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

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 Office 2.0, SAP has changed the name of the addin. The command is now:

 

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

SAP Analysis Office filter multiple items

Update: Since Analysis Office 2.3 you also can filter your data by uploading a file.

Read More 0 Comments

SAP Analysis Office DataSource Info Field

As in BEx Analyzer, there is important information that you would like to represent in a Workbook. If you have worked with BEx Analyzer, this screenshot should be familiar.

Read More 0 Comments

One further Excel Dashboard Example

The previous post about Excel Dashboards has such an appeal found, so I want to show another example.

Read More 0 Comments

Create simple Excel Dashboards

You want to use the data which is provided by the Business Warehouse in your monthly report or any other report. The SAP Reporting tools like BEx Analyzer or Analysis for Office provides this data in "data tables". These are not easy to read and maybe it isn't possible to see at first glance what you want to express.

Read More 0 Comments

SAP BW find orphaned workbooks

You can use the ABAP program RRMX_WORKBOOKS_GARBAGE_COLLECT to find workbooks that are currently assigned to a user or group of users via the transaction SE38. Through the hook "Workbooks found erase" these are removed from the system.

Read More 0 Comments

Relocation of OLAP functions on SAP HANA

With every new release of SAP HANA functions are moved from the OLAP engine into the database. The current state of the push down can be found in note 2063449. So check this note from time to time, if it is interesting to implement a service pack.

 

Note: You need a S-User to access this note.

Read More 0 Comments

How to convert a text field into a date field with VBA

When you get a date from BEx Analyzer or Analysis Office the Excel internal format is Text and not Date. This means that the sorting doesn't work correctly. Use the following VBA source code to convert easily text to date.

 

Read More 0 Comments

Analysis for Office Increase data cells

A limiting factor in SAP BusinessObjects Analysis is the restriction to 500,000 cells per DataSource. The limitation is calculated from rows * columns. This limitation can be increased by the following parameter value in the registry:

 

HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSource\ResultSetSizeLimit = -1

 

The Value “0” means that the default value is defined by 500,000 cells. Values greater than zero will return the entered value as number of cells. If you want to use the Business Warehouse settings you have to set the Value “-1”.

The corresponding parameter value for this can be found in the Business Warehouse table RSADMIN. The Object is “BICS_DA_RESULT_SET_LIMIT_MAXHKEY”.

Read More 2 Comments

SAP BW hierarchy and attribute change run for all InfoObjects

  1. Call transaction se38
  2. Run Program RSDDS_AGGREGATES_MAINTAIN
  3. Select InfoObjects or hierarchy
  4. Run
Read More 0 Comments

SAP BW 7.4 Maintain characteristics 

Unfortunately, SAP shifted the maintenance of master data in SAP BW 7.4 into the Web. Not everyone wants to maintain the master data on the Web. Here is a small workaround.

Read More 2 Comments

SAP COPA keyfigure assignment

  1. Call transaction sbiw
  2. Select menu item "Settings for Application-Specific DataSources (PI) >> Profitability Analysis >> Assign Key Figures
  3. Choose either "New Entries" or modify existing one.
Read More 2 Comments

Define SAP COPA key figure schemes

  1. Call transaction SPRO
  2. Calling SAP Reference IMG
  3. Controlling >> Profitability Analysis >> Information System >> Report Components >> Define Key Figure Schemes
  4. Choose Operating concern
  5. Select Elements of the key figure scheme
  6. Select a key figure
Read More 0 Comments

Remove BW Query from user favorites

  1. Call transaction se16
  2. Select table SMEN_BUFFC
  3. Enter Username and/or Report
  4. Run
  5. Select entry
  6. Go to menu >> table entry >> Delete the entry
Read More 0 Comments

Explosion of structured items 2LIS_03_BF

From time to time there is a mistake in the resolution of structured items and the transfer of material hierarchies to BW. It helps the Note 1410263.

Read More 0 Comments

Create own Excel formula

In Excel you can quickly create very complex formulas. If you want to simplify your formula, you can also write your own function in VBA. Here is an example for calculating the percentage variance from the previous year.

 

Option Explicit

Public Function prozent(source As Double, target As Double)

prozent = Application.WorksheetFunction.IfError(IIf(target < 0,(source - target) / -target, (source - target) / target), 0)

End Function

 

As you can see, a very simple formula. For this purpose the sample as an Excel formula.

 

=IFERROR(IF(targetCell < 0,(sourceCell - targetCell) / - targetCell,(sourceCell - targetCell / targetCell), 0)

 

= (ACT) 215 - (PY) 204 / (PY) 204 = 0,055 = 5,5 %

 

As you can see the own formula is more readable and can be easily combined with another formula.

Read More 0 Comments

Delete VBA array content

There is an easy way to delete the contents of an array. Is possible by the command Erase

 

Option Explicit

Sub FeldBeispiel()

Dim fFeld(5, 5) As Integer

fFeld(3, 3) = 3

MsgBox fFeld(3, 3)

Erase fFeld

MsgBox fFeld(3, 3)

End Sub

Read More 0 Comments

Factors affecting the performance of the BEx Analyzer

In SAP Support Portal you find the Note 1101143. The Note provides an overview of the factors which affecting the performance of BEx Analyzer.

Read More 0 Comments

SAP BW ABAP remove symbols

From time to time it happens that the source system delivers special characters and the Business Warehouse system can not handle it. So the loading process may be crashed.

 

One solution is the following ABAP code:

 

DATA:

zeichen(1) TYPE c,

muster(2) TYPE c,

field TYPE c LENGTH 000060.

field = SOURCE_FIELDS-YYSTREET.

 

DO.

IF field CO

' !"%&()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜßabcdefg' & & 'hijklmnopqrstuvwxyzäöü '.

EXIT.

ELSE.

zeichen = field+sy-fdpos(1).

muster+0(1) = zeichen.

muster+1(1) = space.

TRANSLATE field USING muster.

ENDIF.

ENDDO.

RESULT = field.

Read More 0 Comments

Infoset throws dump while checking or activating

While checking or activation of an InfoSet the BW System generates the following Dump:

 

"UNCAUGHT_EXCEPTION" CX_RS_INPUT_INVALID

"CL_RSQ_ISET_APPEND ============ CP"

"SPLIT_APPENDNM_FALIAS"

 

Solution: This is a program error and by installing the SAP Note 1970282 resolve this issue.

Read More 0 Comments