This discussion is archived
12 Replies Latest reply: Feb 19, 2008 4:06 AM by 623931 RSS

Workbook to Business Area Mapping

482098 Newbie
Currently Being Moderated
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?

Thanks
  • 1. Re: Workbook to Business Area Mapping
    RussProudman Explorer
    Currently Being Moderated
    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.

    Russ

    =====================================================

    SELECT
    bas.ba_name,
    obj.obj_name folder,
    decode(obj.obj_type,
    'COBJ', 'Complex',
    'SOBJ', 'Simple',
    'CUO', 'Custom',
    'Unknown') AS obj_type,
    exp.exp_name AS it_name,
    exp.exp_developer_key AS it_developer_key,
    exp.exp_description AS it_description,
    decode(exp.exp_data_type,
    1, 'Varchar',
    2, 'Number',
    3, 'Long',
    4, 'Date',
    5, 'Raw',
    6, 'Long Raw',
    7, 'Rowid',
    8, 'Char',
    9, 'MLSLabel',
    10, 'Boolean',
    to_char(exp.exp_data_type)) AS it_data_type,
    exp.it_format_mask,
    exp.it_max_data_width,
    fun.fun_name AS it_fun_name,
    exp.it_heading,
    exp.it_hidden,
    decode(exp.it_placement,
    1, 'Data Point',
    2, 'Top or Side',
    3, 'Top',
    4, 'Side',
    5, 'Page',
    6, 'Unknown') AS it_placement,
    decode(exp.it_hidden,
    1, 'Hidden',
    'Visible') AS it_vis,
    exp.exp_created_date AS it_created_date,
    exp.exp_updated_date AS it_updated_date
    FROM
    eul_us.eul4_expressions exp,
    eul_us.eul4_functions fun,
    eul_us.eul4_objs obj,
    eul_us.eul4_ba_obj_links bol,
    eul_us.eul4_bas bas
    --
    WHERE
    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
    ORDER BY
    bas.ba_id,
    obj.obj_id,
    exp.exp_name
    ;

    Message was edited by:
    russ_proudman
  • 2. Re: Workbook to Business Area Mapping
    482098 Newbie
    Currently Being Moderated
    Thanks Russ.
  • 3. Re: Workbook to Business Area Mapping
    482098 Newbie
    Currently Being Moderated
    Russ,

    When you get a chance can post the workbook to folder to business area you have.

    Thanks
  • 4. Re: Workbook to Business Area Mapping
    532528 Newbie
    Currently Being Moderated
    Russ,

    It would be very helpful if you could post the query for mapping between workbooks and Business Areas

    Thanks
  • 5. Re: Workbook to Business Area Mapping
    482098 Newbie
    Currently Being Moderated
    Here is what I got.

    SELECT distinct
    ed.doc_name workbook,
    bas.ba_name,
    obj.obj_name folder,
    obj.SOBJ_EXT_TABLE,
    -- decode(obj.obj_type,
    -- 'COBJ', 'Complex',
    -- 'SOBJ', 'Simple',
    -- 'CUO', 'Custom',
    -- 'Unknown') AS obj_type,
    exp.exp_name AS it_name,
    --exp.exp_developer_key AS it_developer_key,
    exp.IT_EXT_COLUMN,
    --exp.exp_description AS it_description,
    decode(exp.exp_data_type,
    1, 'Varchar',
    2, 'Number',
    3, 'Long',
    4, 'Date',
    5, 'Raw',
    6, 'Long Raw',
    7, 'Rowid',
    8, 'Char',
    9, 'MLSLabel',
    10, 'Boolean',
    to_char(exp.exp_data_type)) AS it_data_type
    --exp.it_format_mask,
    --exp.it_max_data_width,
    --fun.fun_name AS it_fun_name,
    --exp.it_heading,
    --exp.it_hidden,
    -- decode(exp.it_placement,
    -- 1, 'Data Point',
    -- 2, 'Top or Side',
    -- 3, 'Top',
    -- 4, 'Side',
    -- 5, 'Page',
    -- 6, 'Unknown') AS it_placement,
    --decode(exp.it_hidden,1, 'Hidden','Visible') AS it_vis,
    --exp.exp_created_date AS it_created_date,
    --exp.exp_updated_date AS it_updated_date
    FROM
    eul5_expressions exp,
    eul5_functions fun,
    eul5_objs obj,
    eul5_ba_obj_links bol,
    eul5_bas bas,
    eul5_documents ed,
    eul5_elem_xrefs eex
    --
    WHERE
    ed.doc_id = eex.ex_from_id AND
    eex.ex_to_par_name = obj.obj_name AND
    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 A
  • 6. Re: Workbook to Business Area Mapping
    532528 Newbie
    Currently Being Moderated
    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.

    Many Thanks.
  • 7. Re: Workbook to Business Area Mapping
    532528 Newbie
    Currently Being Moderated
    Hi,

    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

    Thanks
  • 8. Re: Workbook to Business Area Mapping
    RussProudman Explorer
    Currently Being Moderated
    Sorry, wasn't ignoring you.

    However a Mexican holiday was calling ... now back.
  • 9. Re: Workbook to Business Area Mapping
    430163 Explorer
    Currently Being Moderated
    How was the radio?
  • 10. Re: Workbook to Business Area Mapping
    Michael Armstrong-Smith Oracle ACE
    Currently Being Moderated
    Nice to see you back. I hope you had a good break in the sun. I've been in Denver in 3 feet of snow!

    Best wishes
    Michael
  • 11. Re: Workbook to Business Area Mapping
    446700 Newbie
    Currently Being Moderated
    Hello,

    I'm working on Discoverer 4. Could you please provide the query for the same?
    The table eul4_elem_xrefs doesn't have any data.

    Appreciate your help.

    --
    Pons
  • 12. Re: Workbook to Business Area Mapping
    623931 Newbie
    Currently Being Moderated
    See also the thread on this forum with the title "Where in the EUL schema can I find metadata on worksheets", mainly the reactions with date april 17 2006.