BW-MT Transformation lookup rule with compounded objects

[lechnmic]

when editing a transformation which contain a lookup rule for compounded objects, the compounding field disappears after saving TRFN in eclipse and can only be added by re-creating the lookup rule.

Has anybody an better solution?

[roland_szajko]

I don't have this problem. The compounding/key mapping is available:

Are you using the latest BW Modeling Tool version?

[lechnmic]

we are using BW-MT 1.25.42 with an BW/4 2021 backend

[lechnmic]

we changed a keyfigure to SUM and the Currency 0LOC_CURRENCY we get from a compound infoobject. The change of the keyfigure break the lookup of the compound infoobject

[roland_szajko]

I don't see how a key figure is related to an MD Lookup rule. The MD Lookup is to be used to read an attribute of a characteristic based on the specific key values. Please explain the scenario in detail with screenshots.

[tobias_stadelmann]

The mentioned issue from lechnmic still exists in our system using BW-MT 1.26.15.

Difference to your Scenario @roland_szajko :
Source fields are field-based, only target fields are InfoObjects.

Original Scenario:

After saving and activating the transformation closing + reopening it, first the icon of compounding Object MSOURCE changes.
In original mainteanance it's correctly displayed with the IOBJ icon, now as field based icon even though in datatarget it's an IOBJ.

Then aggegation behaviour of MCONVALUE is changed, ->save and activate TRFN.

Suddenly error message appears:

Characteristic MSOURCE compounded to SSALESORG is missing in transformation source

Message no. RSTRAN075

Now, in the lookup rule for 0LOC_CURRCY the source field MSOURCE disappears  and the mapping became inconsistent.

Unfortunately SAP wasn't able to provide a fix since September 2024.
Case 990054/2024 - BW4HANA 2021 - inconsistent handling of HANA TRFN Lookup rules in BW-MT 1.25.42 -...

[roland_szajko]

According the referenced incident, the problem is, that the source is field based and in the BW MT TRFN editor it is not possible to create "InboObject Assignments". The workaround is to delete the rule and recreate it, if the aggregation behavior of the Key Figure needs to be changed. As far I can see, this was categorized as a feature request.