I've few workbooks which are developed on a Business Area and they now need to point to a another(new) Business Area with same folders. I could delete the existing business area take its identifier and give it to my new Business Area, but I would like to have both the business area available and have 2 sets of workbooks.
I tried to check in EUL tables so that I could update the information in them to so that my new workbooks point to new Business Area's. Can someone tell which EUL table contains Workbook to Business Area to Folder mapping?
This post came from someone on this forum and will get you business area -> folder (plus more). Obviously change schema to your schema, and if using V5 change to v5 prefix.
I'd get you the workbook to business area link, but right now that database is down - figures.
'Unknown') AS obj_type,
exp.exp_name AS it_name,
exp.exp_developer_key AS it_developer_key,
exp.exp_description AS it_description,
6, 'Long Raw',
to_char(exp.exp_data_type)) AS it_data_type,
fun.fun_name AS it_fun_name,
1, 'Data Point',
2, 'Top or Side',
6, 'Unknown') AS it_placement,
'Visible') AS it_vis,
exp.exp_created_date AS it_created_date,
exp.exp_updated_date AS it_updated_date
exp.it_fun_id = fun.fun_id(+) AND
obj.obj_id = bol.bol_obj_id AND
obj.obj_id = exp.it_obj_id AND
bas.ba_id = bol.bol_ba_id AND
exp.exp_data_type = 2
Message was edited by:
Thanks for SQL query.
I am working on Discover Admin 4i , eul4_elem_xrefs table is different from eul5_elem_xrefs . Also I checked the table eul4_elem_xrefs and it doesn't contain any data.
Can you please provide the query for Discoverer 4i.
There are around 200 workbooks in our database and for around 20 workbooks there is no coressponding details in the table eul5_elem_xrefs.
I am not able to find any diffenece beween these 20 workbooks and others.
Can anyone tell whether all the workbooks will have coressponding data in eul5_elem_xrefs