12 Replies Latest reply: Feb 19, 2008 6:06 AM by 623931 RSS

    Workbook to Business Area Mapping

    482098
      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
          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
            Thanks Russ.
            • 3. Re: Workbook to Business Area Mapping
              482098
              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
                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
                  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
                    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
                      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
                        Sorry, wasn't ignoring you.

                        However a Mexican holiday was calling ... now back.
                        • 9. Re: Workbook to Business Area Mapping
                          puppethead-Oracle
                          How was the radio?
                          • 10. Re: Workbook to Business Area Mapping
                            Michael Armstrong-Smith
                            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
                              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
                                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.