What is Line Item Dimension?
Hi Anshul, Line item: This means the dimension contains precisely one characteristic. This means that the system does not create a dimension table. Instead, the SID table of the characteristic takes on the role of dimension table. Ex: Purchase Document Number in one dimension is Purchase Cube.
What is Line Item Dimension in sap bw?
SAP BW provides the possibility to identify such a dimension as a ‘line item dimension’. This means that the dimension only contains one InfoObject (for example: Document number) and that no physical dimension table is generated, instead, the fact table is directly linked to the SID table of this InfoObject.
What is line item dimension and high cardinality?
Different index types are used than is normally the case. A general rule is that a dimension has a high cardinality when the number of dimension entries is at least 20% of the fact table entries.
What is high cardinality in SAP?
The High Cardinality property allows you to create more than two thousand million characteristic attributes for a characteristic. As a characteristic with high cardinality has a number of restrictions, you should only set this property if you really expect a larger number of characteristic attributes.
What is high cardinality in SAP bw4hana?
Why high cardinality is a problem?
In particular, time series high cardinality is a common problem in industrial IoT (e.g., manufacturing, oil and gas, utilities, etc.), as well as some monitoring and event data workloads. High cardinality is also a topic that developers end up discussing a lot, and there’s often a lot of questions around it.
What is cardinality in SAP HANA?
SAP HANA features like Calculation Views and CDS allow to specify the cardinality for joins to improve the performance of the execution. The cardinality specifies the number of rows which are matching another table if these tables are joined. With SPS04, this feature is also possible in plain SQL.
When can you not use a characteristic with the high cardinality property?
A characteristic with high cardinality has no persistent SID values and no SID table. This kind of characteristic can therefore only be used in InfoProviders that store the key instead of the SID value of the characteristics it contains.
How is an infocube assigned to a dimensional table?
The technical name of the dimensional table is assigned by the system, using the pattern /BIC/ “D #”, where the first # will be a1, the second a 2, and so on. Characteristics Infoobjects can be freely added to customer-created dimensions.
What is the structure of an infocube in bi?
InfoCube Structure: An Infocube follows the Extended Star Schema. It has Fact table at the center and is surrounded by 16 dimension tables with Master data lying outside the cube. Infocubes are the central multidimensional data model in BI. It is a self-enclosed data set encompassing one or more related business processes.
How to mark a dimension as a line item?
If you’re used to data modelling in BW you know that it’s recommended not to have that many distinct values in the dimensions and if it cannot be avoided then the dimension should be marked as line item dimension. This can be done in the Infocube modelling in transaction RSA1 by right-clicking on the dimension and opening the properties dialogue.
How is performance gain gained from a partitioned infocube?
The performance gain is only gained for the partitioned InfoCube if the time dimension of the InfoCube is consistent. This means that all values of the 0CAL* characteristics of a data record in the time dimension must fit each other with a partitioning via 0CALMONTH.