Insights & Information Design

During selection of a connection type, several aspects must be considered. Find out here which these are, and which scenarios can be covered with the various connections.

Through creation of analytic applications, SAP Analytics Cloud makes it possible to produce complex reporting scenarios for customers. A building block which decisively complements this function is custom widgets which allow quick and unser-centred creation of visualizations. Here we will show you how to create these and embed them in an SAC application.

The topic of planning is often left out of the definition of a data strategy. Planning is perceived as "too special" because it is strongly departmental, existing concepts can only be applied to a limited extent for planning, and the employed BI tools are often unsuitable for planning. As a result, potential remains untapped. This blog shows how you can fix this, even retroactively.

Power BI from Microsoft is a versatile, intuitive, and therefore widely used data visualization tool. But other software manufacturers are also making a name for themselves in the data evaluation market. One of them is Tableau. As an experienced Power BI developer, I was recently able to try my luck with Tableau for a customer. I would like to share the results with you in the following blog post.

Do you want to prepare a Power BI report, but the data quantity is too large to even start creating visuals? Or you've actually managed to prepare the report based on such data, but Power BI desktop keeps seizing up? Or the report takes forever to be published? You're not alone here. We will therefore next provide a few tips which are easy to implement.

arcplan offers a number of possibilities to set up a classic V-Lookup, as it is often used in Excel. One of these possibilities can be found under the blog entry Tips & Tricks: The Repeat Loop as Performance Killer.

The method described here works via the cross product of two tables and, as bulk operation,  constitutes a “Left Outer Join”, while the intersection constitutes an “Inner Join”.

Increasingly frequently, Power BI is used not only as a self-service tool, but also forms the basis of operationalized analytics applications at many internationally active companies and even in the B2B sector. This, in particular, requires Power BI reports to be displayed in multiple languages. Here you have to decide: Do I create one report per language or try to make my report filterable by language? This article considers the latter approach.

An important building block for a planning system comprises dealing with intercompany (IC) issues. IC comes into play whenever different economic entities of a group of enterprises exchange goods or services with each other. The resulting expenditures and earnings, as well as receivables and payables must be transparent and definable with respect to each other. Because planning is performed by numerous participants, IC coordination and subsequent IC elimination are not trivial.

For specific use cases such as the contribution margin schema, it makes sense to display key figures in a dimension table instead of the classic fact table. This article describes characteristic features and a method of implementation in Power BI.