Blogs

Read below our blogs and updates on the latest technologies for data engineering, advanced analytics and data science.

Let’s turn your data into value. Book your call right here.

Knowledge sharing

Key Features of SAP Data Services Roadmap (2020 Q1 –2023 Q3)

In the world of data integration and management, both data connectivity and data quality play vital roles.  SAP Data Services is committed to constantly...

Read more

Authorization and Roles in SAP BW

In BW, users can access an InfoCube or a specific query, but it does not mean that they can also access all the data...

Read more

ESG – Reporting Standards Overview

ESG stands for Environmental, Social, and Governance. It is a set of criteria used to evaluate the sustainability and societal impact of a company....

Read more

Group Reporting: What is it and is SAP offering a solution?

Group reporting: You say what? Any company with one or more subsidiaries, has a need to combine all financial results. This combining of results...

Read more

Support that makes a difference

Welcome to the Intellus support blog! We offer expert support beyond analytical projects, helping customers with day-to-day tasks, ad-hoc requests, technical questions and small...

Read more

SAP Datasphere and its BW Bridge: a winning team

Hi there! Welcome to the third stage of our Tour of SAP Datasphere! During this stage we will be tackling a very exciting feature...

Read more

SAP Data Warehouse Cloud is now SAP Datasphere!

SAP has introduced SAP Datasphere as the successor to SAP Data Warehouse Cloud, with a range of new capabilities to improve data discovery, modeling,...

Read more

From meaningless to actionable: revive your data using Data Warehouse Cloud

Hi there! Welcome to the first stage of our Tour of Data Warehouse Cloud! These days it’s rather challenging to keep up with the...

Read more

Row level security with third-party reporting tools (Power BI) on SAP Data Warehouse Cloud

SAP Data Warehouse Cloud is a cloud tool that runs on a HANA database. Although native connectivity with SAP Analytics Cloud exists for reporting...

Read more

Tips for importing SAP BW objects from one system to another

It’s not common and recommended to work directly in a production environment. So, in most of your BW projects, you must import SAP BW...

Read more

5 Tips & Tricks for your Business Objects

Hi again, in this short article I’ll go over 5 functions of Business Objects I often used and think are worth spreading the word...

Read more

Atteignez un niveau d’analyse supérieur grâce à SAC Planning !

Atteignez un niveau d’analyse supérieur grâce à SAC Planning ! Sur base des données collectées au sein de leurs entreprises, les dirigeants sont chargés...

Read more

Pareto chart in SAP Analytics Cloud

Pareto chart in SAP Analytics Cloud In this blog we will explain you how we can create a Pareto chart in SAP Analytics Cloud...

Read more

Virtualizing your Azure Data Lake with SAP HANA

Organizations are looking for best-of-breed solutions to tackle data challenges. While lots of organizations are using SAP HANA for reporting and analyzing SAP ECC...

Read more

SAP BW (parent/child) hierarchies in Power BI

SAP BW (parent/child) hierarchies in Power BI Hierarchies are a very powerful concept in the world of data processing and visualization. For anyone working...

Read more

Get started with a FREE process discovery analysis of your SAP system

Get started with a FREE process discovery analysis of your SAP system Hello and welcome to this blog post on SAP Process Insights. In...

Read more

How to reuse a BW hierarchy in Calculation views and expose it to reporting ?

How to reuse a BW hierarchy in Calculation views and expose it to reporting ? Maybe you have tried in the past to advantage...

Read more

New Planning Area for Data Entry

New Planning Area for Data Entry In SAP Analytics Cloud, release 2021Q4 (2021.20.12) many new features were introduced. (https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2021.20/en- US/c96a267c5da04fff90bb55313ee9f77c.html One of these new...

Read more

Data Services Python Script Call

Data Services Python Script Call In the magical world of data extraction Data Services offers great out of the box functionality to extract data...

Read more

Automatic Lineage Reporting

Automatic Lineage Reporting Do you get these types of questions a lot? We’re changing something in ECC/APO/…, what’s the impact in BI?How many reports...

Read more

Through the looking glass, with Web Intelligence

Through the looking glass, with Web Intelligence Exactly two years, that’s the amount of time I’ve been working with Business Objects and more specifically...

Read more

Project management, keep it plain and simple

Project management, keep it plain and simple That project management plays a very useful role in IT related projects is nothing new. But what...

Read more

Comment créer une vue à partir d’une Cluster Table sur SAP

Comment créer une vue à partir d’une Cluster Table sur SAP Une table au niveau de la base de données peut parfois contenir de...

Read more

Advantages of using SAP Analytics Cloud for a Rolling forecast

Advantages of using SAP Analytics Cloud for a Rolling forecast What is a rolling forecast? A rolling forecast is a way of reporting that...

Read more

SAP BW BI Content Installation

SAP BW BI Content Installation What is Business Content? In the Business Warehouse context, SAP’s Business Content, is an accumulation of pre- defined and...

Read more

SAP Analytics Cloud: Open your story with a variable constraint via a URL

In SAP Analytics Cloud, you can create a story URL with additional parameters, like a variable constraint. This story URL can be useful for...

Read more

Apache Log4j Security Vulnerability impact on Java (CVE-2021-44228)

Apache Log4j Security Vulnerability impact on Java (CVE-2021-44228) Last week, a serious security breach was found with a Common Vulnerability Scoring rating of 10/10.This...

Read more

Working From Home: Tips & Tricks (Part II)

Working From Home: Tips & Tricks (Part II) Due to the prevalent pandemic and subsequent measures, many employees are forced to work from home...

Read more

Working From Home: Tips & Tricks (Part I)

Working From Home: Tips & Tricks (Part I) When COVID-19 came knocking onto our doors, most companies had to switch to work-from-home mode. While...

Read more

How to set up SAP Cloud Connector on Linux?

How to set up SAP Cloud Connector on Linux? First go to https://tools.hana.ondemand.com/#cloud and download the corresponding SCC, SAP_JVM and jco files.Put all of the files...

Read more

How to create an AMDP Routine in BW Transformations

What is AMDP ? ABAP-Managed Database Procedures is one of the recommended patterns for use in ABAP code optimization within the context of ABAP...

Read more

Geolocation setup

Geolocation Setup Prerequisites: HANA licensed for SAP HANA spatial HANA system has to be configured with a valid SRID (Spatial reference Identifier) HANA Live connection setup Dataset with...

Read more

Agfa

Agfa "For many years already, Agfa can rely on Cubis as its main analytics partner. Their knowledge and expertise in the field of SAP...

Read more

Barco

Barco Keeping the complex BW environment sync with future needs “Cubis has been a flexible and valuable partner in our analytics journeys. With the right...

Read more

Turning Data into Actionable Information

"The experience was very positive. Cubis was attentive to the specificities of our industry and ensured our support. Manuel Correira,CEO, VP Business Intelligence &...

Read more

Web Intelligence optimizations

Web Intelligence optimizations Central Management Console Retry failed schedules There is an option within the CMC that allows for a retry of the schedule...

Read more

OCR With Python

OCR With Python In many cases the data that you want to report on is already in a digital format.But what if that is...

Read more

Don’t kick Business Objects of its throne just yet!

Don't kick Business Objects of its throne just yet! IT changes constantly. Which makes it hard to follow and adapt to the new trends...

Read more

Your transport guide – SAP BW

Your transport guide – SAP BW Hey everyone,A couple of months ago I encountered a rather big task to perform at my customer.I had...

Read more

La méthodologie Scrum

La méthodologie Scrum L'agilité, c'est quoi ? L'Agile Manifesto a été créé pour rassembler un ensemble de valeurs et de principes permettant de définir...

Read more

XML With Python

XML With Python DOM (DOCUMENT OBJECT MODEL). We load the entire file in memory because then we can access the content like it’s an...

Read more

Let’s Encrypt [Part III]

Let's Encrypt [Part III] Using “Let’s Encrypt” certificates with SAP/HANA web dispatcher and XSA on an Azure deployment for SSL communication. _____________________________________________________________________________________________________________________________ In the...

Read more

Let’s Encrypt [Part II]

Let's Encrypt [Part II] Using “Let’s Encrypt” certificates with SAP/HANA web dispatcher and XSA on an Azure deployment for SSL communication. Note: this is the...

Read more

Let’s Encrypt [Part I]

Let's Encrypt [Part I] Using “Let’s Encrypt” certificates with SAP/HANA web dispatcher and XSA on an Azure deployment for SSL communication. _____________________________________________________________________________________ In our...

Read more

CREATING AN ODATA SERVICE WITHIN THE BW4/HANA APPLICATION LAYER [Part II]

CREATING AN ODATA SERVICE WITHIN THE BW4/HANA APPLICATION LAYER [Part II] Note: this is the second part of the blog. Missed the first part? Read...

Read more

CREATING AN ODATA SERVICE WITHIN THE BW4/HANA APPLICATION LAYER [Part I]

CREATING AN ODATA SERVICE WITHIN THE BW4/HANA APPLICATION LAYER [Part I] Project background In a recent project I did, the client wanted to expose...

Read more

SAP Datawarehouse Cloud [Part IV]

SAP Datawarehouse Cloud [Part IV] Governance & Architecture with SAP Datawarehouse Cloud ______________________________________________________ Note: This is the last part of the blog series.  If...

Read more

SAP Datawarehouse Cloud [Part III]

SAP Datawarehouse Cloud [Part III] Data Modeling in SAP Data Warehouse Cloud ________________________________________________________________ In previous blogs (Part I and Part II), we introduced SAP Data Warehouse...

Read more

SAP Data Warehouse Cloud [Part II]

SAP Data Warehouse Cloud [Part II] Spaces Within SAP Data Warehouse Cloud ____________________________________________________________ In our previous article, we discussed SAP Data Warehouse Cloud and its capabilities....

Read more

SAP Data Warehouse Cloud [PART I]

SAP Data Warehouse Cloud [PART I] An intro to SAP Data Warehouse Cloud ________________________________________________________ Introduction In these modern times, data is spread across different...

Read more

Downloading your email attachments in bulk using Python

I recently had to download the attachments from a few thousand emails that were sent to me by an automated process at my current...

Read more

L’utilisation des données dans le combat contre la COVID-19

L’utilisation des données dans le combat contre la COVID-19 S’il y a bien une chose que l’on retiendra de l’année 2020, c’est la pandémie...

Read more

Fetch SOAP web service call with deep structure in ABAP [Part III]

Fetch SOAP web service call with deep structure in ABAP [Part III] This will be the last article that concludes the blog about fetching...

Read more

Fetch SOAP web service call with deep structure in ABAP [Part II]

Fetch SOAP web service call with deep structure in ABAP [Part II] Below is my second article out of 3 for fetching web service...

Read more

Fetch SOAP webservice call with deep structure in ABAP [Part I]

Fetch SOAP webservice call with deep structure in ABAP [Part I] Here is a step by step guide on how I retrieve data from...

Read more

Use-case and value-driven implementation approach

Use-case and value-driven implementation approach Not the title you would expect in a Cubis blog? Think again! A BI implementation is only as powerful...

Read more

BODS – ETL Framework [Part II]

BODS – ETL Framework [Part II] Note: this is the second part of the blog. Missed the first part? Read it here. For the extraction...

Read more

BODS – ETL Framework [Part I]

BODS – ETL Framework [Part I] Requirements Each execution step in a job should be logged in a logging table Provide a delta and...

Read more

Consider your pods (Azure)

Consider your pods (Azure) Recently, we ran in some issues when doing training with several trainees on our SAP Datahub environment that is running...

Read more

2020 SAP COIL Hackathon winner: Cubis!

2020 SAP COIL Hackathon winner: Cubis! Last week a team from Cubis participated in the , organized by the - ( ). The event...

Read more

Passion meets project [Part II]

Passion meets project [Part II] Note: this is the second part of my article on sports, data and the link in between. Missed the...

Read more

Passion meets project [Part I]

Passion meets project [Part I] Foreword I'm curious, I like to write, I like basketball and I'm an IT-consultant specializing in SAP technology. Nothing...

Read more

Scheduling in SAP Analytics Cloud

Scheduling in SAP Analytics Cloud Many customers have asked for it, and finally, it is available in SAP Analytics Cloud: scheduling stories and dashboards...

Read more

Lancement officiel de Cubis Luxembourg

Le 1er Avril était la date du lancement officiel de Cubis Luxembourg. Cubis est spécialisée dans les solutions analytiques de SAP avec une position...

Read more

Managed Big Data: DataBricks, Spark as a Service

Managed Big Data: DataBricks, Spark as a Service The title accompanying this blog post is quite the mouth full. This blog post will explain...

Read more

Agile BI : A Scrum Adaptation (Part 1 & 2)

Agile BI : A Scrum Adaptation (Part 1 & 2) Agile BI : a SCRUM adaptation (part 1) At the end of the year,...

Read more

Embedded analytics, the end station for enterprise reporting?

Embedded analytics, the end station for enterprise reporting? At Cubis, we see an increasing number of customers starting to upgrade their R/3 or other...

Read more

Consuming S/4HANA CDS views in PowerBI

Consuming S/4HANA CDS views in PowerBI With ABAP Core Data Services, SAP S/4HANA provides us a very powerful way to model and consume the data which resides...

Read more

How to use Analysis Process Designer as an alternative for Open Hub.

How to use Analysis Process Designer as an alternative for Open Hub. Last year, our colleague Nico wrote a blog post on how to...

Read more

December 2020

December 2020 That is the deadline when you are running a BW version 7.4 or older. SAP will end the mainstream maintenance for older...

Read more

Making forums a better place

Making forums a better place Before starting my career in IT, I almost never went to online forums. However quickly after starting my career...

Read more

so.. SAP Lumira is dead.. now What ?

so.. SAP Lumira is dead.. now What ? As a consultant I’m responsible for the Analytics environment for an Innovative Company in Natural Chemistry...

Read more

Fetching XML API data

Fetching XML API data I recently finished a project for which I had to fetch public data of parking lots and load it to...

Read more

HANA optimizations to speedup queries

HANA optimizations to speedup queries Hi network, since September I’m working as an SAP Analytics consultant for Cubis. Since then I had two months to...

Read more

Take on the fight with Python

Take on the fight with Python Introduction If there is one thing common in everyone’s career than it is that at some point everyone...

Read more

Open Hub Destination with BEx Query as an InfoProvider

Introduction A SAP BW system is mostly known to consolidate data to give reporting or analytics capabilities to your business. However, there could be...

Read more

Getting started with SAP HANA SDI in less than a day

Getting started with SAP HANA SDI in less than a day This is part 2 of the series. Herein, we’ll cover dataflow creation within...

Read more

Getting started with SAP HANA SDI in less than a day

Getting started with SAP HANA SDI in less than a day (The Twitter case) – Part 1 I was recently asked by a client’s marketing department...

Read more

Cubis participates at the Chainport Hackaton

Cubis participates at the Chainport Hackaton From 11/10 to 13/10 Cubis will participate in the Chainport Hackaton at Antwerp Expo organised by Port of Antwerp. The Hackaton will focus...

Read more

BODS Data Extraction

BODS Data Extraction Loading data into a DWH can sometimes be a hassle. Defining your delta too. So let’s keep things simple. There are...

Read more

How SAP Analytics Cloud and BPC come together?

How SAP Analytics Cloud and BPC come together? In a SAP BPC standard environment, the main interface to input data is MS Excel. In...

Read more

SAP HANA views organised in layers

SAP HANA views organised in layers Getting structure in the new HANA environment is not as easy as it first seemed. It all started easy,...

Read more

Process chain (flows) optimization Part 3

Process chain (flows) optimization Part 3 This will be the last article about process chain optimization. In the previous article we covered the optimization...

Read more

Process chain (flows) optimization Part 2

Process chain (flows) optimization Part 2 In the previous article I did a small intro and showed you how to check if a process...

Read more

Process chain (flows) optimization Part 1

Process chain (flows) optimization Part 1 Following will be an article which is divided into 3pieces. First an introduction to what I do and...

Read more

Cubis Hacking MOTF18 door Simon Van Herck

Cubis Hacking MOTF18 door Simon Van Herck

Read more

Lumira 2.1 Discovery, a first glimpse

Lumira 2.1 Discovery, a first glimpse On Friday Dec 15th, SAP made Lumira 2.1 Discovery available for the general public. During the last few...

Read more

STIB-MIVB: How Business Intelligence Makes Public Transportation Smarter in Brussels

STIB-MIVB: How Business Intelligence Makes Public Transportation Smarter in Brussels Great movie about the analytics vision of the STIB_MIVB and the world premiere implementation...

Read more

Organizing a Business Intelligence department in a world of self-service

Organizing a Business Intelligence department in a world of self-service 27 november 2017 What do you get when asking 10 Cubis customers to fill...

Read more

Cubis releases the “text chart”​ extension for SAP Design Studio

Cubis releases the "text chart"​ extension for SAP Design Studio We are proud to announce that Cubis has released its first extension for SAP...

Read more

Cubis 5 year – Interview with Jeroen and Wim

Cubis 5 year - Interview with Jeroen and Wim On the occasion of our 5th anniversary Wim and Jeroen were interviewed in Magazine X...

Read more

Agfa-Gevaert NV as the Bronze Winner of the SAP quality awards supported by Cubis.

Agfa-Gevaert NV as the Bronze Winner of the SAP quality awards supported by Cubis. 04 september 2017 Congratulations to our customer Agfa-Gevaert NV for...

Read more

Giving back to the community: Cubis and Ganspoel

Giving back to the community: Cubis and Ganspoel At Cubis, we also believe in bringing added-value to the community, and we consider that one...

Read more

Cubis in Walldorf – BW4HANA Partner Testing

Yesterday, we headed off for a 5 hour drive from Antwerp to Walldorf (Germany) to participate in a BW4HANA Partner testing workshop. Walldorf probably...

Read more