GET 65% Discount on All Products Coupon code: "bigdisc65"
Which modeling decisions may have side effects on runtime performance?Note: There are 3 correct answers to this question.
Use a transitive attribute instead of an attribute that is directly assigned to a characteristic.
Uncheck the "Write change log" property for a Stard DataStore Object.
Move a characteristic within a DataMart DataStore object to a different group.
Change a time-independent attribute of a characteristic to a time-dependent attribute.
Include a characteristic from the underlying DataMart DataStore Object in the CompositeProvider instead of a navigation attribute.
Transitive Attribute (Answer A):
Using transitive attributes introduces additional joins in queries, increasing complexity and affecting performance.
Disabling Change Log (Answer B):
Unchecking the change log property can improve load performance but risks losing data change tracking, which may affect downstream reporting.
Include Characteristics Directly (Answer E):
Including a characteristic from the underlying DataMart DataStore object reduces runtime overhead compared to navigating attributes indirectly.
Move Characteristics (Option C):Moving characteristics within a DataStore object has minimal impact on performance.
Time-Dependent Attribute (Option D):Changing attributes to time-dependent adds metadata but does not significantly affect runtime performance.
Incorrect Options:References:
SAP BW/4HANA Performance Optimization Guide
TESTED 22 Jan 2025
