Blogs
Read below our blogs and updates on the latest technologies for data engineering, advanced analytics and data science.
Knowledge sharing
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 moreESG – 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 moreGroup 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 moreSupport 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 moreSAP 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 moreSAP 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 moreFrom 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 moreRow 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 moreTips 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 more5 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 moreAtteignez 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 morePareto 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 moreVirtualizing 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 moreSAP 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 moreGet 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 moreHow 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 moreNew 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 moreData 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 moreAutomatic 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 moreThrough 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 moreProject 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 moreComment 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 moreAdvantages 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 moreSAP 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 moreSAP Analytics Cloud: Open your story with a variable constraint via a URL
SAP Analytics Cloud: Open your story with a variable constraint via a URL In SAP Analytics Cloud, you can create a story URL with...
Read moreApache 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 moreWorking 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 moreWorking 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 moreHow 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 moreHow to create an AMDP Routine in BW Transformations
How to create an AMDP Routine in BW Transformations What is AMDP ? ABAP-Managed Database Procedures is one of the recommended patterns for use...
Read moreGeolocation 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 moreTurning 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 moreWeb 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 moreOCR 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 moreDon’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 moreYour 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 moreLa 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 moreXML 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 moreLet’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 moreLet’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 moreLet’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 moreCREATING 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 moreCREATING 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 moreSAP 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 moreSAP 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 moreSAP 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 moreSAP 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 moreDownloading 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 moreL’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 moreFetch 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 moreFetch 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 moreFetch 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 moreUse-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 moreBODS – 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 moreBODS – 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 moreConsider 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 more2020 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 morePassion 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 morePassion 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 moreScheduling 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 moreLancement 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 moreManaged 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 moreAgile 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 moreEmbedded 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 moreConsuming 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 moreHow 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 moreDecember 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 moreMaking 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 moreso.. 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 moreFetching 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 moreHANA 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 moreTake 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 moreOpen Hub Destination with BEx Query as an InfoProvider
Open Hub Destination with BEx Query as an InfoProvider Introduction A SAP BW system is mostly known to consolidate data to give reporting or...
Read moreGetting 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 moreGetting 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 moreCubis 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 moreBODS 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 moreHow 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 moreSAP 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 moreProcess 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 moreProcess 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 moreProcess 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 moreLumira 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 moreSTIB-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 moreOrganizing 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 moreCubis 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 moreCubis 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 moreAgfa-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 moreGiving 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 moreCubis 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