The Power of XMAN

Unlike X-Men, XMAN is not a fictitious super hero but its powers are amazing. As part of AIA Developer Tools, it allows you to introspect the mapping structure in complex XSL transformation and presents a user friendly report in HTML and CSV format. This empowers the functional and technical analysis of the code to resolve technical governance issues of consistency in attribute mappings and XREF/DVM usage.

Some of the Benefits are:

  • Functional interoperability between PIPs.
  • Jumpstart projects and encourages reuse by using existing mapping information.
  • Enhances productivity by helping populate design time EBO mapping spreadsheets.
  • Assist with PIP upgrades by identifying custom extensions.

Viewing the HTML report is useful for viewing one service at a time; however there are times when we need to see the attribute mappings across connectors to ensure semantic consistency or to ensure all related connectors are using same XREF and DVM. For this purpose, AIA allows to download the consolidated report in CSV format and you can follow the below steps to import it in MS Excel,

  • Open a new Excel spreadsheet file.
  • In the menu bar, select Data -> Get External Data -> From Text. (Text - to - columns in Excel 2003 and prior versions)
  • 'Import text file' dialog box appears. Choose the csv file which you want to import.
  • 'Text import Wizard' dialog box appears. Choose 'Delimited' option in the 'Original Data Type' selection. Click 'Next'.
  • Select 'Other' check box and enter '~' in the text box. Click 'Next' and Click 'Finish'.
  • Put appropriate column headers as following,
    Custom, ServiceType, FileName, EBO, Application, Service, Operation, Source Xpath, DVM, XREF, Target Xpath, EBM, ABM

Now you may go about creating pivot tables and analyze DVM and XREF usage. One example to show the number of a particular XREF table usage in any service for a given application would be to create a pivot table and; select Service & Operation as "Report Filter", select Application as "Column Labels", select XREF as "Row Labels" and select ABM as "Values".

Similarly, you may analyze a specific attribute usage or DVM usage.

Look for XMAN at AIA Implementation Resources wiki

Comments:

Hi,

that's a interessting article.
After some changes in ENV Settings we are able to run the consolidation report scripts. We thinking about analyse our mappings to get integrated mapping report (e.g. ABM -> EBM -> ABM). I believe the consolidate csv is a good basis. I see the "Attribute Analysis" sheet in the screenshot, may be this is the solution. Could you please provide the excel file or a screenshot from the "Attribute Analysis" sheet? May be this is what we want. Do you have any ideas to create a integrated mapping report?

Regards
Marcel

PS: Enter the mapping information manually in the EBO Mapping Sheet is not a great solution ;-)

Posted by guest on April 10, 2013 at 02:35 AM PDT #

Hi,

that's a interessting article.
After some changes in ENV Settings we are able to run the consolidation report scripts. We thinking about analyse our mappings to get integrated mapping report (e.g. ABM -> EBM -> ABM). I believe the consolidate csv is a good basis. I see the "Attribute Analysis" sheet in the screenshot, may be this is the solution. Could you please provide the excel file or a screenshot from the "Attribute Analysis" sheet? May be this is what we want. Do you have any ideas to create a integrated mapping report?

Regards
Marcel

PS: Enter the mapping information manually in the EBO Mapping Sheet is not a great solution ;-)

Posted by Marcel Mertin on April 10, 2013 at 02:36 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

News, views and implementation best practices from the Oracle Application Integration Architecture team.

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today