Hi all,
I have a DF which is joining more than one table using join condition.I want to find out the Metadata table where this joing info is stored.
Please let me know asap.Thanks in Advacne.
thanks,
asu
Pasif (BOB member since 2008-12-02)
Probably not the answer you are looking for, but there is no easy way to get that information from AL tables. It is probably POSSIBLE to extract that information from AL_LANGTEXT or AL_LANGXMLTEXT, but you would have to be both a skilled parser and a masochist to pull it off, IMO.
Perhaps there is some other method to solve your problem, if you could let us know what it is?
- Ernie
eepjr24 
(BOB member since 2005-09-16)
Thanks for your answer.
I tried using both the tables but i could not find the desired result.
Actually i want to write a metadata query which is joing multiple tables in
DF.If i get the query of that ,then i want make make genric procedure so
that when ever i want to know joins for particular flow ,I will pass the DF
name Dynamically using Procedures.
Please help me out to get this.
Thanks,
Asif
Pasif (BOB member since 2008-12-02)
all dataflow internals are stored in ATL text formal in the AL_LANGTEXT and AL_LANGXMLTEXT table. You would need to parse that - don’t. Maybe in the Management Console the AutoDoc feature helps?
Werner Daehn 
(BOB member since 2004-12-17)
I think you can get this information by running DI Integrator from Metedata Manager (its a different BO product)
if you already have MM then you can check the following view if it has that information
MMD_Source_Target_Map
manoj_d (BOB member since 2009-01-02)