How a BW consultant may determine type of objects in report?

[former_member319289]

How a BW consultant may determine that they want to use Plant Hierarchy or Plant attribute or Normal Info objects t in a report if they want region also in the same report?

[kohesco · Accepted solution]

1. is there a need for a hierarchy, if yes -> hierarchy
2. is there a need for a hierarchy, if no -> attributes or infoobject
3. is 0plant frequently used in report or not (if not -> attributes -> else infoobject in cube if it is possible, see next)

now it is complicated to choose between attr or infooject

1. how is the TD loaded (is plant already available in TD?).
2. if step 1 is okay, no issues there, we can check if it's possible to add 0plant directly in the infocube via -dimension/facttable check SAP_INFOCUBE_DESIGNS (SE38) you can check whether the cube can handle an extra infoobject.

performance wise: directly in cube > attributes > hierarchy

[former_member319289 · Accepted solution]

Thank you