blog.

Get the first pages of my book for free!

  • This free ebook contains the first pages of my book
  • You get a look inside and can decide if you want to buy it
  • If you have any questions feel free to ask
* indicates required

Analysis Office 2.5 SP2

In the last month I was very busy with my thesis and my project at work, so I had no time to write a lot of blog posts. So here is a short overview what Analysis Office 2.5 SP2 fix. But keep in mind, Analysis Office 2.6 is up coming.

  •  An execption is thrown when grouping crosstabs (s-note 2530837)
  • Formula SAPGetVariable does not return value for BASEINFOOBJT if variables are merged (s-note 2529886)
  • Group Crosstabs / Compact Display does not work properly (s-note 2527113)
  • Native date, date time and time span rendering (s-note 2482546)
  • Not able to change presentation of attribute (s-note 2525435)
  • Refresh in Open dialog does not work (s-note 2536320)
  • Launching a second workbook starts an empty Excel (s-note 2551513)

There are a lot more bugs which are now patched, so install the latest version.

Read More 0 Comments

What's new in Analysis Office 2.6

Today Alexander Peter showed in the ASUG Webcast Analysis Office 2.6. The expected GA is in three weeks. New in Analysis Office 2.6 are the following things:

  • Table Design Improvements (auto complete enhancements)
  • Improved handling of new lines in planning applications (SAP BW 7.5 SP11)
  • Open Analysis Office workooks using variables (BI Platform 4.2 SP5)
  • Editing schedule jobs (BI Platform 4.2 SP5)
  • Scheduling based on events (BI Platform 4.2 SP5)
  • Publications (BI Platform 4.2 SP5)
  • More features with SAP Analytics Cloud such as exception aggregation
  • Access repository of all (native) cloud models
  • Exception aggregation on the fly
  • Use Dynamic Calculations Rank and Rank Olympic (planned for SP1)
  • Launch Workbooks directly from the BI Platform with variables (BI Platform 4.2 SP5)
  • Rescheduling Jobs on the BI Platform 4.2 SP5
  • Scheduling workbooks with events (e.g. successful/failed data load to BW)
  • Use VLOOKUP with Table Design
  • Filter by Range is now possible
  • New Parameter such as EnableNativeFormatting or UseNewLinesLegacyMode
Read More 0 Comments

SAP BW Use Pattern in Variable with Customer Exit

In my current project I created with a collegue a really cool function to analyze a string with 1333 characters. We are using a BW 7.4 SP 17 on HANA. First we have to build an Advanced DataStoreObject with a Field which has a length of 1333. For further understanding, we call the field Field_1333. As data type I used SSTRING.

Create a field with a length of 1333 in Eclipse
Create a field with a length of 1333 in Eclipse
Read More 0 Comments

Analysis Office 2.5 - Technical Configuration

A really cool feature of Analysis Office 2.5 can you see in the "backend" under File >> Analysis. The function Customize Analysis offers now new options. Besides the Customize User Interface from Analysis Office 2.4 which allows you to change the ribbon menu of Analysis Office, you now can directly modify the technical settings of Analysis Office.

Customize User Interface
Customize User Interface
Read More 2 Comments

Analysis Office 2.5 DataSource Information

This week is very short in case of the day of German unity and we have sprint change next week, I haven't time to write a lot so here is just one goodie. When you insert a DataSource in Analysis Office 2.5 you see the recent inserted DataSource. Now in Analysis Office 2.5 you also see the technical name of the query and the system. I think this is nice if you are testing a query on different systems.

Recent DataSource
Recent DataSource
Recent DataSource Detail Information
Recent DataSource Detail Information

Read More 0 Comments

Analysis Office 2.5 Scaling Factor

In my current project I work a lot in the backend of a BW 7.4 on HANA but I finally found time to look into Analysis Office 2.5. Here is a short explanation about the feature that the scaling factor works now with conditional formatting. If you configure your conditional formatting like the following screenshot and apply after that your favourite scaling factor. It automatically adjusts.

Define Conditional Formatting
Define Conditional Formatting
Read More 0 Comments

Analysis Office 2.5 is available

Analysis Office 2.5 is finally available since the end of August for everyone. After I submit my diploma thesis last week, I have now time to see whats new in Analysis Office 2.5. Here is the first short overview of the new feature:

  • You are now able to connect to SAP BusinessObjects Cloud
  • Customize User Interface has new options
  • New different troubleshooting modes
  • New options with Table Design
  • A new API method SAPCallMemberSelector
  • Changes on the grouping Crosstab function
  • New file system setting ShowUtcTimeStampsInDataCells

This is a first view on the What's new Guide. I am also published Analysis Office - The Comprehensive Guide (2nd edition) as a Kindle ebook on amazon. Feel free to choose where to buy it. So stay tuned.

Read More 0 Comments

Analysis Office 2.5 & AMDP

At the moment it is very quiet about new blog post. This is maybe the summer break everybody talks about. ;)

I am at the final phase of my diploma thesis and have no time to do cool stuff and also SAP doesn't release Analysis Office 2.5. It is still in ramp up and nothing new at the moment.

 

So I could only say, my current project is a BW on HANA and I am testing how HANA SQL Script (AMDP) works and how fast we could build some stuff. First tests show a transformation with routines for 800.000 records about 1:55 minutes. The same transformation with AMDP (ABAP Managed Database Procedures) only need between 15 - 23 seconds. This is really impressive. 

 

So stay tuned, if SAP will release Analysis Office 2.5 and some examples with AMDP.

Read More 0 Comments

Design Studio Mobile Application

Mobile Application is the big thing in management. If you want to create a mobile application in SAP Design Studio, SAP have some recommendations:

  • Keep the application simple and don't use too many components
  • Don't use crosstab components for smartphone applications
  • Limit the total number of cells in your crosstab to 500 for tablet applications

I hope everybody stick to this recommendations or we will see people looking like that:

Read More 0 Comments

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.

BW/4HANA Transaction stms
BW/4HANA Transaction stms
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

I am still waiting for Analysis Office 2.5, which is still in ramp up. Here is a first look from Tammy.

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.

Create new Advanced DSO
Create new Advanced DSO
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.

There are a good post on the SCN. First you have to download Oracle VirtualBox. After that you have to download openSUSE. If you are a Linux Newbie you can read the following post how to install openSUSE on VirtualBox. The BW 7.5 SP2 developer edition can be found here.

 

After you have downloaded everything and your openSUSE is running you should read this post to get the installation of the BW done. I needed a BW 7.5 for the new edition of my book, so it was a nice variety for me. 

Read More 2 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 Performance optimization for mass data without SAP HANA

Introduction

In my current project, we have to deal with 30.000.000 records for the initialization run and about 10.000.000 records each day. The big problem is we have no SAP HANA system for BW. So, we have to build a perfect data model to load the data and push it through the BW to deliver it to another DWH system. First I want to describe how our first steps worked and then which parameter we changed to make it more efficient. I will also describe where we had our problems and how we have solved them. So let's go.

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.

The elements have also shape-data which can be filled. For example DataSource has the following shape data:

  • Name
  • Source System
  • Update Mode
  • Loading Time

A DataTransferProcess has for example:

  • Technical Name
  • Extraction Mode
  • Loading Time
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.

Old with only one MultiProvider
Old with only one MultiProvider
New with two MultiProviders
New with two MultiProviders

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).

Data in InfoCubes before Analysis Process (APD)
Data in InfoCubes before 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.

Now you can enter one InfoCube and choose Transfer. Now you can add more tests or click Execute to run the test.

Read More 0 Comments