SAP BO Analysis Automation
Intro SAP BO Analysis for Office is an Excel add-in from SAP. And like any good Excel add-in, it has API, which allows to use VBA macros to execute certain methods of add-in. Main purpose of this add-in is to…
Search Results for: sap
Bulk extract data from SAP Business ByDesign
Post describes how Power Query (Get & Transform) can be used as ETL tool for SAP Business ByDesign (SAP ByD). Purely Self-Service BI solution built on Excel for SAP Business ByDesign (SAP ByD). Level: Advanced How to extract master and…
SAP ByDesign + Power BI = cloud friends
In this post you will find an idea how to pull data from SAP ByDesign directly to Power BI. This is a totally self-service solution, which can be built if you have literally nothing. Only you, Excel, free license of…
Several ways of data extraction from SAP Business ByDesign
There are several reasons to extract data from corporate ERP system. First one and the most important – reporting. Nicely visualized data, usually pre-calculated using specific logic before. We all want to see beautiful reports. Second, I think, is a…
Query SAP Business ByDesign Web Services via Power Query
In this post I would like to share my experience about work with web services using Power Query. Unfortunately, some very important information is not available in data sources, e.g. Accounts Relationships and Pricing Conditions (price lists, customer specific discount lists…
Dynamic Table Headers in Power Query (SAP ByDesign, Odata)
Another good example of how awesome is Power Query. And again I reference to one of well-known bloggers, Ken Puls’s post describes situation when we have pivoted data and need to unpivot them then rename columns. Fortunalety, in this example…
Reporting and modeling for SAP Business ByDesign vol.2
In previous post I described list of ways of data extraction from SAP ByD. Here I continue story about case “ByD to Excel” using SAP ByD Excel add-in. Currently, I use version 135.0.2109.722 of SAP ByD addin for Excel In name…
Reporting and modeling for SAP Business ByDesign
Last two years I closely was working with SAP Business ByDesign reporting area. Have built data sources, web / Excel-based reports, models, print forms, broadcasts etc. In my responsibility six productive tenants: three of them in Baltics (Latvia, Lithuania, Estonia)…
Big cake for BI-day
No, it is not another birthday of PowerBI :-). It is me turned 31 today. Every year my wife bakes a cake for my colleagues on my birthday. And every year “birthday, b-day, bi-day, BondarenkoIvan-day” cake for colleagues is decorated…
Combination of rows of tables list in Power Query
Recently I faced interesting Power Query problem. Actually, initial problem has nothing related to Power Query. I required to export quite big volume of data from SAP BW using Business Objects Analysis addin (BO Analysis, or BOA) and save as…
Ivan Bond's blog 