Knowledge base

Anaplan

Anaplan is a web-based enterprise platform for business planning, budgeting and forecasting. Anaplan is also the name of the company that created the platform.

Dimanche, 22 mars 2015

Implementing BAdI’s for SAP BPC - Tips & Tricks

This article combines several tips & tricks that will help you creating SAP BPC implementations.

Vendredi, 20 mars 2015

Automate your ETL testing and deliver quicker and better results

Testing ETL projects - used for Extracting data, Transforming it according to reporting requirements and Loading it into the data warehouse - is very complex because of many reasons. Typically huge amounts of data are handled and data comes often from multiple sources that need to be combined. Sometimes, the data is loaded incrementally, sometimes it needs to be reloaded in full. These ETL-flows can also apply all kinds of complex calculations and transformations on the data.

Mercredi, 25 février 2015

SAP’s EPM offer, a comparison of SAP BPC and BFC

This article will focus on the differentiators and similarities of BPC and BFC so that the reader gains a better insight into SAP’s EPM offer.

Mardi, 11 novembre 2014

Master Data Management (MDM) : Architecture & Technology

Introduction Go to Google and type in the words "Why do BI projects fail ?".

Vendredi, 17 octobre 2014

Recommended books

Performance Management: Van Prestatiemeting naar prestatiemanagement door de toepassing van analytische intelligentie

Dit recent gepubliceerd boek biedt een bijzonder volledig overzicht van de materie van Performance

Mercredi, 20 août 2014

SAP BW InfoProvider

There are different objects available in SAP BW for reporting, which can all be described as InfoProviders because they are holding and providing information to the end user of SAP Business Intelligence. Examples of InfoProviders are: MultiProvider, InfoCube, DataStore Object, InfoObject, InfoSet, …

Jeudi, 7 août 2014

Microsoft SQL Server Reporting Services Configuration Manager

The Reporting Services Configuration Manager is used to configure your Reporting Services installation if it is set to ‘Native Mode'.This configuration is necessary to get your reporting environment up-and-running. The Configuration Manager is used to configure the Report Server service account, create and configure the report server database, create and configure the Report Manager and Report Server URL's, configure server mail settings, etc.

Jeudi, 7 août 2014

Microsoft SQL Server Database Engine Tuning Advisor

The Microsoft SQL Server Database Engine Tuning Advisor helps you to optimize database configuration by identifying an optimal set of indexes, indexed views and partitions without requiring an expert understanding of the database structure. It advises you by analyzing a certain workload by using trace files, trace tables or T-SQL scripts as input.The Database Engine Tuning Advisor will then give you certain recommendations to add, remove or modify certain settings in your Microsoft SQL Server database.

Jeudi, 7 août 2014

Microsoft SQL Server Profiler

The SQL Server Profiler is a graphical user interface for monitoring an instance of the database engine or Analysis Services. Data about each event can be captured and saved to a file or table so they can be analyzed later. It can be used to monitor performance of your database and identify slow performing queries or stored procedures.

Jeudi, 7 août 2014