blog.

In the last post I wrote about authorizations in SAP Data Warehouse Cloud and I had an open topic about authorization on hierarchy nodes in SAP DWC. So I looked into and here is one example of how it could work at the moment. I don't know if SAP changes something in future releases.

So let us started with a CSV file to create our authorization we can use in the SAP Data Warehouse Cloud. I would now authorize my user to a Product Category because my hierarchy looks like this:

• Product Category 01
• • Product 1
  • Product 2
• Product Category 02
• • Product 3
  • Product 4

So we have the same structure as in the last post:

In this blog post I want to show you how you can use data authorizations in SAP Data Warehouse Cloud. First, we have to log on to our SAP DWC and select the space we want to use for this.

After we have selected our space, we open the Data Builder of SAP Data Warehouse Cloud. Here we have to import a new table with our authorizations. In my case we want to filter the Product ID so the table looks like this:

Someone ask me how you could create a time hierarchy in SAP Data Warehouse Cloud (DWC) to use it in SAP Analytics Cloud (SAC). Because out of the box by just create the time dimension it isn't working right now. So here are the steps you have to make.

In BW/4HANA SAP offers you the possiblity to link restricted or calculated keyfigures accross different Composite Providers. The advantage of the link components concept is that they can automatically synchronized whenever you make changes in the source or master component. If you are not familiar with this concept.

SAP Help:

"A linked component can be automatically synchronized whenever changes are made to the corresponding source component.

Example scenario: You have two highly similar InfoProviders, IP_A and IP_B. You have created the query Q_A for IP_A. You now want to create the query Q_B for InfoProvider IP_B. You want this query to be very similar to query Q_A and to be automatically adjusted whenever changes are made to query Q_A.

To do this, you use the link component concept: You create the linked target query Q_B for source query Q_A. This is more than just a copy, as the system also retains the mapping information. This mapping information makes it possible to synchronize the queries."

So the concept is really nice because you can ensure that your keyfigures with the same name has also the same configuration, e.g. your turnover is configured correctly on any Composite Provider in your system. Now lets create a new link component. First we select a restricted keyfigure on our Composite Provider and goto "Linked Component" view in Eclipse.

Last week a collegue and I look into the XXL InfoObjects in SAP BW/4HANA. We searched the online help and there is a short video about the topic. But after that we had no clue how we can use it. Can we use it in Analysis for Office? Or just in the query or Composite Provider? What is the purpose of these InfoObjects? Can we store a documentation and open it directly from the query?

So I build an example XXL InfoObject and added it as a XXL Attribute to an InfoObject. This InfoObject was in my Composite Provider so I looked into the Composite Provider with Analysis for Office and don't see the XXL InfoObject. So we are back to start. What can I do with it? Now I asked around on twitter. And I was suprised about the answers.

Since last friday the latest version of SAP Analysis for Office is now available. You can download it in the SAP Launchpad. As the last version we have some bugs which are now hopefully fixed:

• All crosstabs are removed from workbook (s-note 2990456)
• Date picker control using wrong calendar or chosen date is incorrect (s-note 2981896)
• Exception when saving a workbook with a chart sheet (s-note 2981234)
• Search result does not show translated texts (s-note 2977530)
• Planning sequence execution uses wrong variable values (s-note 2975399)
• Excel hangs after copy and paste as Worksheet object (s-note 2974961)
• Non-SAP worksheet cell referencing SAP Crosstab cell changes its number format (s-note 2974435)
• AO: SAC - Unsupported S/4HANA Cloud connections are listed in Live Data Connections overview (s-note 2973887)
• [a42d-4b73-7e] ServerGroup and SNC Information are Missing When Used Analysis Office Recent List (s-note 2972745)
• Input has invalid format error when using exponential / scientific notation in new lines (s-note 2971200)
• The Chart has empty data series or categories after swap crosstab axes or data refresh (s-note 2970169)
• Suppressing all messages (s-note 2970000)
• Refresh All button is disabled for AO workbook (s-note 2969805)
• Incorrect sort order of BW systems in Replace System dialog (s-note 2968291)
• Error [3291-74de-1b] when using Excel with Traditional Chinese or ClientLanguage is set to "ZF" (s-note 2967800)
• Opening a workbook from BIP results in a nested exception [1b72-be52-de] (s-note 2967546)
• Exception when using an embedded sheet in Word (s-note 2966861)
• Saving a workbook results in a nested exception [e525-fb53-d4] (s-note 2966368)
• Symbols of the Conditional Formatting are not removed (s-note 2966312)
• SAC Logon Error in Analysis Office - No connection to system INA_SAC (s-note 2964461)

The online help of SAP Analysis for Office is not updated yet. A lot of s-notes for a Service Pack 6. I had some issues when I refresh my data source with the last version, I hope this will be fixed now. Do you have any problems with Analysis Office?

At the end of last month I ask on Twitter why I should create a join between an Advanced DataStoreObject and an InfoObject to read the attributes from this InfoObject when I even can activate the attributes on the output tab of the Composite Provider in SAP BW/4HANA. The answers on twitter was not satisfactory and I ask a collegue if he knew a reason. So i build a Composite Provider with a join between an InfoObject and an ADSO in our BW/4HANA system.

Since a couple of days the latest version of Analysis for Office 2.8 is available. Michael was a little bit faster and notice it on twitter before me. So let's look into it. SAP fixes a bunch of bugs with this service pack. Here is an overview:

• AO 4 SAC: \"Group Members\" functionality not available when using BW Live Data Connections (s-note 2962476)
• AO: BEx Workbook Conversion - An exception occurs when trying to save a converted BEx workbook which contains formulas (s-note 2965890)
• Action has been cancelled due to invalid input values (s-note 2958731)
• Analysis for office responds slow in AO 2.8 (s-note 2966651)
• BIP Logon Issues (s-note 2976169)
• BIP OLAP Connection targeting another system (s-note 2972912)
• BIP Workbook fails to save back to the platform (s-note 2963966)
• Error [3291-74de-1b] when using Excel with Traditional Chinese or ClientLanguage is set to \"ZF\" (s-note 2967800)
• Exception when the Number of NewLines is set to 0 (s-note 2961082)
• Exception when using an embedded sheet in Word (s-note 2966861)
• Filter Dialog - Change state of Tree Node if its text was clicked (s-note 2938903)
• Input has invalid format error when using exponential / scientific notation in new lines (s-note 2971200)
• Insecure Connection Message with BIP OLAP (s-note 2967910)
• New Lines - F4 help does not display member of respective cell (s-note 2963872)
• Refresh All button is disabled for AO workbook (s-note 2969805)
• Refresh Workbook with BIP OLAP SSO Connection Fails in Analysis Office (s-note 2957833)
• SAC Logon Error in Analysis Office - No connection to system INA_SAC (s-note 2964461)
• SAP Formulas in Scheduled Workbooks are Displayed as #NAME? in Excel (s-note 2765716)
• Saving a workbook results in a nested exception [e525-fb53-d4] (s-note 2966368)

A lot of s-notes for a Service Pack 5. I hope Analysis for Office will get a stable version again. Do you have any problems with Analysis Office?

Open ODS are a long time available in SAP NetWeaver BW. You can access directly database tables, database views or BW/4HANA DataSources (for direct access). In this blog post I want to look into the fast and agile modeling with Open ODS Views. So we start with a flat file we for example received from our customer to build a new data flow for reporting. The file has the following strucutre:

• Country
• Product
• Business Category
• Controlling Area
• Profit Center
• Month
• Year
• Amount

I created a test file with 10.000.000 entries to get some data we can play with. Now we create based on this file a data source to import the data.

I lately looked deeper into the modeling of Composite Provider in BW/4HANA 2.0 and found some difference between a BW/4HANA 1.0, BWonHANA 7.50 and the latest version BW/4HANA 2.0. So let's compare them and see what's new and we can go deeper in further posts. We start with the context menu of the scenario for the provider.

Last week I ask on twitter if anybody knows a good strategy to get all sources of a SAP HANA Calculation View (CV). I got different answers I want to share with you. One approache is really faszinating.

Does anyone know how I get a list of source tables of a calculation view? Is there any table where this information is stored like the normal #BW rsz tables?

— Tobias (@reyemsaibot) September 22, 2020

You have different ways to store the logic of your customer exit variables in SAP BW/4HANA. 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. This is how the table will look like:

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.

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.

The modeling objects which are left should know everybody. You have only these items to build your data model:

• InfoObject
• Advanced DataStore Object (ADSO)
• InfoSource
• CompositeProvider
• Open ODS View

This is it. And I think that is what @m_cubillos_o mean with "is really easier and faster to model?" Yes of course you have different options for an ADSO to model:

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.

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.

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.

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. 

The SAP Transport Dependency Check (TDC) is a little tool that helps you to find corresponding transport requests in your SAP NetWeaver Business Warehouse  which are not imported yet in your target system (e.g. production system). First you have to enter a transport request you want to check and also a target system and the last considered date (e.g. last go live).