Use of Line Item Dimensions and Monitoring tools
{"Image DocumentName": "Use of Line Item Dimensions and Monitoring tools", "Image ImageDescription": "Line item dimensions are basically fields that are transaction oriented. Once flagged as a \u2018line item dimension\u2019, the field is actually stored in the fact table and have no table joins. The results is significant improvements to query speeds (10%-15%) Programs that can help you monitor the system design: SAP_ANALYZE_ALL_INFOCUBES. ANALYZE_RSZ_TABLES. SAP_INFOCUBE_DESIGNS. Explore the use line item dimensions for fields that are frequently conditioned in queries. This model change can yield faster queries. 15.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}