bex.

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

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

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

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

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

Unlock Business Warehouse database lock

When the BEx Query Designer crashes while you are creating or modify a query, the user lock this query in the database. You can remove the lock with the Transaction sm12 and erase the entry.

  1. Open TA sm12
  2. Click list
  3. Select the required entry
  4. Click delete
Read More 0 Comments