Infrastructure at your Service

All posts by Matthieu Munch

Matthieu Munch
Consultant

Matthieu Munch has more than 17 years of experience in business intelligence consulting and project management. He is specialized in business analysis, business intelligence reporting, and data warehouse design based on technologies such as SAP Business Objects and QlikView. Matthieu Munch is "Business Objects certified Trainer". Prior to joining dbi services, Matthieu Munch was Business Intelligence Consultant and Project Manager at Sogeti in Basel. He also worked as a Business Intelligence Consultant and Project Manager at IFS in Pfastatt, France. Matthieu Munch holds a diploma in business administration and a diploma in European marketing studies from France. His branch-related experience covers the defense & machine industry, the energy sector, transport & logistics, automotive, etc.
Matthieu Munch

Oracle Data Integrator – The EL-T tool from Oracle

By | Business Intelligence | One Comment

Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful and that allows the integration of data coming from another sources.  Agility of use Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. Here is an example of…

Read More
Matthieu Munch

QlikView Tips & Tricks: The Link Table

By | Business Intelligence | No Comments

In this blog, I will show you how to bypass a “Synthetic Key” table in QlickView. Why bypassing a “Synthetic Key” table? If you have multiples links between two tables, QlikView generates automatically a “Synthetic Key” table. (here “$Syn 1” table). The QlikView best practice recommend to remove such kind of key table for a question of performance and “correctness” of the result. How to bypass this “Synthetic key” table? The “Link Table” is the…

Read More
Matthieu Munch

SAP HANA SQL scripting optimization: the CE Functions

By | Development & Performance | 3 Comments

In SAP HANA, you have two possibilities to create the Calculated Views: Using the graphical method Using the scripting method with CE functions In this blog, I will demonstrate that CE Functions can improve performances from a Calculated View. First, I will give you some general information regarding the CE Functions. After that, I will show you the two different ways to create a Calculated View. And at the end, I will compare their performances…

Read More
Matthieu Munch

Row Store vs Column Store in SAP HANA

By | Development & Performance | One Comment

The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two kind of tests, I will show you that the Row Store mode should be used for simple SELECT SQL queries, without aggregation and the Column Store mode should be used for complex SELECT queries, containing…

Read More
Matthieu Munch

QlikView – Load data in QlikView / QlikSence – Best practice and trick

By | Entreprise content management | No Comments

In this blog, I will give you some best practices and tricks when you are loading table to generate your data. But before, I will review the different ways to load data in a QlikView or QlikSense report. 1.How to retrieve data in QlikView You have 2 different possibilities to load your data in your report: Database connector File connector a) Database connector: If your data are located in a database, you must use this…

Read More
Matthieu Munch

QlikSense – The easy way to create a QlikView report

By | Entreprise content management | No Comments

Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years. To make Business Intelligence even more accessible to Business users, the Qlik Company decided to add an additional product in its range. This product should be more accessible and easier to use to create…

Read More
Matthieu Munch

Birst: an attractive “all-in-one” Business Intelligence solution

By | Entreprise content management | 2 Comments

The review of the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms has revealed a new challenger that could become one of the leader of this market: Birst – an interesting “all-in-one” BI solution. Birst is an american company based in the Silicon Valley near San Francisco. Its SaaS (Software as a Service) BI solution mixes simplicity and power. Just a little reminder before going forward: a complete Business Intelligence solution has two kind…

Read More