arcplan facilitates the creation of standardized reports, which support (and thus make more efficient) the daily work of the employees of a business. In particular, this is the case if reports present the included data in a meaningful, concise and user-friendly manner. Large volumes of information are thus often structured and presented in the form of tables. In order to illustrate relations and/or hierarchies of data within the table and avoid redundancies, it is required to choose columns and line headings which, in addition, are supposed to be placed expediently.
Up to arcplan version 8.5, the merging of cells (a standard function in Excel) could not be conducted easily. Thus, table headings had to be displayed redundantly and summarizing was not possible.
From arcplan version 8.6, there is a simple possibility to merge cells vertically or horizontally. In order to do so, an instruction object is created which informs the table which cells are to be merged. The approach will now be demonstrated by an example.
A table is used as data basis, which is supposed to provide values for the cost centers, cost types and costs of a business.
In arcplan Version 8.5 and lower, a table based on this data could have been designed as follows:
By means of the new function "Merging Cells" in arcplan 8.6, a possible presentation in a table looks as follows:
Now, the table is more meaningful and more understandable. Below, the required steps for merging the cells are explained
First of all, a new table is created in which the cells, which are to be merged later, are still separated.
First, the vertical merging of the cells shall be demonstrated. For the vertical merging of the cells, the primary cell to be merged in the first step is represented by a 2 in the matrix. Cells below which shall be merged have to be characterized by a 1.
Now, the table has to be informed that the matrix contains the parameters for the merging. This is achieved by (in design mode): right click on the headline table -> "Format Object..." -> Tab "Cells" -> referencing the matrix as instruction object.
Thus, the first column is merged into one cell.
The horizontal connection of the cells in the first line could be achieved by the indices added in the following graphic:
For horizontal merging, the primary cell is marked by a 4 and the cells which are to be added to it are marked by a 3. The complete matrix and the complete headline table are set forth below:
The final result in arcplan 8.6 might look as follows:
arcplan Version 8.6 offers the possibility to merge cells within a table, column or line object. A matrix has to be created to this end and referenced as instruction object in the formatting of the object which includes the cells to be merged.
Primary cells are marked by a 2 in the matrix. The cells which are to be vertically merged with the primary cell are marked by a 1.
Primary cells are marked by a 4 in the matrix. The cells which are to be horizontally merged with the primary cell are marked by a 3.
Do you want to replace the IoT core with a multi-cloud solution and utilise the benefits of other IoT services from Azure or Amazon Web Services? Then get in touch with us and we will support you in the implementation with our expertise and the b.telligent partner network.
Domain Lead Insights & Information Design
With the new function REPLACEEXPRESSION, arcplan 7 affords the possibility to influence the automatically generated SQL and MDX statement. This has the benefit that a design can continue to be made with “arrows” and that one is not limited to formulas. Currently, only simple adjustments of the query are possible with this tool; however, there is a large impact on the resulting possibilities.
With the Q2 2023 updated titled "New optimized story experience - unified strories and applications", SAP analytics cloud offers users new ways to develop reports and dashboards even more flexibly and easily in an integrated design enviroment. We'll showyou which new features theupdate provides and how it supports you in creating reports,
As a business intelligence package, SAP BW provides many opportunities for efficient reporting – but also contains numerous barriers which significantly slow down performance. Using the example of report filters available in the application, this article shows how the smallest adaptations impair SAP BW performance, and how efficient settings for filtering options can improve results.
No previous post
No next post
