Please explain what transitive attributes are, and in which scenario we should use them.
A transitive attribute is really an "attribute of an attribute" or a "second level attribute". For example, an InfoProvider has an InfoObject and a CostCenter, which has a navigational attribute of a CompanyCode, which in turn has its own attribute of the company. Transitive attributes are defined as display attributes. The company is the transitive attribute that you could make a navigational attribute.
Dig Deeper on SAP Business Warehouse
Learn some potential interview questions for a position in SAP BW from BW reporting expert Peter Scott.
Is it possible to change the cube used by a BW query? We have a number of identical cubes representing a quarter's history data. Rather than build a ...