2020.

BW/4HANA: Customer Exit Variable with dynamic assignment

After my last post about Customer Exit Variables with an own enhancement spot I want to share another solution with you. In this blog post I want to show you how you can implement a BAdI implementation with a Z-Table (Customer Table). In this table you find the assignment between the BEx variable and the corresponding class for the customer exit.

Read More 0 Comments

BW/4HANA 2.0 Customer Exit Variables with own enhancement spot

For a long time we used for checking and manipulation of customer exit variables the enhancement RSR00001. Since SAP BW 7.3 SAP offers the BAdI RSROA_VARIABLES_EXIT_BADI. Since BW/4 you only could use this BAdI and not anymore the enhancement RSR00001.

 

The BAdI RSROA_VARIABLES_EXIT_BADI is a filter based BAdI. As filter object is used the InfoObject which the variable is based on. Every implementation calls the interface IF_RSROA_VARIABLES_EXIT_BADI~PROCESS. So now let's create an example customer exit variable. The variable is based on Sales Channel (ZQV_ZSALCH_CEO_001) and can handle multiple single values.

Read More 0 Comments

BW/4HANA 2.0 first impressions

I recently got a BW/4HANA 2.0 project. So I want to share some ideas and thoughts I discover in the whole process. First things first. Everything and I mean everything is only available in the BW/4 cockpit now. ADSO, InfoObject, Hierarchy management and even the Process Chain management is only available in the web. Some things are very confusing when you see it first. But let's dive in.

Read More 1 Comments

Analysis Office Video Course is done

My video course about Analysis for Office is done. It will be released on 06.07.2020 @ 8:00 am MESZ. You find it under video.analysisoffice.net and you get more than 4 hours of 4k content for only 199€. The content will be extended if it is necessary. Here is a overview of the curriulum. 

  • Installation and Configuration
  • Customize Analysis Office 
  • Basic Functionality
  • Advanced Funtions
  • Reporting with Analysis API and VBA

Every chapter has a lot of videos to explain certain functions in detail. You can also view some letures as a preview for the course so have a look into it. Here are some examples with to show you what you can expect.

Read More 0 Comments

Analysis Office 2.8 SP3 is available

I know its been a while since the last blog post. But I am currently working on the Analysis Office Video course to get it done. When you follow me on Twitter or Linkedin you get an update all the time. But back to topic. Analysis Office 2.8 SP3 is available almost over one week so let's look into it.

 

These bugs are fixed now:

  • #VALUE error for hierarchy leaves in SAPGetData in Fomula-optimized mode (s-note 2928899)
  • BAdI is not executed when launching (s-note 2923786)
  • Exception After Deleting an Excel Sheet (s-note 2907359)
  • Saving a workbook results in exception 0x800AC472 (s-note 2925165)

So its not much but after SAP released the standalone addin for SAP Analytics Cloud, they still working on Analysis for Office.

 

Read More 0 Comments

Analysis Office Video Course

Currently I am working on my Analysis Office Video Course. It will be a full discover of Analysis for Office. So if you are interested in it, you can join the list to get a special price when it will be launched. 

 

Thank you for all your support.

Read More 0 Comments

Analysis Office: Time Dependent Hierarchies

Read More 0 Comments

What's new in Analysis Office 2.8 SP2

After the latest service pack of Analysis Office 2.8 was released this week, the online help is now available. Analysis Office now offers a button for creating and deleting of comments in the ribbon menu. In former versions, SAP used the text of Microsoft Excel for comments. As Microsoft renamed the comments to notes, it was inconsistent in the ribbon and the context menu. Now it is consistently again.

 

Also new is the file system setting UseLegacyModeForFormulaContext which allows you to specify the mode for creating formulas with Table Design. And in the planning area there is a new setting called PlanningFunctionUploadFolder, which allows you to upload the values for executing planning objects from a file.

 

 

So it is nothing big, but Analysis Office is still developing and not dead, even if there is a new SAC Addin. I hope there will be some feature I submitted. 

Read More 0 Comments

SAP Transport Dependency Check

Read More 0 Comments

Analysis Office 2.8 SP2 is available

Since today the latest version of Analysis Office 2.8 (release notes) is available. You can download it with your s-user in the SAP Support Portal.  There are only a few fixes:

  • AO: BEx Analyzer Workbook Conversion - Not all filters of Text Element converted (s-note 2902130)
  • Chart Data Series are added again as Chart Data (s-note 2898931)
  • Exception thrown when the login process is interrupted (s-note 2900972)
  • Hierarchy selection disappears after confirming Filter Dialog in case of HANA (s-note 2897838)
Read More 0 Comments

Get Analysis Office - The Comprehensive Guide

If you want the latest edition of Analysis Office - The Comprehensive Guide, you can get it now with a 20% discount until easter 2020. Use the code Easter2020 in the online shop

 

If you want to read a review first, have a look at the review from Tammy Powlas or from Xavier Hacking. Tammys review is about the 3rd edition and Xaviers about the 1st edition.

 

If you have any questions or need any help, don't hesitate to contact me.

Read More 0 Comments

Analysis Office Dimension Grouping

Read More 0 Comments

Analysis Office Show medium text in prompt filter

Until now, we speak of Analysis Office 2.8, if you have different text maintained for an infoobject, Analysis Office shows only the short text in the prompt dialog. The maintenance view of the InfoObject shows all different texts.

Read More 0 Comments

Analysis Office - The Comprehensive Guide 5th edition is available

It is done, the latest version of my book Analysis Office - The Comprehensive Guide is available. It was a lot to do and so the book has now 346 pages. The 4th edition had only 299 pages. So there is some new stuff inside. The first 5 who contact me will get a promo discount code. Also I am happy if you want to write a review you get a review discount code. 

 

So you can buy it in the store. In future I will create more videos if there is any interest. So please leave a comment.

Read More 0 Comments