BusinessObjects Board

Execution order stored in the Repo

Hi,

Does anyone know where in the repo the order of serial execution is stored. We can get the parent child relationship, but the order of the siblings is a little more tricky. The only place we can find it is AL_LANGTEXT or AL_LANGXMLTEXT and getting it out takes a bit of effort.
We ideally would like to get it out in straight sql, but need a clear relationship to AL_PARENT_CHILD so can get the heirarchy and order out in plain sql.

Thanks in advance


pxbaker :uk: (BOB member since 2007-01-09)

If the object contains the PARALLEL keyword in the AL_LANGTEXT table the object calls inside are parallel, else sequentially. So you would need to parse the ATL, find the keyword and the objects being called.


Werner Daehn :de: (BOB member since 2004-12-17)

Thanks Werner.

Does anyone happen to have the XML schema for the AL_LANGXMLTEXT.TEXT_VALUE content?
Should be pretty straight forward with DS then.

Thanks
Pat


pxbaker :uk: (BOB member since 2007-01-09)

Hi All,

Back around again …

Does anyone have the XML schema for AL_LANGXMLTEXT.TEXT_VALUE or for the XML export.

This would allow us to extract information about the structure of jobs also the transforms used, as were currently looking at an upgrade problem where a DF has both a left outer and an inner join in seperate transforms.

Thanks


pxbaker :uk: (BOB member since 2007-01-09)

Pretty sure that information is not published for public consumption. Like most of the AL_ stuff, you have to figure it out on your own.

  • E

eepjr24 :us: (BOB member since 2005-09-16)

actaully the XML language generation doesn’t uses any XSD

you colud try using xsd generator tools by giving the XML file, but again depending on the transforms that you use, you will have to keep updating the xsd, a lot of manual work till you get everything covered


manoj_d (BOB member since 2009-01-02)

This may help?

http://allangxmltextharvest.blogspot.co.uk/


phatz (BOB member since 2009-04-21)