Question:
Hi!
I have a problem with creating an infoset. The Infoobject I want to join from the ODS is a navigation attribute. The navigation attribute is not available in the infoset to join (even if itīs activated in the ODS).
Do anyone know if itīs possible to join navigation attriubtes in an infoset, and how to do it?
Best Regards
Charlotta
Answer:
This is not directly possible, bt the workaround is obvious.
Let's say your ODS has 0CUSTOMER in it, you have flagged 0CITY as attribute and you want to connect this to the attribute 0COUNTRY of 0CITY. (just theoretical example off course)
You cannot connect the ODs directly to the 0CITY MD-table, but you'll have to put the 0CUSTOMER table in between manually yourself.
So connect 0CUSTOMER from the ODS to the 0CUSTOMER MD table (on the key). Then connect the 0CITY from the 0CUSTOMER table to the CITY MD table (on the key). Then from this table flag 0COUNTRY and it will be available in the query