The following features have been optionally available in SAP BW on Microsoft SQL Server for several years:
The impact of these features is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-.... Customer experience showed, that using these features almost always resulted in BW query performance improvements. Therefore, these features are turned on by default after applying SAP Note 2582158 - Make Columnstore and Flat Cube default .
Flat Cube became default only on SQL Server 2016 and newer:
A new cube will be created as a Flat Cube if you mark the checkbox "Flat InfoCube".
The default value of this checkbox has been changed. It is now turned on. You can revert to the old behavior by setting the following RSADMIN parameter (In this case, only the default setting of the checkbox changes):
A Flat Cube always has a columnstore index. You can choose the Flat option in combination with the RealTime option. Keep in mind, that you cannot create aggregates on a Flat Cube.
The flat property of a BW cube can be transported from an SAP source system to an SAP target system once you have applied SAP Note 2550929 - Inconsistent metadata in case of transport of flat cubes non HANA landscape . A Flat Cube in the source system will be created as a Flat Cube in the target system. A non-flat cube will be created as non-flat in the target system. However, the flat property is not changed in the target system when transporting a cube, if the cube already exists in the target system and is not empty (means, the fact tables contain data).
The procedure of converting a cube to a Flat Cube is described in SAP Note 2116639 - SQL Server Columnstore Documentation:
Keep in mind, that an automatic conversion to Flat Cube during an R3load based system copy or database migration is not possible. You have to convert the cubes after the database migration on the target system.
Since the conversion to Flat Cube can be very time-consuming, you often do not want to perform this on all your cubes. You may want to start using the Flat Cube for your most important cubes. For all non-flat cubes you should at least apply the Columnstore (which is a quite fast and simple operation). A Flat Cube always uses the Columnstore.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.