Home

Saphir User Guide

1. wfTable Name Short Des D Sev ieEmicasp Table Relationships form This form is split into two sections The top section shows a list of tables that have a parent relationship to the currently selected table in the model overview This means that each of the parent tables contributes a foreign key to that table The bottom section shows a list of tables that have a child relationship to the currently selected table in the model overview This means that each of the child tables receives a foreign key from that table The total number of tables is shown in brackets at the top of each section The only with data checkbox can be used to reduce the parent and child table lists to only those with a Row Count greater than zero The list of parent and child tables displayed can also be refined using the drop down lists for each section The available choices are shown in the table below USER GUIDE 28 BROWSING THE METADATA IN SAFYR All relationships All relationships are displayed Identifying relationships Only relationships where the migrated primary key is part of the receiving table s primary key are displayed Non identifying mandatory relationships Only relationships where the migrated primary key is not part of the receiving table s primary key and the parent is mandatory are displayed Non identifying optional relationships Only relationships where the migrated prima
2. button displays a series of forms for configuring the Safyr repository and the connection to the source system See the Safyr Getting Started guide Chapter 2 Installation for details on how to complete the required information 2 3 Copying an existing repository definition Clicking the Copy a repository button will copy the currently selected repository definition and automatically create a new set of definitions with Copy of in front of the name 2 4 Deleting a Repository Clicking the Delete selected repository button will remove the entry from the available list of repositories Please note that this only removes the entry from the list The Safyr repository database and its contents will still exist 2 5 import export Repository The contents of a Safyr repository can be moved from one instance of Safyr to another using the repository import export feature 2 5 1 Import Repository Clicking this button will display a form for selecting the import export file This is in the form of a zip file and must have been produced from the Safyr Repository export process see Export Repository below Locate the file and select it to begin the import process Importing a repository will overwrite the previous contents of that repository Note Do not unzip the repository import file Safyr reads the file in its zipped format USER GUIDE THE REPOSITORY MANAGER 2 5 2 Export Repository
3. Drill into Source Data Export Source Data Export Source Data Full Selection Export Table Properties Export Table List to File or Clipboard all items Create SOL Scripts The available options are summarized in the following table Menu Usage or For more details see Table Details Viewing Table Details in this chapter Table Relationships Viewing parent child relationships in this chapter Add Table lt name gt to Subject Adds the currently selected Table to the currently Area lt name gt open Subject Area Select All Selects all the tables in the current list Find Table in See Finding a table in Application Hierarchy below Drill into Source Data Drilling into data in this chapter Export Source Data Exporting data from a single table in this chapter USER GUIDE 34 BROWSING THE METADATA IN SAFYR Export Source Data Full Selection Export of a number of tables in this chapter Export table Properties Creating a report of table attributes in this chapter Export table List Exporting a list of tables in this chapter Create SQL Scripts Creating SQL scripts for table access in this chapter 3 20 1 Finding a table in the Application Hierarchy This option when selected from the Model Overview context menu will show a list of one or more available Hierarchies in which to search for the table or view Once the desired Hierarchy has been selected the Hiera
4. Fieldname Fieldtext Fieldname Fieldtext a ChartField re Open Master Table Indexes Delete Extended Relationship The Rules based Extended Relationship Delete Pop up From the pop up choose Delete Rules Based relationship or Delete Extended Relationship It will be necessaty to confirm the deletion to actually remove the relationship from the Safyr repository This Delete feature is not enabled for ERP based relationships Note Once a Rules Based or Extended Relationship has been removed from the repository the only way to reinstate is to rerun the Generate Rules Based Relationship Generate Extended Relationship option again USER GUIDE 65 EXPORTING METADATA FROM SAFYR 4 Exporting metadata from Safyr Describes how to move metadata out of Safyr and into other environments of interest from the set of tables available in the Safyr repository There will often be a need to move he exploration features described in the previous chapter are principally aimed at locating data items subsets of the objects into other tools in use within the organization The vehicle for exporting metadata from Safyr is the Subject Area Whilst the target tool that requires the metadata will differ in how it deals with the information provided by Safyr the general procedures for exporting metadata are identical 4 1 Getting ready to export To begin the process of exporting the chosen data definitions t
5. denotes no limit Include original Subject Area tables views in result The set of tables in the Subject Area that are used as the basis of finding related tables will also be included in the result set if this option is selected After setting the Relationship Levels as described above clicking the Next button will start the process of assembling the related table list The resulting set of tables are then displayed USER GUIDE B Expand Subject Area B Tablesview Mame E BEY EMLGBSD FS BEY EMLGBWDK FS BEW 1 EMLGEWDP FS BEV EMLGFAD FS BEV EMLGOFS AA BEY LUTSO6 FS BEV i s REBO ES BEVIsRBLA FS BEV REMS AA IBEW 1 RBMSz FS BEV 1 REPA FS BEV 1 RBUM FPS BEV 1 RBUMZ FSS BEV L RBWE Fe BEY REKOND Fe BEV RPFA AA BEY 1 IRSFSA FS BEVL TSKLIN BROWSING THE METADATA IN SAFYR Table view Description Customer Empties Stock per Month Customer Empties Moverment Lock Object Empties Movement Account Customer Empties Movement Customer Billing Status Empties Biling Document without Update Check Table for LU Groups in Material Master Customer Master Data Rebate Processing Settlement Interval and Dake Last Settlement fF Conversion Table Material Master Data Intermediate Table for Conversion of Material Intermediate Table Material Specific Contrib M Conversion Table For Indirect Customers Reba Intermediate Table Conversion Indirect Cust Itemized Proof Rebate Settlement Parameter t
6. Clicking this button will display a form for specifying the location of the export file Enter an appropriate name and location and press the Save button to proceed with the export process 2 6 Repository maintenance Clicking the Repository Maintenance button displays a form that controls the tasks involved in maintaining the structure of the tables in the Safyr Repository ish Safyr Repository Manager Operations _ j This process performs all necessary steps to keep Repository Maintenance your repository up to date This process creates a new repository A Create Repository This process deletes the repository Xx Drop Repository 4 a ii k Repository Maintenance form The Repository Maintenance form deals with the Creation Deletion and Modification of the tables and other RDBMS objects in a Safyr repository The process will appear automatically when configuring a new repository or when upgrading from an older version of Safyr There are three buttons on the form Repository Maintenance Click this button to check the structure of the Safyr repository against the latest standard This will typically be used when upgrading from an earlier Safyr release Create Repository Click this button to create the tables views and triggers that form the structure of the Safyr repository Drop Repository Click this button to drop all the tables views and triggers i
7. Created by 0 0 1 VARCHAR 12 12 0 VARCHAR CHAR 10005 0 LAEDA Last change 0 0 1 CHAR 8 8 0 CHAR DATS 10006 0 AENAM Last changed by 0 0 1 VARCHAR 12 12 0 VARCHAR CHAR 10007 0 VPSTA Compl maint status 0 0 1 VARCHAR 15 15 0 VARCHAR CHAR Sample CSV file output USER GUIDE 70 EXPORTING METADATA FROM SAFYR 4 3 Exporting to the Safyr ER Diagrammer One of the optional export formats available with the product is Safyr s own diagramming environment ER Diagrammer This provides a simple method for representing the chosen tables as a datamodel To create a diagram in ER Diagrammer use the Export Wizard as described above choosing Safyr ER Diagrammer as the Export type Step 2 Export Subject Areas To Please select where to export the subject areas and define the export settings Comparison File CSV File Saphir ER Diagrammer Choosing the ER Diagrammer export format Once the export process is completed the diagram will appear as a new window within the Safyr environment ETER Diagrammer 9 S Blea amp E RR E A OA OO ec rr PRP iO Siebel User Exchange Rate Ba Row Id PK 28 Row Id PK Parent Row Id Created Created j Ea Created By FK Ea Created By FK Conflict Id Conflict Id T Last Updated Last Updated Ea Last Updated By FK Ea Last Updated By FK Modification Number Modification Number Exchange Date User Flag F Exchange Type Code Login Name Ba From Cur
8. Logical Physical Display both Logical and Physical Entity and Attribute names on the diagram Model Display Notation Information Engineering Use Information Engineering for the model notation IDEF1X Use IDEF1X for the model notation Entity Display Domain For each Entity in the model show the Domain name of each Attribute Datatype For each Entity in the model show the Data type of each Attribute View Display Datatype For each View in the model show the Data type of each Attribute Null Option For each View in the model show the Nullability of each Attribute Domain For each View in the model show the Domain name of each Attribute Expression For each View in the model where an Attribute is a calculated field show the Expression for that field Key Display Primary Key Designator Show the Primary Key Designator PK for each Primary Key Attribute USER GUIDE 73 EXPORTING METADATA FROM SAFYR Foreign Key Designator Show the Foreign Key Designator FIX for each Foreign Key Attribute Primary Key Icon Show the Primary Key Icon for each Primary Key Attribute Foreign Key Icon Show the Foreign Key Icon for each Foreign Key Attribute Hide Selected Objects Hide objects on the diagram previously selected using standard Windows selection techniques e g Shift Click on each object Undo the most recent Hide activity Undo all Hide activities Undo Last Undo All Show Ruler Toggle the diagram ru
9. MANDT PSTLZ MANDT LAND 1 3 Show Field Info Viewing Index Information Clicking on an index in the list displays the field components of that index in the box to the right USER GUIDE 26 BROWSING THE METADATA IN SAFYR 3 13 3 Relationship details Clicking on the Relations tab i Relations eveals a list of all the relationships between the current table and any parent tables Note This will only find relationships where the current table in the Tables Details is a child To find both parent and child relationships see Viewing parent child relationships later in this chapter EX Table Info HE Fields LA Relations Indexes Relationships Posit Fieldtext Parent 2 ea MANDT Client T000 aa LAND 1 Country T005 REGIO 3 Region T0055 Origin aa AUFSD Central order black TVAST Parent Table KNA1 General Data in Customer Master Gay BRSCH 2 Industry T016 Long Desc a FAKSD 32 Billing black TVFS i aa FISKN 3 Fiscal address KNAL ay KNAZK 3 Working times TFACD EAKNRZA 35 Alternative payer KNAL F KTOKD Account group TO D ay KUKLA 3 Customer classific TKUKL ae LIFNR Vendor LFAL ey LIFSD 2 Delivery block TVLS ea NIELS 5 Nielsen indicator TNLS aay COUNC g County code TOOSE h Se CITYC City code T00SG Fieldname Fieldtext Fieldname Fieldtext aia SPRAS ey Laing HEIMANDT Client HEIMANDT dlient iis LZONE 2 Transportation zone TZONE HRIKUNNR Customer HRIKNRZA Alternative p
10. THE SAFYR META MODEL Table Name DD _ TABLE DESC Definition The descriptive text for a Table DD _ TABLENAME Table Name Table Column Name Table Column Comment DD_LANGUAGE ID Language Code SHORT DESC LOGICAL_UNIQUENAME i LONG_DESC ees Table Name DD TREE Definition A definition of a Tree Type for the Application Hierarchy Table Column Name Table Column Comment DD_TREE_ID DD_ROOTNODE_ID E E Table Name DD_TREE_DESC Definition The descriptive text for a Tree type Table Column Name Table Column Comment DD_TREE_ID DD LANGUAGE_ID Language Code SHORT_DESC D Table Name DD_TREENODE Definition A definition of a Tree Node within the Application Hierarchy DD_TREENODE ID _ Z o o Too O DD_TREENODECLASSID o doo O HAS _CHILDNODES Indicates if there are Nodes below current level possible values are Y or N HAS TREENODE_TABLES Indicates if there are Nodes containing Tables associated with this Node possible values are Y or N HAS_TREENODE_VIEWS Indicates if there are Nodes containing Views associated with this Node possible values are Y or N TEMP_EXTRACT_INFO1 E TEMP_EXTRACT_INFO2 T Table Name DD TREENODE_ DESC Definition The descriptive text for a Tree Node Table Column Comment SHORT_DESC o G O Table Name DD TREENODE_ TABLE Definition An intersect between a Tree Node and a Table Table Column Name Table Column Comment DD_TREE_ID DD_TREENO
11. check this box to see the property names as header on the list Delimiter chose Tab or Comma as the delimiter to separate the report columns The buttons at the bottom of the form are as follows Create List This produces the Report text based upon the options specified above The Select Al and Copy to Clipboard buttons can now be used to select and copy the generated text for transfer to another application if required USER GUIDE 50 BROWSING THE METADATA IN SAFYR 3 31 Exporting a list of tables This feature of Safyr can be used to create simple list of tables from the Model Overview Right Mouse Click on the Safyr Model Overview and choose Export Table List to File or Clipboard The following screen is then displayed Data Export to File Citempisample csy 7 to Clipboard Output Encoding ANSI Record Counter Boolean True as Column Mames Boolean False as oY Logical Data as Display Texts O Physical Data as Database values Field Separator Record Separator Field Delimiter O None Space Field Delimiter isl Comma 2 Tab Record Separator CR LF Ra Semicolon other Export table List screen The Export form options are as follows 7 To File or to Clipboard Choose the appropriate option to export to a file or to the Clipboard File Name Enter the name of the file to export to Use the E button to browse for a file or folder If
12. 1 2 Created By ARS r 0 1 2 Degree Of Precision AUB 0 1 2 Australian Dollar Descriptive Text ee ATS ds 0 1 2 Decimal Symbol BEF BF 0 1 2 Belgian Franc Dockces Numirer BRC R 0 1 2 sae OS i CAD 5 0 1 2 Canadian Dollar Extend Predis COP 0 1 2 OR DKK kr 0 1 2 Danish Krone Euro Triangulation R _ Created 01 01 1980 Export Drilling into Data Safyr displays the result data set in tabular form Additionally there are one or more Detail Tabs to the right of the screen which allow the user to examine all the fields of one row The columns in the data set can be re arranged by dragging and dropping a column to a new position using the column title The data set can be sorted by clicking on the title for the required sort column A second click will sort that column in descending order USER GUIDE 42 BROWSING THE METADATA IN SAFYR For more complex sorting Right Click on the column title to access the Define Field Order form Define Field Sort Order xX Currency Code AB Currency Symbol le i Created By HE Degree of Hel Descriptiv HF Decimal Symbol EE Docking Number CE ooo HE End Date I Descending Changing the Sort Order Use drag and drop to select the fields for sorting Use the Descending check box to change the sort between Ascending Descending 3 27 Using QBE Query by Example to interrogate data Y To restrict the data retrieved click on the QBE Button T Queries can be built
13. DD DOMAIN check if OD LOOKUP _ENTITYNAME exists Fields and Indices Syne DD FIELD get DD _DOMAINNAMES From DD _DATSELEMENTS 4poplication Hierarchy Delete DDO TABLES without Fields Sync OD FIELD Key Flags with Primary Key IndexMembers Reorganisation of Repository after Extract Generate ERP Based Relationships Generate Rule Based Relationships Select Start Step and Required Steps Select All Unselect All Using Right Mouse click to select the Starting Step for Extraction This will set all the necessary steps for the extraction process to process the Rules Now proceed with the extraction as normal USER GUIDE ADDING ADDITIONAL RELATIONSHIPS Please define the extraction steps below Log Source DB Physical Connection Check PeopleSoft Enterprise Environment Clear affected repository tables or recreate the whole repository Log Repository OB Physical Connection Prepare the Repository Environment after deleting unused datat DO LANGUAGES Fill Languages Initialize Language Environment From OO LANGUAGES Domain DataElement DataElement Description default language DataElement Description additonal languages Table Table Description default language Table Description additional languages Check of OD DOMAIN check iF DD LOOKUP ENTITYNAME exists Fields and Indices Syne DO FIELD get OG DOMAINNAMES From OG CATAELEMENTS Application Hierarchy Delete DD TABLES without Fields Sync OD FIELD Key Flags with Primary Key
14. Elements 32 Domains 33 Views 29 PeopleSoft Physical Table Name 69 relationships 99 QBE 43 relationships 27 28 creating 64 creating additional 63 deleting 65 reviewing 64 Repository copying 6 deleting 6 importing exporting 6 maintenance 7 Manager 5 Managing Multiple 8 opening 5 settings 6 Repository Manager toolbar 6 Row Count 15 Safyr ini file 13 Manuals 4 Meta Model 84 toolbar 12 Safyr export formats 68 Safyr Settings ini file 8 SAP BW 79 search criteria 17 Search Criteria Clearing 23 Select statement generate 48 Sorting 22 SQL Query 22 SQL Script creating 48 Statistics 52 status bar 10 Subject Areas 54 comparing 77 Expanding 60 import export 55 populating 56 Table Attribute Report 50 Table details Viewing 23 Table List Export 51 Tables Searching for 38 Toolbar 10 Tree Nodes Searching for 40 View statement generate 48 Views 16 Searching for 38 Workspace 10 USER GUIDE 100
15. FOFIAP_CO F FIAP Transactions 810 FOFTAP_co3 F FIAP Line Item S10 FOFIAR_co2 F FIAR Transactio mj BIO FOFIAR_CO3 F FIAR Line Item Add Table 610 FOFIAP_CO to Subject Area cube BIO FOFIAR_COS F FIAR Payment Hi Add selected Tables to Subject Area cube Blolelelelelelelolelolol Table Details Table Relationships iq qd H No of Records 1279 Add SAP BW Physical Cube BIO FOFIAP_CO2 to Subject Area cube Star Schema Physical Model Snowflake Physical Model Find Table in Extended Physical Snowflake Drill into Source Data Export Source Data Export Source Data Full Selection Export Table Properties Create SOL Scripts RMC Options for a Fact table on the Model Overview USER GUIDE 82 SPECIAL PRODUCT FEATURES FOR SAP BW Clicking on this option displays a subsidiary menu with three entries These control which tables will be added to the Subject Area The three options are Star Schema Physical Model The Fact and associated Dimension tables are added Snowflake Physical Model The Fact Dimensions and all associated tables needed to include the related Characteristic tables are added Extended Physical Snowflake As for the Snowflake Model but in addition any Characteristic table parent tables Characteristic tables related to Characteristic tables are also included A similar set of options exist when selecting an RMC on a Logical Fact Tabl
16. Logical representation a set of Virtual tables are generated in the Safyr Repository These virtual tables are created in order to bypass some of the complexities of the BW physical model USER GUIDE 79 SPECIAL PRODUCT FEATURES FOR SAP BW 6 2 The Model Overview and BW BW metadata appears in the Model Overview in the same manner as for any other system handled by Safyr with one exception and that is the usage of Table Type The Table Type in a Safyr BW system describes the purpose of the table Possible values are shown in the table below BW DIM MP D Dimension Table for a Multi Provider BW Charact SID View R A View table that acts as an intersection between a SID table and a Dimension BW Logical Dim A virtual table that presents a Logical view of a Dimension table BW Logical Dim MP A virtual table that presents a Logical view of a Multi Provider Dimension table BW Logical Charact A virtual table that presents a Logical view of a Characteristic table USER GUIDE 80 SPECIAL PRODUCT FEATURES FOR SAP BW 6 2 1 Using Advanced Search to select BW Table types The Advanced Search feature Standard filter tab see Chapter 3 for more details has a Table Type dropdown list that for a BW system displays the possible Table Types listed in the table above Filter Table by Standard Filter Search for Field Patterns Table Name I Short Description BW Fact F BW Fact MP F Lo
17. Parent Thls g T5000 Currency For Public Service Sector Transparent E Tso Personnel Country Grouping 6 ts00L_appon Indicator Country etek Add On Solution weewet E cool i nt gt tees Table Details Tre HE sp ail rable Relationships e ae Transparent MS Add Table TSO0L_CUST to Subject Area demo a tl 5 T500 dd the selected 8 Tables to Subject Area demo Select All Data Elements GI Domains e Dj r fr Find Table in Drill into Source Data Export Source Data yject Areas Export Source Data Full Selection Export Table Properties Export Table List to File or Clipboard 3 items Create SQL Scripts rea contains o Tableview Description FA Delete Sy Delete a To add a table drag amp drop it from the Model Overview Related Tables or 4pplication Hierarchy window bo this member list Populating a Subject Area from the Model Overview You will be asked to confirm the action and then a pop up form shows the selected set of tables being added to the subject area 3 36 2 Populating a Subject Area from the Related Tabled pop up menu Another method of adding tables to a subject area is to choose tables from the Related Tables form This is useful when looking for tables that are parent or child tables of a given table To achieve this display the Related Tables form for the appropriate table see Viewing parent child relationships in
18. Search in Hierarchy or Search in Branch options in the Application Hierarchy pop up menu displays the Search form This has three tabs the first two are for searching for Tables and Views and the third tab for searching Tree Nodes Clicking the Search for Tree Node tab displays the Search for a Tree Node form El Search in SAP Program Tree for a Table for a View for a Tree Node Treenode Class ID bb Search Found Items O Found Item Path within the Hierarchy Search Tree Node form To find node in the application hierarchy enter a search string in the Short Description and optionally select a Tree node class from the drop down list The Treenode classes available in the list are dependent on the Enterprise Application selected Clicking the Search button will display a list of matching nodes Having arrived at a list of items for the search performed double clicking on an item in the list will locate that item in the Hierarchy USER GUIDE 40 BROWSING THE METADATA IN SAFYR 3 25 What does the Application Hierarchy show for each ERP As mentioned above the actual structure of the Application Hierarchy is dependent on which ERP is shown within Safyr This section describes the ERP specific objects available 3 25 1 Application Hierarchies for SAP There are two Application Hierarchies created in Safyr for SAP These are SAP Application Development Cla
19. Views and for each View the Business Components associated with that View 3 25 3 Application Hierarchies for PeopleSoft Enterprise PeopleSoft Application Tree This tree shows PeopleSoft Applications and for each Application the Tables associated with that Application The Application is based upon the Object Owner Id of each Table 3 25 4 Application Hierarchies for PeopleSoft EnterpriseOne JDEdwards DEdwards System Code Tree This tree shows JDEdwards tables grouped by System Code The System Code comes from the JD Edwards Table definition 3 25 5 Application Hierarchies for Oracle Enterprise Business Suite EBS Application Tree This tree shows Oracle EBS tables grouped by Application The Application Id comes from the EBS Table definition USER GUIDE 41 BROWSING THE METADATA IN SAFYR 3 26 Drilling into data In addition to looking at the metadata for tables Safyr allows the actual data itself to be displayed subject to the appropriate data access authorities This is achieved by selecting the table from the Model Overview and then clicking Re on the toolbar or by Right Mouse Clicking on the table in the list and selecting Drill into Source Data Safyr then performs a query to retrieve the data from the table Show Table 5 CURCY Currency E ioj x Currency Code HKO T Currency Symbol Created By Degree Of Descriptiv 2 2 Greek Drachma Currency Code 2 U 5 Dollar Currency Symbol f ALL Lek 0
20. aay VBUND Trading Partner T880 ea GFORM Legal status TVGF S BRIAN 7 Industry code 1 TBRC an BRAN2 Industry code 2 TERE aa BRAN Industry code 3 TERC ea BRAN4 Industry code 4 TERC pDAMG w a E E E e Teor Relationship details Type Non Identifying Cardinality Zero one or more Tech Desc Clicking on a particular relationship will show the fields participating in the relationship at bottom right for both the child and parent table along with more information about the relationship at top right The Parent Table field in the top right panel shows the Parent table for the selected relationship Clicking on the icon to the right of this field can be used to display details of the parent table in the relationship USER GUIDE 27 BROWSING THE METADATA IN SAFYR 3 14 Viewing parent child relationships From the Model Overview with a table selected clicking on the Cl tool from the toolbar or selecting the Table Relationships option from the View menu will display the Table Relationships context pop up form E Table Relationships o 2 EF Relationships for Table only with data KNA1 Parent Tables 51 all relationships Table Name NS0 R_DPOINT Collective Unloading Point for VSO BUSTYP Type of Business FMFGT_ALC Agency Location Code U 5 Federal Government Payment Office U S Federal Government _ J INDUSTYPE Type of Industry Child Tables 1147
21. active and by clicking this button all search criteria will be cleared The button is only visible when search criteria are present Table Mame Short Description Subject Grea ID P Bb Search The Clear Search Criteria button 3 13 Viewing table details Full details of a given table can be displayed by double clicking on the row for that table in the Table list This opens the Table Details window Alternatively Right Click on the highlighted table and select Table Details from the pop up menu Note It is possible to open a number of separate table details windows When the Table Details form is opened a list of fields is displayed for that table Other table information can be displayed from this form using the Buttons on the left hand side of the form The default display format shows details of each field in the table To the left of each field icon H there may be an additional icon This can be The Field is part of the Table s Primary Key fr The Field is part of the Primary Key and also a Foreign Key E The Field is a Foreign Key field As each field is selected further information about that field is shown in the tabbed display to the right There are three levels of information about each field The Field Details the Data Element for that field and the Domain to which the Data Element belongs The three levels can be displayed by clicking on the appropriate tab USER GUIDE 23 BROWSING THE
22. an SAP system Physical Table Name Enter a Table Name or partial Table Name This is the name of the actual Table in the underlying ERP database No of Parent Tables Enter the desired number of Parent tables No of Child Tables Enter the desired number of Child tables Row Count Enter the desired number of rows in the table Long Description Enter a string to be located within the Table Long Description Field or Column related search criteria Field Name Enter a Field Name or partial Field Name Short Description Enter a Short Description or partial Short Description Data Element Name Enter a Data Element Name or Partial Name Domain Name Enter a Domain Name or Partial Name Long Description Enter a string to be located within the Field Long Description Subject Area related search criteria in Enter the Subject Area name containing the tables to be searched not in Enter the Subject Area name containing the tables of to be included in the search Having entered the appropriate search conditions click OK to perform the actual search USER GUIDE 19 BROWSING THE METADATA IN SAFYR Filter Tables by Standard Filter Search For Field Patterns Extended Filter ae 4 4 47 4 F BS e bs e e i I Clear Filter Advanced Search Search for Field Patterns The Search for Field Patterns form allows for combinations of fields and field characteristics to be used
23. mode The data can be sorted on any of the available columns by clicking on the field heading The current sort field is denoted by a sort icon Table Name next to the name of the sorted column An inverted sort icon denotes a column sorted in descending order More complex sort criteria can be specified in the Define Field Sort Order form This is opened by a Rzght Mouse Click on the field heading Define Field Sort Order SER T Name HE Tbl Type HEI No of Child Tbls Hel No of Parent Tbls si Descending Show SOL kk Cancel Defining Field Sort Order Specify the sort order by dragging the appropriate fields from the Available Fields window into the Sort Fields window The sequence of fields in the Sort Fields window determines the sort order The Descending check box can be checked to specify descending sort sequence for that field Click the Show SQL button to see the order by clause of the SQL Query representing the requested sort ORDER BY Number of Child Tables DESC DD Text DESC Displaying the Query SQL Click the OK button to perform the sort USER GUIDE 22 BROWSING THE METADATA IN SAFYR 3 12 Clearing Search Criteria in the Model Overview When search criteria have been entered either in the Model Overview screen or using the Advance Search a Clear Search Criteria button EJ appears next to the Search button This indicates that there are search criteria
24. output via telefax The system determines the number of your business partner s telefax machine from his account number This fax number then appears as a default eee Domain 1 USER GUIDE 24 BROWSING THE METADATA IN SAFYR 3 13 1 Table details The Table Information tab ES Table nfo_ it show details including the Business name of the Table its Class and any Views based on the table E Table Info HE Fields at Relations Indexes Table Name KNAL Short Description General Data in Customer Master PryscaTbINne Sd Long Description Tech Description View Type View Name Short Desc BIW KNAL Collection of customer master data for Wareho fS DB View BIW _KNAIT Collection of customer texts for Warehouse PSDB View BIW_KNA1T_CONS Collection of Customer Texts for BW es ges ye aa eet res oi ee _ Table Information Details of a given view can be displayed by double clicking the view name This will display the View details form See Showing the View fields later in this chapter for more details USER GUIDE BROWSING THE METADATA IN SAFYR 3 13 2 Index details Clicking on the index tab Indexes displays a list of indexes for the currently selected table EH Table Info BE Fields Relations d Indexes pes R PES MANDT KUNNR Eoo MANDT CONFS da oasa A MANDT SORTL MANDT FISKN Index Items Fieldname Fieldtext MANDT MCOD3 AE MANDT Client MANDT MCOD4 H KUNNR Customer
25. ranges to be used for the orders Which criteria are used when selecting a routing How the order is to be costed View Details This is very similar in content and purpose to the base table details form see Viewing Table Details earlier in this chapter USER GUIDE BROWSING THE METADATA IN SAFYR 3 15 2 View Elements Information Clicking on the view info button View Info eyeals more details of the view and a list of the Base tables on which the view is based DB View AUFK_DT_ View for Orders Ea View Info RR Fields View Name Short Description View for Orders Long Description Tech Description Table Name Short Desc FE AFKO Order header data PP orders FEES AUK Order master data View Info Double clicking on one of the component Table Names will open the Table Details Window for that base table see Viewing table details earlier in this chapter USER GUIDE 31 BROWSING THE METADATA IN SAFYR 3 16 Using the Overview to browse Data Elements Clicking on the Data Elements 44 on the Model Overview form displays a list of available Data Elements Initially the list is empty pressing the Search button retrieves a full list of Data Elements lif Model Overview Data Elements fq Tables Views Eil Data Elements Wi Domains Data Element Name Short Description Data Element Name B isaPomc s_CIMTYPE SAPDMC LS_CONSTANT SAPDMC LS_COUNTER
26. selecting this a search is initiated to find all Tables containing Fields that belong to the chosen Data Element Note This feature sets the Data Element field in the Search parameters see Using Advanced Search above to the selected Data Element It is advisable to clear this field after completing the search to prevent further searches from including this setting USER GUIDE 32 BROWSING THE METADATA IN SAFYR 3 18 Using the Overview to browse Domains Clicking on the T Domains tab on the Model Overview form displays a list of available Domains Initially the list is empty pressing the Search button retrieves a full list of Domains Lif Model Overview Domains E Tables Views HE Data Elements i Domains OF Grid Filter Domain Name SAPDMC LS_ACTIONTYPE CHAR Number as String NUMC Number as String NUMC String CHAR Data Type String CHAR Datatype ERP SAPDMC LS_FILEN File Name Type P Physical L Loc String CHAR SAPDMC LS_FILETY File type Number as String NUMC SAPDMC LS FLAG Indicator string CHAR SAPDMC LS FLD Field Name String CHAR SAPDMC LS_FLDOLE Field Length Number as String NUMC Key Short Desc SAPDMC LS_FLDTY Field Type String CHAR 1 Import Data SAPDMC LS_KEY Key String CHAR 2 Convert Data SAPDMC LS_LOCAT File Location String CHAR 4 Load Data SAPDMC LS_REFER Reference String CHAR E SAPDMC LS_RULEN Rule Name String CHAR SAPDMC LS_RULET Rule Category String CHAR Sho
27. status bar Show Information about the product epository 5 i ype 5AP Language E 4 Safyr Status Bar The status bar is divided into 4 areas which are from left to right as follows Micro Help displays a short description as the mouse is positioned over menu items and buttons Repository Identifier shows the name of the currently selected Safyr repository Repository Type identifies the type of the Safyr repository e g SAP Selected Language shows the language code that is being used for descriptive fields like field names and table names USER GUIDE BROWSING THE METADATA IN SAFYR 3 1 2 The Safyr menus The Safyr menu options are summarized in the following table See the referenced section to find out more on each menu option Menu Menu Item For mote details see File Repository Manager Chapter 2 The Repository Manager ERP Extract Safyr Getting Started Guide chapter 3 SS N Gc Ge ED S o Caine The Application Hierarchy in this chapter Cd Table Details Viewing Table Details in this chapter Fd Table Relationships Viewing parent child relationships in this chapter View Details Using the Overview to browse views in this chapter TC Statistics Viewing Model Statistics in this chapter Tools Satyr Options Safyr Options in this chapter Compare Subject Areas Chapter 5 Comparing metadata D a Tern ag eRe a a Co n P O o e
28. the possible values m ParentTableName The name of the Parent table for the relationship 7 RuleNotActive If blank then the rule is active If X then the rule will be ignored ExtGenRelParent Used by the Extended Relationship generation process See Influencing the Extended Relationship generation process for PeopleSoft and JDEdwards relationships below for details m Remark A free format comment area for entry of optional notes describing the rule When the PeopleSoft or JDEdwards Extraction process is run see Extracting metadata from PeopleSoft Enterprise and Extracting metadata from JDEdwards EnterpriseOne in the Safyr Getting Started Guide if the user has elected to include Rules based relationships each entry in this sheet is processed and a relationship added subject to the details being correct USER GUIDE 92 ADDING ADDITIONAL RELATIONSHIPS B 2 Special Considerations for PeopleSoft Relationships Many PeopleSoft tables have fields EFFDT EFFSEQ and SETID which have particular purposes in the PeopleSoft architecture Safyr will ignore these fields when building a relationship as they are not truly part of a logical relationship between tables B 3 Defining a Rule To define a new tule decide which tables the relationship is to be between Then add a new row to the spreadsheet enter the name of the Parent table in the ParentTableName and the name of the Child table in the ChildTab
29. to determine which product features are enabled Safyr is distributed via a number of licensing systems Please contact your Safyr software provider for more details of licensing options USER GUIDE BROWSING THE METADATA IN SAFYR 3 4 Browsing the metadata There are two main entry points for Browsing the metadata The Model Overview this displays a list of tables views or domains in the repository You can use search facilities to refine the list For more details see The Model Overview below The Application Hierarchy this shows the tables and views organised by Application Module For mote details see The Application Hierarchy later in this chapter 3 5 The Model Overview The Model Overview form is displayed by clicking M on the Safyr toolbar or selecting Model Overview from the View menu Clicking the button will return a list of all the tables in the Safyr repository Hf Model Overview Tables Table Name Short Description Subject Area ID Le brs Field e Drilldown Reporting Link for Limit Mgmt ees Type of Master Agreement Transparent Type of Master Agreement Name Transparent Check Table for Option Categories Transparent Text Table for ATO1 Transparent Table of Limit Types Transparent Text Table for Limit Types Transparent ATP_INDX Transparent Treasury Product Type Supplements Transparent Treasury Clearing Account for Payment Requests Transparent CFM Assign Volume Change
30. up by adding selection criteria to one or more fields Search Criteria can be added to the tabular display area or to the detail tabs El Show Table 5_CURCY Currency 5 x Currency Code A currency Code curency Smbol Fd cresas OoOO O _ Degree Of Precision gt Setting QBE Selection Criteria USER GUIDE 43 BROWSING THE METADATA IN SAFYR Click the Execute Button to run the query SI Show Table 5 CURCY Currency Query Results USER GUIDE 44 BROWSING THE METADATA IN SAFYR 3 28 Exporting data to flat files 3 28 1 Exporting data from a single table Having selected the required data click on the E 4 Button The data can be exported with or without column headings using logical or physical names A comma tab or other character can be specified to delimit the export file Data Export to File x File Name w Write File Header Record Counter J Column Names f Logical Boolean True Boolean False Field Delimiter Record Separator Fields EAllLanquage key fil country key CAllname CAll Nationality Export Form The Export form options are as follows m File Name Enter the name of the file to export to Use the a button to browse for a file or folder If this file does not exist Safyr will create it m Write File Header Checking this option enables the additional options in the panel of Record Counter and Column Na
31. 1 For Internal Use ff IBEVZ EDSPCKO2 For Internal Use fa IBEVZ EDXFCKO4 For Internal Usa Found Items 239 fs IBEY2 EDXPCKOS For Internal Usa Found Item Path within the Hierarchy a fREVZ ED9O1 Tax Types Excigl E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED JE EA KNAL General mots in customi E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E 2 E VART ABAP Variant eas E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E afa eee TET e 1 General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E afa Poe ee ee E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E ia fa BEV2 EDXFCKOS For Internal us E General Data in Cust MM Materials M t MM IM Inventory M t MM IM ED E ce fa JBEV2 EDYLISPR Check program d eneral Data in Custom I Materials Management MM pee ory Management MM IM ED i fa BEV2 EDXXPANM1 Tax Return Ea li gt fs BEV2 EDXXSAMML Collective Fili i Fa IBEV2 EDMEVBSB1 Inventory Note Excise Duty Program For a Table for a view for a Tree Node Using the Search Tables result to locate a table in the Hierarchy USER GUIDE 39 BROWSING THE METADATA IN SAFYR 3 24 Searching Tree Nodes in the Application Hierarchy Clicking the
32. 1 and those without data to zero 3 6 1 Special Considerations for SAP and Siebel Systems The row count capability of Safyr takes no account of multiple systems that may exist in the same source ERP system SAP via the MANDT Client approach and Siebel via the Repository approach permit USER GUIDE 15 BROWSING THE METADATA IN SAFYR several parallel systems to be stored within the same database For example within one Siebel system there might be a Standard repository and a Custom repository Because the row count capability of Safyr is based upon the physical row count in the system catalog the resulting row count for a given table will reflect all rows regardless of which of the rows belongs to which Repository 3 7 Opening additional Model Overview windows Multiple Model Overview forms can be opened Each window functions separately allowing a number of different object lists to be displayed concurrently 3 8 Seeing View Data Element and Domain information The Model Overview can be switched between Table View Data Element and Domain display using the tabs above the form See Using the Overview to browse Views Using the Overview to browse Data Elements and Using the Overview to browse Domains later in this chapter for more details USER GUIDE BROWSING THE METADATA IN SAFYR 3 9 Selecting tables in the Model Overview The three fields above the table list can be used for selec
33. 4 54 46 Empty Table DD TREENODECLASS 14 54 46 Empty Table DD TREE DESC 14 54 44 Empty Table DD TREE 14 54 46 Empty Table DD_VIEWFIELD DESC 14 54 46 Empty Table DD VIEWFIELD 14 54 49 Empty Table DD VIEW _DESC 14 54 53 Empty Table DD VIEW 14 54 54 Empty Table DD_RELATIONSHIPITEM 14 54 54 Empty Table DD RELATIONSHIP _DESC 14 54 55 Empty Table DD RELATIONSHIP 14 54 56 Empty Table DD INDEXITEM 14 54 57 Empty Table DD INDEX DESC 14 55 00 Empty Table DD INDEX 14 55 02 Empty Table DD FIELD DESC 14 55 03 Empty Table DD FIELD 14 55 39 Empty Table DD TABLE DESC 14 56 22 Empty Table DD TABLE 14 56 23 Print Tahla 1M MATARI PMERIT MPO 1A CATA HT v w v v v v v v v v v v v v w v w v v v F v v aa Viewing the Extract Log At the completion of each extract the log file is written to the ExtractLog folder This folder is located within the Safyr folder The default location for this is ProgramFiles Silwood Safyr 6 ExtractLog During the extract process the Log can be saved at any stage by Right Mouse Clicking on the background and selecting Export Log USER GUIDE 53 BROWSING THE METADATA IN SAFYR 3 34 Subject Areas Subject Areas allow tables and views in Safyr to be divided into manageable chunks Subject Areas allow you to Create subsets of the full set of tables in the Safyr repository a Safyr subject area is like a folder where you can group together tables of interest Qualify Searc
34. Application Hierarchy window to this member list The Subject Area form The controls on the form are as follows Select Subject Area Use this dropdown list to select an existing Subject Area The contents of the subject area will be displayed in the window below the dropdown list Click this icon to change the name of the current Subject Area al Click to create a new Subject Area X Click to delete the currently selected Subject Area You will be asked to confirm this deletion and then the Subject Area and its contents will be deleted H Expand the Subject Area by creating a list of related parent and or child tables See Expanding a Subject Area with related Parent or Child Tables below fed Import Subject Area members A subject area and its contents previously exported may be loaded into a separate subject area On clicking this option you will be prompted for the file name of the subject area to be imported On accepting this the current subject area will be updated with the contents of the export file USER GUIDE 55 BROWSING THE METADATA IN SAFYR Ea Export Subject Area members This option exports the currently selected subject area into an export file This file can be used to populate another subject area in the same or a different Safyr repository On clicking this option you will be prompted for the file name of the subject area to be exported On accepting this the current subject area and its members will be w
35. Category to Flow Category Transparent Check table for reference categories Transparent Text table for reference categories Transparent Treasury Rates Table Transparent Transaction release Release procedure Transparent Transaction release Release procedure for detail param Transparent ATRESERVATION Offer Acceptance Reservation Indicator Transparent 2 g T 0 3 0 g g 0 g 5 0 0 g 0 2 he No of Records 90473 Change No of Rec Limit The Model Overview form For each table the following fields are displayed Table Name The physical table name 7 Short Desc The logical name m Tbl Type Possible values are TRANSP Transparent POOL or CLUSTER POOL and CLUSTER are only applicable to SAP systems No of Child Tbls The number of related child tables No of Patent Tbls The number of related parent tables USER GUIDE BROWSING THE METADATA IN SAFYR Row Count The number of rows in the table See How Safyr determines the Row Count below Below the grid are a set of controls for moving through the result set No of Records 7909 Change No of Rec Limit From left to right these will Move to the first record in the result set Move to the previous record in the result set Move to the next record in the result set Move to the last record in the result set The total number of rows in the result set is displayed next to No of Records By defaul
36. DE_ID Tree Node Id DD_TABLENAME Table Name USER GUIDE 88 THE SAFYR META MODEL Table Name DD TREENODE_ VIEW Definition An intersect between a Tree Node and a View Table Column Name Table Column Comment DD_TREE_ID DD_TREENODE_ID Tree Node Id DD_VIEWTYPE For a future release of Safyr DD_VIEWNAME Table Name DD TREENODECLASS Definition A classification of a Tree Node Table Column Name Table Column Comment DD_TREE_ID DD_TREENODECLASS_ID Tree Node Class Id Node Class Should this Tree Node type be deleted if there are no levels below it Possible values are SY or N Table Name DD_TREENODECLASS_DESC Definition The descriptive text for a Tree Node Class SHORT_DESC S G O DESC SUFFIX o G O Table Name DD TREESTRUCT Definition The link between a Parent and Child Node in a Tree TEMP_EXTRACT_INFO o oo O Table Name DD_VIEW Definition Details of each View a View can be a Database View or an abstracted view TEMP_EXTRACT_INFO o d O TECH_DESC S G O Table Name DD_VIEW_DESC Definition The descriptive text for a View Table Column Name Table Column Comment DD_VIEWTYPE For a future release of Safyr DD_VIEWNAME SHORT_DESC _ _ _ _ _ S G O LOGICAL_UNIQUENAME o O So o O ONG DESC S o O USER GUIDE 89 THE SAFYR META MODEL Table Name DD_VIEWFIELD Definition A View Field is an attribute of a View View Field Name DD_VIEWFIELDTYPE The View Field type Possible
37. E N E eset 15 Del Groane Bi CO im parisOr DE Ue eina sinus EENET T9 52 Peffotmmino the Subject Area Compa SON irar rien renen EN ENEAN R ANONA 77 Dede Remera COA SO mi E E E nestenm caeteet N O ra BA Anane Te COMmmpatisON tepo ienn nan EN NOEN O 78 6 Special Product Features fot SAP BW srecen esra a S 79 Gls O Sal VEreDresents ATO GU DES aiene e docu eseaned O ONE 79 OGA Whe Model verview And DNN ar a OS 80 6 2 1 Using Advanced Search to select BW Table types sesseeseseseseseseseseseseresrserrereersrseses 81 65 The Applicaton Hicrarchyand BWocnornedi ierant ne a EE EEA 81 6 3 1 Chieesine wic merae hy tO USC arenen an NE NE E 82 6 4 Right Mouse Click Options for BW Repositories 0 eee eeecseesecsecsecsecsessecsecseesecsesseseeseeeseeees 82 64 1 RMC Options from the Model Overview s ssesesesrersrersrserrrererrrsrsesesrsrsrsrsrerererrrerereeess 82 6 4 2 RMC Options from the Application Hierarchy eessseeseeeeseeseesseecsessesseeeseesees 83 Appendix A The Safyr Meta Models siicscscsissasacevasacauecawnssctwahesanevawncactvonssanevenasacwwouseanyeonanasoeess 84 Appendix B Adding Additional Relationships sescschesatsvssassdesctevatwoncanstosateuenssasansteoatswensemtansd coats 91 Bal Understanding the Peoplesoft and DE dwards rules sheets iissctesiciseiastosss tradeiecieneas aceatenntaads 92 B 2 Special Considerations for PeopleSoft Relationships eesssessessseseseeesesrseseseseseserrrreresesrsrsrsesrsrsess 93 B Don
38. IndexMembers Reorganisation of Repository after Extract Generate ERP Based Relationships Ma Generate Rule Based Relationships Extraction Options after selecting Starting Step for Rule Based relationships B 7 What happens if a spreadsheet rule conflicts with an Existing Relationship If at least one rule based relationships is identifying for a child table than all other identifying relationships ERP derived or Extended are removed for that child table This is an implicit Delete function to allow an existing relationship to be replaced by a user defined rule B 8 Method for Generating Extended Relationships This Extended Relationship process involves an automatic search for possible pairings of Primary and Foreign Keys The process involves up to 6 passes through the Safyr Repository For SAP only pass 1 is USER GUIDE 96 ADDING ADDITIONAL RELATIONSHIPS applicable For PeopleSoft Enterprise only the first 3 passes are applicable and J D Edwards EnterpriseOne systems will require all 6 passes B 8 1 Pass 1 identifying relationships The first phase involves selecting all Tables with at least 2 Primary Key Fields for SAP where the first Primary Key field has the physical name of MANDT or for PeopleSoft where the first Primary Key field has the physical name of SETID the selection will be for at least 3 Primary Key Fields The last field in the Primary Key must not be part of any existing Rel
39. METADATA IN SAFYR Hei Table KNA1 General Data in Customer Master p EE Manor T GBikunner a E LAND1 HE NAME 1 HE MAME2 HE ORTO1 Hrsz F Af REGIO HE SORTL HE Mcop1 HE Mcop2 MCOD3 ANRED Af AUFSD H BAHNE HH BAHNS HF BBENR BBSNR BEGRU a HEBRSCH BUBKZ HE DATLT HH ERDAT AA erin ana lt Displaying Field Details Posit L 2 3 4 5 6 T 8 E 10 11 12 14 15 am BaURRERB ES amp J 3 _Fieldtext Client Customer Country Name Name 2 City Postal Code Region Search term Street Telephone 1 Fax Number One time account Address Name Name 2 City Title Central order block Express station Train staton Int location no 1 Int location no 2 Authorization Grour Industry Check digit Data line Created on ee ae ae wie Field Details Field Name short Des rot keyg i varaat A wentie sd d Data Element Domain Info mannm TS SSCSCSCSCSCSCSCSC SdY short ese bataType eRe Sore I ene pa J Desa mye O SSC drA Descriptions T technical Desciption Field T Data Element Data Elem T Domain Number under which a business partner s telefax machine can be reached a The number is used by the system if you send a message by telefax to your business partner from within an SAP transaction You are entering an order and want to send the order confirmation to your business partner by telefax As the print option you choose
40. Node Table Name ENA1 _ Short Description Found Items 239 Found Item Path within the Hierarchy E General Data in Custom MM Materials Management MM IM f Inventory Management MM IM ED E E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E E General Data in Custom MM Materials Management MM IM Inventory Management MM IM ED E we i gt Table Search result Once the search is complete double clicking on an item in the search results will position the Application Hierarchy at that point ERP Hierarchy BE Tree 54P Program Tree Ea IBEV2 EDSTEUK2 Vendors EU Spe E a E a E a fe IBEY2 EDSTMAT Call Maintenances fa BEVZIEDSTSLAG Call Maintenanc GPS BEVZ EDSUBST_YHS PANMI j Tax Gf BEV2 EDSYBSB1 Inventory Note nen J ENAL dee bP Search H fa IBEVZ EDSVBSB2 Sparkling Wine I Gf BEV2 EDTEXTED Maintain Text Mj Short Description ff IBEVZ EDTOOL_BWARTZLBGRP S ff BEVZ EDTOOL_LIS_ OPTIMIZE Sp a fe BEV2 EDWE f Excise Buty Furthe Gl fs BEVZ EDWF_BW_SCHWUND Add Gl f BEVZ EDWF_BW_SCHWUND_2 4 af IBEVZ EDXFCKO
41. ORERE O 48 PO CEIA e POrC Or CADIS Ait ULC aaa aa a 50 rol Ppor al EOI aDeSe a Mere A merry eee E eT ne ee mtr ON 51 Dod Veva Mod lous UC aa a a aa a ne Aasusved states 52 o Mao gl shad mpg ol onl Doe a A a 53 IIA OUD EC ATA anaE aya con tanitaes ayes E A E te hasten COTTO 54 39 Manane ogbje eA IS naa e E N N NIN 55 DOG Addin fables to aoue Ae A n N O O 56 3 36 1 Populating a Subject Area from the Model Overview tuntiwestinnetiocel isaac 56 3 36 2 Populating a Subject Area from the Related Tabled pop up menu eee 57 3 36 3 Populating a Subject Area from the Application Hierarchy sesser 59 3 37 Expanding a Subject Area with related Parent or Child tables eeeeeseeseeeeeeeseeeeeeeees 60 3 38 Creating additional Relationships not extracted from the source Application essees 63 3 39 Creatine additional Relinons hips irisan narn enen n AEn EN E ETE A EAS 64 240 Reyeb wine renc raed We Atl OSI DS eaaa E E ETE 64 3 40 1 To delete a Rules Based or Extended Relationship sesessesesesessssesesesrsrsrsesesesrrrrereeess 65 EP Xxpoctin metadata from Saly ieres annain a E E E E T 66 Al Geren eA COCR OL AEEA TAERE AERO EE OS 66 42 NIVEA VCXO EE FO PINAL e a E TON E ENORA ERIT O CANOE AE 70 d Ee RDORmNS otie oa ER Daam e a O 71 4 3 1 THe ER Dacor TIDA rore e a tre sen tr re ae Ce en nt cre cnnr tT T2 4 3 2 The ER Diagrammer Right Mouse Click Menu sssssssssessesrerserereersesrrreerseserreerseserreees I Companna VIN CLA CAA cries ties nE E E O
42. S B 8 7 Influencing the Extended Relationship generation process for PeopleSoft and JDEdwards relationships When inferring relationships for PeopleSoft Enterprise and JDEdwards there are often circumstances where there is more than one potential parent table for a relationship Users can influence the relative importance of a table by making entries in the SafyrSettings xls file see Appendix B of the Safyr Getting Started Guide for details of the SafyrSettings xls file The worksheets PSoftRuleBasedRelationships and JDOEDRuleBasedRelationships contain a column named ExtRelGenParent where a Table Name can be recorded The generation rule is that if there is more than one potential Parent for a relationship the inference process will use this list to help determine which to use USER GUIDE 99 INDEX Index Advanced Search 18 Application Hierarchy 35 36 available actions 37 JDEdwards 41 Oracle EBS 41 PeopleSoft 41 SAP 41 Siebel 41 comparing metadata creating file for 75 results of 77 78 context pop up menu 34 CSV export format 70 data drilling into 42 exporting 34 45 Data Elements 16 searching for tables using 32 Domains 16 searching for tables using 34 ER Diagrammer 71 toolbar 72 Extract Log 53 indexes 26 InfoCube 79 JDEdwards relationships 99 Licensing 8 Licensing Information 13 menus 10 11 metadata browsing 14 exporting 66 Model Overview 14 Data
43. S T me J PI a A a ee a a USER GUIDE BROWSING THE METADATA IN SAFYR 3 1 3 The Safyr toolbar The Safyr Toolbar options are summarized in the following table See the referenced section to find out more on each option Repository Manager Chapter 2 The Repository Manager Show Model Overview The Model Overview in this chapter Show Application Hierarchy The Application Hierarchy in this chapter Edit Subject Areas Subject Areas in this chapter lane tension id SS ef Show View Details Using the Overview to browse views in this chapter a EO ee U USER GUIDE BROWSING THE METADATA IN SAFYR 3 2 Safyr options The Safyr Options form is displayed by selecting Safyr Options from the Tools menu The available options are Ask before closing application When checked on you will be asked to confirm that you wish to exit when closing Safyr down When not checked Safyr will close down without the confirmation form Repository Definition file Use this to specify the location of the Safyr ini file Repository Language Where the extraction of metadata has been performed in more than language this option allows the selection of the language for displaying language dependent data such as attribute and table names Safyr Option form 3 3 Licensing Information Safyr needs an appropriate licensing key not only to enable the product usage but
44. SAPDMC LS_DATAELEMENT SAPDMC LS_DATUM SAPDMC LS_DOCUELEMENT SAPDMC LS_DOCUELEMENTTXT SAPDMC LS_DOMAIN SAPDMC LS_EDIDC40 SAPDMC LS_FILE_CONV SAPDMC LS_FILE_CONV_LOG SAPDMC LS_FILE_READ SAPDMC LS_FILENAME SAPDMC LS_FILENUMBER SAPDMC LS_FILEPORT SAPDMC LS_FILETEXT Short Desc Enhancement Constant Counter Data Element Date of Last Change Documentation element Documentation Element Name Domain EDIDC40 Target Stro File for Converted Data Logical File for Converted Data File for Imported Data File File No File port Name f Grid Filter Data Elmnt Name SAPDMC LS_CIMTYPE Short Desc Long Desc Screen Texts Enhancement DD Text Enhancement of Basis Type i SAPDMC LS_FILETYPE File Type 1 Legacy Data D 2 Imported C H d P H No of Records 91167 Change No of Rec Limit Model Overview Data Elements Clicking on a Data Element in the list box on the left reveals full details of that Data Element on the right of the form The search facilities at the top of the form are similar in function to those for Base Tables and described in Selecting Tables in the Model Overview above 3 17 Searching for tables using a Data Element This feature finds all the tables using a specified Data Element From the Model Overview Data Element form right mouse clicking on a Data Element reveals a pop up menu showing Find Tables using DataElement When
45. SILWOOD TECHNOLOGY LTD Satyr Metadata Explorer User Guide SILWOOD TECHNOLOGY LIMITED User Guide Safyr 6 0 This product is subject to the license agreement and limited warranty accompanying the product The product software may be used or copied only in accordance with the terms of this agreement Information in this document is subject to change without notice No part of this manual may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying and recording for any purpose without the express written permission of Silwood Technology Ltd or Authorised Silwood Technology Distributor Copyright 2005 12 Silwood Technology Ltd All rights reserved Table of Contents 1 TYPO CG CEO soins ceasiaeeosiceasuesse es Bese N TE ae sae 4 Bel Whacdo Time whi Need cipe aaa aAa aE a Eai 4 FI Instligo and CO MTOU TIO ara ssdearcnsancesttaceeseetaboseadasdutuetshetendaandt anacan arenai ai iani 4 I2 Extracting metadata from the Enterprise Application se ssssesssesrsrsrsesesserrreresresrerseses 4 1 1 3 Exploring the contents of the Satyr repository e esesseeressesreererresrsererresreererrenrsererrenreeses 4 1 1 4 Exporting metadata from Safyr into other eEnNVironments essesseseseserererererreereeseses 4 E EE E a eras Sea T E A eenite 4 The Repository Managerin inna eE R E OT aa 5 Dil Ropostorn Maina Ct tool par soeoreoiri anr en OEE AA A E A A A 6 2 2 Editing repository settings
46. THE SAFYR META MODEL Table Name DD_INDEX Definition An Index is a definition of a database index for a Table Table Column Name Table Column Comment DD_TABLENAME Table Name DD_INDEXNAME DD_INDEXTYPE The Index Type A for Alternate I for Inversion Entry P for Primary Key Index TECH_DESC Table Name DD_INDEX_DESC Definition The descriptive text for an Index SHORT_DESC o G O ONG_DESC oo G O Table Name DD_INDEXITEM Definition An Index Item is a definition of a field that belongs to an Index POSIT S G O DD_FIELDNAME S S O DESCENDING Indicates if Index Item is a Descending Index Item possible values are Y or N Table Name DD_LANGUAGE Definition A definition of a Language for descriptive text fields Table Column Name Table Column Comment DD_LANGUAGE_ID Language Code SHORT_DESC a Table Name DD_RELATIONSHIP Definition A Relationship defines a link between two tables DD_RELATTYPE The Relationship Type I for Identifying N for Non Identifying DD_CARDINALITY The Relationship Cardinality Possible values are ZM Zero one of more 1M One ot more Z1 Zero or 1 E1 Exact 1 DD_ORIGIN The origin of the Relationship Possible values are E from the ERP XR Extended relationship RR Rules Based relationship TEMP_EXTRACT_INFO LS TECH_DESC ts USER GUIDE 86 THE SAFYR META MODEL Table Name DD _ RELATIONSHIP DESC Definition The descriptive te
47. Workplace ApplComp KM Knowledge Management ApplComp EHS Environment Health and Safety ApplComp LO Logistics General ApplComp FI Financial Accounting ApplComp TR Treasury ApplComp Fa TR CB Cash Budget Management ApplComp FS TR CM Cash Management ApplComp fa FFLQ Liquidity Calculation DevClass E FLOACC_ACT Liquidity Calculation Other Actual Accounts E FLQACC_INFO Liquidity Calculation Accounts with Assignment Informatior ES FLQOBANK_GRP Liquidity Calculation Assignemnt of Acct to Query Sequenc E FLOCOMPANY Liquidity Calculation Company Codes ES FLQGRP Liquidity Calculation Query Sequences EE FLOGRP_OR Liquidity Calculation Queries for Sequence E FLOQGRPT Liquidity Calculation Texts for Query Sequences EE FLQHEADMA Liquidity Calculation Header for Manual Transfer Postings EA PEME Lipami _ _ i Ui E E D E aE E a E E E E E E E E E E E The Application Hierarchy The Application Hierarchy is presented as a tree structure Click the and icons to open and close successive tree nodes The set of highest level tree nodes correspond to the various modules within the Enterprise Application USER GUIDE 36 BROWSING THE METADATA IN SAFYR Various icons ate used in the hierarchy as follows i indicates a module or a sub module E indicates a Table E indicates a View 3 22 Available actions from the Hierarchy Right Mo
48. and Indices Syne DO FIELD get OG DOMAINNAMES From OD DATAELEMENTS Application Hierarchy Delete DD TABLES without Fields Sync OD FIELD Key Flags with Primary Key IndexMembers Reorganisation of Repository after Extract Generate ERP Based Relationships Generate Rule Based Relationships way Generate Extended Relationships Setting the extraction options to only run the Generate Relationships process 3 40 Reviewing generated Relationships Safyr creates rules based and extended relationships using the approach described above Using such an approach it may be possible that relationships are created that do not have a real world existence To accommodate this a Delete feature is available to physically remove the relationship from the Safyr repository USER GUIDE BROWSING THE METADATA IN SAFYR 3 40 1 To delete a Rules Based or Extended Relationship Locate the Relationship to be removed and open the Relationship details in the Table Details form Right Mouse Click on the join conditions of the chosen relationship to show a pop up form fs Table ALLOC P_SEL Allocation Pool Selector thl O x Relations Fieldtext Se Field Name CHARTFIELD FA a CHART ChartField Table DD Text Extended by Saphir Info Foreign Key Type ostane O i ceshaton bed Fields Cardinality Left Cardinality Check Flag iz E3 i Rels KSEC_CHARTFIELD KSEC_CHARTFIELD ALLOC_P_SEL Allocation Pool Selector tbl
49. as search criteria The available options are Field Name Enter a Field Name or Partial Field Name Position Use the scroll bar to select the actual numeric position of the field in the table Key Flag toggle between Key Field X Not Key Field empty or Wild Card Data Element Name Enter a Data Element Name or Partial Name Having entered the appropriate search conditions click OK to perform the actual search USER GUIDE 20 BROWSING THE METADATA IN SAFYR The Extended Filter form has features for entering multiple selection criteria in one query Filter Tables by Standard Filter Search For Field Patkerns Extended Filter Enter Multiple Search Criteria Tol Mame Clear Filter IK Extended Filter This form can then be used to enter search criteria similar to those described for the Standard Filter form However multiple search criteria can be entered by adding additional lines to the search Lines are added by using the Down Arrow Key The following example shows a query that looks for tables starting with an A or a I and having Parent relationships between 1 and 10 child tables Filter Tables by Standard Filter Search For Field Patterns Extended Filter Enter Multiple Search Criteria Tol Mame Short Desc Example with multiple selection lines USER GUIDE 21 BROWSING THE METADATA IN SAFYR 3 11 Sorting columns in data
50. ationship These form the set of potential Child Tables for identifying relationships For each of the tables in this set a search is made for a match of all the Primary Key Fields minus the last Primary Key field for a parent table with the same set and order of fields These are potential Parents of a 1 N identifying relationship In addition to the above criteria For SAP and PeopleSoft only Parents with existing Children are selected For J D Edwards EnterpriseOne only Parent Child Relationships that are represented by a join in the EnterpriseOne Business Views are considered Given the above criteria if exactly 1 Parent is found then a relationship is added If more than 1 potential parent is found then For SAP the parent table showing to the Default Domain Lookup Table is selected If the potential parent already has its own Parent based upon the same field set then this same relationship is also applied to the child For example if Table A is already a parent to Table B and a potential child table Table C to Table B is found with the same potential foreign key then Table C is made a child of Table A not Table B For J D Edwards EnterpriseOne if the first 3 Characters of the Table Names of the two tables correspond then this Parent is chosen For PeopleSoft reference is made to the PSOFTHINTS area of the Safyr ini file to see if there is a preferred parent listed s
51. ckage USER GUIDE 77 COMPARING METADATA E Compare Subject Areas Choose Models to Compare Reference Model C temp cost46 mta C temp cost47 mta compare only objects existing in both models Attribute MANDT Lbl Client lt gt MANDI Attribute MANDT Lb1lShort Client lt gt MANDI Attribute STERKZ Lbl Tax relevant lt gt STEUR Attribute STEKZ Lb1lShort Tax relevant lt gt SIEUR Attribute USNAM Lbl Created by lt gt ERFHH Attribute USNAM Lb1lShort Created by lt gt ERFNM Attribute ZAHEZ Lbl Affecting payment lt gt K2zZAH Attribute ZAHRZ Lb1lShort Aftfec pay lt gt K2zAH Attribute ABTEI Lbl Department lt gt ABIEI Attribute ABTEI LblShort Department gt ABIEI Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Results of a Comparison 5 4 Analyzing the comparison report The results shown in the Comparison Report will depend upon which of the two models is chosen as the Reference model The terms Reference Model and New Model are arbitrary and really only serve to differentiate the two models The report has two major sections The first compares objects in the Reference Model with those in the New Model and for each of the object types Domain Attribute Entity and Relationship identifies where a given instance of these object types is not in the New Model or
52. cs Statistics Repository ECCS Description Number of Dictionary Languages 2 Number of Dictionary Settingss 3 Number of Domains 50158 Number of Domain Descriptions 100316 Number of Domainvalues 91301 Number of Domainvalue Descriptions 182602 Number of Tables 47975 Number of Table Descriptions 95950 Number of Data Elements 113471 Number of Data Element Descriptions 226942 Number of Fields 508024 Number of Field Descriptions 1016048 Number of Indexs 57604 Model Statistics USER GUIDE 52 BROWSING THE METADATA IN SAFYR 3 33 The ERP Extract Log During the extraction of metadata from the chosen Enterprise Application Safyr records a log of the extraction steps in the form of an XML file This log file can be viewed by selecting Show ERP Extract Log from the Safyr Tools menu 5 Extraction Log Viewer Sle File Name C Program Files Silwood Saphir ExtractLog Saphir_EPR_ Extract BWSaphir5 MSSOL_20080314151757 ml E JA SAP Repository Extraction Mode Run 14 54 42 00 23 13 y Saphir Environment 14 54 42 Msq E v Repository BWSaphir5 14 54 42 IMsqg v prepare cear affected repository tables 14 54 42 00 01 48 Empty Table DD TREENODE VIEW 14 54 42 Empty Table DD _TREENODE TABLE 14 54 42 Empty Table DD TREESTRUCT 14 54 45 Empty Table DD TREENODE DESC 14 54 45 Empty Table DD TREENODE 14 54 46 Empty Table DD _TREENODECLASS DESC 1
53. d Relationships The following sections describe these features in detail USER GUIDE ADDING ADDITIONAL RELATIONSHIPS B 1 Understanding the PeopleSoft and JDEdwards rules sheets The SafyrSettings xls Excel spreadsheet is located in the Safyr installation folder normally Program Files Silwood Safyr 6 There are two sheets in the spreadsheet for influencing the relationship creation process PSoftRuleBasedRelationships for PeopleSoft and JDOEDRuleBasedRelationships for JDEdwards The PeopleSoft rules sheet has a layout as shown in the following example The JDEdwards sheet has an identical layout A AAP_YEAR_GOALS AAP_YEAR AAP_YEAR_JOBGRP AAP_YEAR AAP_YEAR_JG_GLS AAP_YEAR_JOBGRP VENDOR_ADDR VENDOR 6 VENDOR_ADDR_LNG EFFDT VENDOR_ADDR 7 VENDOR_ADDR_PHN VENDOR_ADDR VENDOR_ADDR_TMP VENDOR_ADDR VENDOR_CNTCT VENDOR VENDOR_LOC VENDOR VENDOR_LOC_TMP VENDOR_LOC VENDOR_PAY VENDOR_LOC VENDOR_PAY_TMP VENDOR_PAY VENDOR_POLICY VENDOR VENDOR_SF_TBL SETID VENDOR_ID VENDOR VENDOR_SF_TBL EXT_ORG_ID VENDOR EPPCM_CATG_HIER EPPCM_CATEGORY EPPCM_CATG_HIER EPPCM_PARPORTALNM EPPCM_PARCATGID EPPCM_CATEGORY 4 gt DataTypeMapping ERP TypeNaming ERPTypeLanguages PSoftRuleBasedRelationship W mo o il PeopleSoft Rules Sheet of SafyrSettings xls The spreadsheet columns are as follows m ChildTableName The name of the Child table for the relationship ChildFieldNames See Defining a Rule below for details of
54. e FV table Star Schema Logical Model The Fact and associated Dimension tables are added Snowflake Logical Model The Fact Dimensions and associated Characteristic tables are added Extended Logical Snowflake As for the Snowflake Model but in addition any Characteristic table parent tables Characteristic tables related to Characteristic tables are also included 6 4 2 RMC Options from the Application Hierarchy When Right Mouse Clicking on a Logical or Physical Fact Table in the Application Hierarchy similar options are available to those described for the Model Overview above USER GUIDE 83 THE SAFYR META MODEL Appendix A The Safyr Meta Model Below are descriptions of the Tables that make up the Safyr Meta Model Each table is briefly described the attributes listed and comments provided where applicable Table Name DD _DATAELEMENT Definition A data element is a definition of an attribute independent of an entity Table Column Name Table Column Comment DD_DATAELEMENTNAME Data Element Name DD_DOMAINNAME DD_ORIGIN Possible Values E from ERP GE Generic Element generated by Safyr TEMP_EXTRACT_INFO po TECH_DESC SS Table Name DD _DATAELEMENT DESC Definition The descriptive text for a Data Element SHORT_DESC _ _ _ __ S G O LOGICAL_UNIQUENAME o O So o O ONG_DESC o G O Table Name DD_DOMAIN Definition A Domain is a generic definition of an Attribute type DD_ORIGIN Possible Val
55. e included in a Subject Area expansion USER GUIDE 60 BROWSING THE METADATA IN SAFYR Possible Settings are Follow Parent Relationships This option will include any tables that have Parent relationships to the tables in the Subject area chosen For each of the two options available the level number dictates how many generations of ancestors to include 1 indicates direct parent ancestors 2 would indicate parents of the parents and so on The two further options within this are o Indentifying relationships up to level includes those relationships where the primary key fields of the parent table form part of the primary key of the child table Oo Non Identifying relationships up to level includes those relationships where the primary key fields of the parent table do not form part of the primary key of the child table Follow Child Relationships This option will include any tables that have Child relationships to the tables in the subject area This option is further qualified by the next option of Type Type this determines the scope of the child related tables to be included Possible values are All child relationships Identifying only child relationships only includes child tables where the primary key fields of the parent table form part of the primary key of the child table Limit To The Maximum Number of Entities to be assembled 0
56. e to use If the model is to be a logical representation of a cube then Logical InfoArea Tree would be the start point 6 4 Right Mouse Click Options for BW Repositories Special Right Mouse Click RMC options are available for Safyr BW Repositories These RMC options are only available when a Subject Area is open There are two areas where these RMC options are available 6 4 1 RMC Options from the Model Overview Choosing to RMC on a Fact Physical Fact table in the Model Overview when a Subject Area is open will display a popup menu that includes the option Add SAP BW Physical Cube lt cube name gt to Subject Area lt subject area name gt ibiNeme __ bert Desr____ 1 Type _ No ofc fo of Porent Ti E BI0 FOBA_FDCO1 Spr Sheet and Profit and Loss Statement BW zem F a B10 FOBA_FDCO3 F BA Financial Data Mart BW Fact F 810 FOBA_FDco4 F BA FI GL BW Fact F fy BIO FOBBP_CO1 F Global Spend Point to Point Connect BW Fact F E BIO FOBBP_CO F e Procurement Account Assignment Totals Records BW Fact F i BIO FOBWTCFC1 F BW Technical Content FC1 BW Fact F 810 FOBWTCFC2 F BW Technical Content 2 BW Fact F ie BIO FOCCA_CO2 F CO0 OM CCA Costs and Allocations by Activity TypeBW Fact F 810 FOCDM_co F Credit Profile BW Fact F F Liability BW Fact F BIO FOCDS cO1 F Service Level Order Schedule Lines BW Fact F m BI0 FOD_DECU F SAP DemoCube BW Fact F g BI0
57. ect area lt subject area name gt This option is only available if the Subject Area form is open See Subject Areas later in this chapter All the tables and or views belonging to the node are added to the current subject area Expand Sub Tree opens the currently selected node 3 23 Searching for tables and views in the Application Hierarchy Clicking the Search in Hierarchy or Search in Branch options in the Application Hierarchy pop up menu displays the Search form This has three tabs the first two are for searching for Tables and Views respectively Both features work in the same way and the Search for a Table option will be used here to describe the functionality i Search in SAP Application Devllass Tree Seles For a Table for a view for a Tree Node Found Items O Found Item Path within the Hierarchy Search Tables feature To find the location of a table in the application hierarchy or currently selected node enter the physical Table Name or logical Short Description string and click the Search button A list of matching tables will then be displayed USER GUIDE BROWSING THE METADATA IN SAFYR Note that the Table Name and Text search fields have the same searching options as described above for the Model Overview see Selecting Tables in the Model Overview El Search in SAP Program Tree For a Table for a view for a Tree
58. ee the section Influencing the generation of additional PeopleSoft relationships below If no parent is found in the ini file then the first of the available potential parents is chosen These steps are then repeated for smaller sets of Primary Key Fields down to J D Edwards EnterpriseOne 1 Field SAP If Primary Key Field 1 is MANDT then MANDT plus 1 Field otherwise 1 Field PeopleSoft If Primary Key Field 1 is SETID then SETID plus 1 Field otherwise 1 Field USER GUIDE 97 ADDING ADDITIONAL RELATIONSHIPS B 8 2 Pass 2 identifying relationships PeopleSoft amp J D Edwards EnterpriseOne only This is the same as Pass 1 but For J D Edwards EnterpriseOne the requirement for there to be a corresponding join in the Business Views is dropped and instead only Parent tables with existing Child tables are considered For PeopleSoft only Parent tables that were found as Child tables in Pass 1 are considered as new potential Parents and with only 1 level of difference between the Primary Key and potential Foreign Key attributes B 8 3 Pass 3 identifying relationships PeopleSoft amp J D Edwards EnterpriseOne only This is the same as Pass 2 but For J D Edwards EnterpriseOne allows any order of the attributes in the Parent to Child Relationship For PeopleSoft Enterprise no restriction on the number of levels of difference between the Primary Key and potential Foreign Key attribu
59. has different properties to the New Model Where the properties are different the difference is identified The second report section examines the same set of object types looking for instances of those objects that are present in the Reference Model but no longer exist in the New Model USER GUIDE SPECIAL PRODUCT FEATURES FOR SAP BW 6 Special Product Features for SAP BW Describes features in Safyr that are specific to working with metadata from a SAP BW SYSTEM representation multi dimensional reporting Cubes known as InfoCubes The main aim of the Safyr features for a SAP BW instance is to represent an InfoCube in the form of a Star Schema S AP BW Also known as SAP BD is a particular type of SAP system largely orientated around the Once the metadata from a SAP BW system has been loaded into Safyr there are a number of BW specific features that make the process of creating a Star Schema easier 6 1 How Safyr represents InfoCubes There are two popular approaches to the representation of multi dimensional feature such as an InfoCube A Star Schema A Fact Table and its related Dimensions A Snowflake A Fact Table associated Dimension tables and one or more levels of related Master tables known as Characteristics in BW Safyr extracts and stores the appropriate BW tables to allow both these representations In addition Safyr can display an InfoCube in both Logical and Physical forms To achieve a
60. he rules 1 RoleNames Parent table with Primary Key fields ParentA ParentB ParentC Child table fields of ChildA ChildB ChildC To form a relationship where ParentA maps to ChildA ParentB to ChildB and ParentC to ChildC the ChildFieldNames would contain USER GUIDE 93 ADDING ADDITIONAL RELATIONSHIPS 2 3 4 B S ChildA ChildB ChildC Partial Relationships Same Parent and Child tables as example 1 but the relationship is to be formed from ParentA mapping to ChildA and ParentC to ChildC In this case the ChildField Names would contain ChildA ChildC ChildA ChildC would have the same result Last Attribute Rolenamed Parent table with Primary Key fields AAA BBB CCC Child table fields of AAA BBB TTT To form a relationship where AAA maps to AAA BBB to BBB and CCC to TIT the ChildFieldNames would contain REPLAST TTT Include optional Attributes Parent table with Primary Key fields SETID BBB Child table fields of SETID BBB To form a relationship where SETID maps to SETID and BBB to BBB the ChildFieldNames would contain SETID Adding rules to the spreadsheet Safyr users may want to add rules to the spreadsheet in order to create additional relationships in the Safyr repository Before doing this copy the SafyrSetting xls and use this to create a copy named SafyrSettings_Cust xls in the Safyr installation folder Then add the required rules to this SafyrSetti
61. hes A subject area can be used in combination with the other Safyr search capabilities to limit the scope of the search being performed E g Find me all the tables that have a field with the text order date in the field description that are in the Warehouse subject area Export into other tools The subject area is the vehicle for exporting data definitions into any of the Safyr tool interfaces All the tables of the subject area will be exported to the chosen tool The members of a subject area are simply references to the tables and views grouped in that subject area Deleting a subject area member only deletes the reference to that table or view and not the table or view itself The contents of a subject area can be moved from one subject area to another using the subject area import export feature described below USER GUIDE 54 BROWSING THE METADATA IN SAFYR 3 35 Managing Subject Areas To create delete or change a Subject Area click the ly icon on the Safyr toolbar or select Subject Areas from the Edit menu This will display the Edit Subject Areas form which has features for creating and populating subject areas El Edit Subject Areas fe Edit Subject Areas Select Subject Area ML Xx Totalo Elements the selected subject area contains Table View Mame Table view Description Delete EBS Delete al To add a table drag amp drop it From the Model Overview Related Tables or
62. hy USER GUIDE BROWSING THE METADATA IN SAFYR 3 37 Expanding a Subject Area with related Parent or Child tables The sections above have dealt with populating a Subject Area by finding tables and adding those tables to the Subject Area The Subject Area itself can also be used to expand the tables in the Subject Area by finding the related Parent and or Child tables This feature uses the tables already in the Subject Area as seed tables The user can then choose options that will generate a list of tables related to each table in the Subject Area to a user specified level of Parent and or Child tables This generated list can then be reviewed and the tables either added to the starting Subject Area or added to a separate Subject Area The expansion process is started by choosing the Subject Area containing the seed tables and then clicking the icon on the Subject Area tool bar This will display a screen for selecting the levels of related tables to be included E Expand Subject Area Set Relationship levels Please specify number of ParentfCchild levels Follow Parent Relationships IdentiFying relationships up to level Non identifying Relationships up to level Follow Child Relationships Down bo level Type identifying child relationships Advanced Settings Limit to Mo of entities O neo limit Include original Subject Area bables views in result lt back C Specifying levels of tables to b
63. ities or by putting selected tables into a subject area and loading the subject area into the model browser All tables selected into the Model Browser can be exported by Right clicking on the model browser and selecting Export Source Data Full Selection feom the pop up menu The Batch Export Properties form is then displayed Batch Export Properties x Path to export the Files Prefix for the Files Extention for the Files Set export properties For the export each table will be exported into a separate file in the chosen export directory Specify a Path for the location of the exported text files Select a prefix and extension for the expott files On clicking OK Safyr displays the same Data Export form used for a single table data export but without the Field selection feature After selecting the appropriate setting and clicking the OK button each table in the Model Overview selection is exported to flat file USER GUIDE 47 BROWSING THE METADATA IN SAFYR 3 29 Creating SQL scripts for table access This feature of Safyr is an aid to making direct access to the source application e g PeopleSoft easier for any tool that uses SQL to interrogate the data By selecting a base table a database view can be generated or a select statement that uses the business names as an alias The example below shows a view generated from SAP table A008 The Table Description from SAP beco
64. lable for use Export Data Model As 5 H Customer Material El General Data in Customer Master Attributes 193 HA General Data in Customer Master Domains 104 E General Data in Customer Master Rels 6 2 rE Division Customer oo M General Data in r Master a Ts Customer Material Pricing riip General Data in Customer Master Indexes 12 ai MER Customer Hierarchy Export Wizard Export Status USER GUIDE 69 EXPORTING METADATA FROM SAFYR 4 2 The CSV export format Whilst the available Export formats may vary depending upon the Safyr license agreement one Export Format is always present and that is the CSV Comma Separated Values Format This is a proprietary text based file aimed at providing a means to export metadata from Safyr for any third party tool to access The CSV format includes details of Tables Columns and Relationships and is in a self documenting format lt TABLES gt TABLE OBJECT ID PHYSICAL NAME LOGICAL NAME IS VIEW IS POOL POOLTABLE POOLDES C 0 MARA Material Master General Data 0O 0O lt END_ TABLES gt lt COLUMNS gt COLUMN OBJECT ID TABLE OBJECT ID PHYSICAL NAME LOGICAL NAME IS PK 1IS FKEY IS NULLABLE FULLSQLTYPE LEN DEC SOLTYPE DOMAIN DATATYPE POOLEXPR POOLDLLFLDNR 10001 0 MANDT Client 1 0 0 VARCHAR 3 3 0 VARCHAR CLNT 10002 0 MATNR Material 1 0 0 VARCHAR 18 18 0 VARCHAR CHAR L0003 0 ERSDA Created on 0 0 1 CHAR 8 3 0 CHAR DATS 10004 0 ERNAM
65. lable options will depend upon the Safyr product license m File Name and Location Use this control to specify a location and name for the export file Click the Next button to move to the next stage of the Export wizard USER GUIDE 67 EXPORTING METADATA FROM SAFYR The export functionality is influenced by the Building Options form which is the next step of the export wizard E Export Data Model s Step 3 Building Options Please select the options to build the export Follow Parent Relationships Identifying relationships up to level Non identifying Relationships up to level Follow Child Relationships Down bo level Type identifying child relationships Limit to Mo oF entities O no limit export using Physical Table Mames not Table Narnes Start Export Export Wizard Building Options Possible Settings are Follow Parent Relationships This option will include any tables that have Parent relationships to the tables in the Subject area chosen For each of the two options available the level number dictates how many generations of ancestors to include 1 indicates direct parent ancestors 2 would indicate parents of the parents and so on The two further options within this are Indentifying relationships up to level includes those relationships where the primary key fields of the parent table form part of the primary key of the child table Oo No
66. leName The content of the ChildFieldNames will depend upon the nature of the relationship Possible values for ChildFieldNames are as follows Leave blank to have a relationship built matching all the Primary Key attributes of the Parent Table with correspondinely named attributes in the Child Table Note for a PeopleSoft system this will exclude fields named EFFDT EFFSEQ and SETID see Special Considerations for PeopleSoft relationships above MYFIELD1 MYFIELD2 A list of the child field names that the Parent Primary Key fields are to be matched with The field names must be in the same order as the Primary Key fields in the parent table Note for a PeopleSoft system the optional fields EFFDT EFFSEQ and SETID cannot be specified MYFIELD3 or define fields within the parent table that do not have a corresponding field in the child table XSMYFIELD2 X any simple string can be used is a fixed value in the Parent table not having a corresponding field in the child table REPLLAST MYROLENAME Uses the default field mapping between Parent and Child fields but replaces the last field name in with the field MYROLENAME EFFDT Only applicable to PeopleSoft EFFDT will be included explicitly in the relationship EFFSEQ Only applicable to PeopleSoft EFFSEQ will be included explicitly in the relationship SETID Only applicable to PeopleSoft SETID will be included explicitly in the relationship B 4 Examples of using t
67. ler Redraw the Diagram taking account of any display changes Resizes the Entity boxes based upon the length of the Entity name Autolayout Autosize by Text Length Copy to Clipboard as Copy the diagram to the Windows Clipboard e g Metafile for subsequent pasting into a Word Document USER GUIDE 74 COMPARING METADATA 5 Comparing metadata Describes how to use the Safyr compare feature to identify differences between subject areas from different repositories his chapter describes features for comparing metadata from two different Safyr repositories The two systems might be different release levels or different installations The feature requires the user to export one or more Safyr subject areas into a special comparison file format for each of the systems to be compared The comparison function then takes these comparison files and reports the differences via a text based comparison report Two Repositories will need to be defined for the two differing sets of metadata before the comparison can take place see Chapter 2 The Repository Manager for details of configuring repositories 5 1 Creating a Comparison File One of the Export To radio buttons on the Export Wizard is Comparison File Selection of this will create a special comparison file for use by the Compate routines To create a comparison file create and populate one or more Safyr subject areas as per normal Use these s
68. mes Record Counter Select this option to include a row count at the beginning of the export file m Column Names Click the appropriate radio button to include either Logical or Physical names as column headers m Field Separator Choose the appropriate character to act as a field separator in the exported file Boolean True or False allows the user to specify suitable text values by which to represent Boolean values in the file USER GUIDE 45 BROWSING THE METADATA IN SAFYR Field Delimiter Choose the appropriate character to act as a field delimiter in the exported file m Record Separator Choose the appropriate character to act as a record separator in the exported file The _ Fields button toggles the Field selector portion of the form on and off In the field selector you can select fields for inclusion in the exported file Once the export options have been set click OK to start the export The following progress form shows the export running DateTime Process started 06 11 12 13 00 10 4 File C temp data bet 06 11 12 13 00 10 ri 06 11 12 13 00 10 06 11 12 13 00 10 06 11 12 15 00 10 Export Progress Form USER GUIDE BROWSING THE METADATA IN SAFYR 3 28 2 Export of a number of tables This facility must be used with care as it will export all the data from any number of tables Firstly select the tables to be exported either using the various Safyr search facil
69. mes the View name and the Field Description for each field becomes an alias CREATE VIEW V_Plant_Additional_selling plant AS SELECT MANDT AS Client KAPPL AS Application KSCHL AS Condition_type WERKS AS Plant WERKYV AS Resale_plant DATBI AS Valid_to DATAB AS Valid_from KNUMH AS Cond_trecord_no FROM A008 3 29 1 To generate Views or Select Statements Right Mouse Click on the appropriate table in the Safyr Model Overview and choose Create SQL Scripts This displays the script creation form shown on the next page USER GUIDE 48 BROWSING THE METADATA IN SAFYR Show Table A008 Plani Additio nal selling pl _ ioj x to create a view W with readable field names with readable VIEW names Uppercase Statement Table Owner prefix for created views add Client where dause J add s at the end g Ma F Select all D Copy to Clipboard Close Script generation form The options on the left of the form dictate how the view or select statement is generated To create a view check this box to create a view leave unchecked to create a select statement With readable field names check this box to use the field name as an alias Uppercase Statement check to have the generated text in upper case characters Table Owner specify the database table owner to be used as a prefix to the Table Name in the generated text Prefix for created views s
70. n Identifying relationships up to level includes those relationships where the primary key fields of the parent table do not form part of the primary key of the child table Follow Child Relationships This option will include any tables that have Child relationships to the tables in the subject area This option is further qualified by the next option of Type Type this determines the scope of the child related tables to be included Possible values are All child relationships Identifying only child relationships only includes child tables where the primary key fields of the parent table form part of the primary key of the child table USER GUIDE 68 EXPORTING METADATA FROM SAFYR Limit To The Maximum Number of Entities to be exported 0 denotes no limit Export using Physical Table Names not Table Name This option only applies to PeopleSoft systems Checking this option will use the PeopleSoft physical name for the export rather than the internal Table Name An example of these two names is PS_PERSONAL_DATA Physical Table Name PERSONAL DATA Table Name Now click the Start Export button to begin the export process The export Status form is displayed to allow you to monitor the progress of the export This shows a hierarchy of tables being exported and a running total of the objects being exported Once this process has completed the exported information will be avai
71. n an existing Safyr repository Please note that this will delete the entire contents of the repository In each case Safyr executes a set of SQL scripts to perform the required database tasks USER GUIDE THE REPOSITORY MANAGER 2 7 The Repository ini file Safyr uses an ini file to record details of each Repository created In addition to this a Microsoft Excel file is used to store a set of options used by Safyr Appendix B of the Safyr Getting Started Guide gives details on the structure and purpose of this Excel file The Repository Inifile button on the Repository Manager allows the location and name of the ini file to be specified By default the file is called safyr ini and is located in the Safyr root folder typically Program Files Silwood Safyr 6 safyr int On clicking the button a form is displayed which allows you to specify the name and location of the file 2 8 Safyr Licensing The licensing screen shows details of any existing product license and enables the user to apply for a product license The actual options shown will vary depending on how the product was purchased 2 9 Managing Multiple Repositories Most Safyr customers will use the product to extract and store multiple sets of metadata from their chosen ERP environment s This section describes how to achieve this Safyr needs a separate database or schema for each set of metadata to be stored Each database will require a database user to be s
72. ng Description Bw Dim D BW Dim MP D BW Charact SID View R BW Charact 5 EP EW Charact Attr F Short Description Long Description Subject Area ID Clear Filter Advanced Search showing BW Table Types The Table Type selection can be used in combination with any of the other search features to limit the range of tables displayed in the Model Overview 6 3 The Application Hierarchy and BW There are two Application Hierarchies created in Safyr for BW In Both cases the nodes of the tree structure are InfoAreas An InfoArea is a BW concept for grouping together objects The two hierarchies are Logical InfoArea Tree This tree shows the hierarchy of InfoAreas with the virtual Fact tables FV prefix and ODS tables as the lowest node level Physical InfoArea Tree This tree shows the hierarchy of InfoAreas with the physical Fact tables F prefix and ODS tables as the lowest node level Both hierarchies will show identical sets of InfoAreas and in both cases the only tables represented in the hierarchy are Fact tables and ODS tables USER GUIDE 81 SPECIAL PRODUCT FEATURES FOR SAP BW 6 3 1 Choosing which Hierarchy to Use The purpose of the two hierarchies for BW is to aid in the location of the Fact table that will be the focus of the required model If the model is to show a physical representation of a cube with all the tables that are involved then the Physical InfoArea Tree is the on
73. ngs_Cust xls spreadsheet When the Safyr application is started if the file SafyrSettings_Cust xls exists then this will be used instead of the delivered SafyrSetting xls file USER GUIDE 94 ADDING ADDITIONAL RELATIONSHIPS B 6 Running an update to process new rules Rules added to the spreadsheet are actioned by running the ERP Extraction process However it is not necessary to run the entire extraction of metadata each time the extraction options can be set to only process the relationship creation elements of the extraction process From the Extraction Steps screen of the PeopleSoft or JDEdwards Extraction Wizard check the Generate Rules Based Relationships checkbox and then Right Mouse Click Now choose Select Start Step and Required Steps E PeopleSoft Enterprise Extraction Wizard WF Extract PeopleSoft Enterprise Data Extraction Steps Please define the extraction steps below keps Log Source DE Physical Connection Check PeopleSoft Enterprise Environment Clear affected repository tables or recreate the whole repository Log Repository DE Physical Connection Prepare the Repository Environment after deleting unused dataj DO LANGUAGES f Fill Languages Initialize Language Environment From OD LANGUAGES Domain DataElement DataElement Description default language DataElement Description additonal languages Table Table Description default language Table Description additional languages Check of
74. no RUC oine e EE ETNE NENTE 93 P Eximp orus ino Merile S ir n a A E A E EN NA 93 Bo Addin rral estone spr Idhe ionn N 94 BOG Running an update to Process NEW TULES woiisissaiiii aiaiai 95 B 7 What happens if a spreadsheet rule conflicts with an Existing Relationship eee 96 B 8 Method for Generating Extended Relationships eeseseseseresesesesesereuserssesssestsesesesenereseesesssesesesese 96 B 8 1 Pass Pidemtil ie Fela OMS hP arratea e E E ONU 97 B 8 2 Pass 2 identifying relationships PeopleSoft amp J D Edwards EnterpriseOne only slags aces PENE PEE PEE AEEA E anes ae seesaw ac dc ASA A R AEA S 98 B 8 3 Pass 3 identifying relationships PeopleSoft amp J D Edwards EnterpriseOne only AEE IE IE PE DNE IEEE E E E EE E P A OEE E A E E A E A E EAT 98 B 8 4 Pass 4 Dimension search J D Edwards EnterpriseOne only eessscressrereer 98 B 8 5 Pass 5 Dimension search J D Edwards EnterpriseOne only eesssscererersee 98 B 8 6 Pass 6 Dimension search J D Edwards EnterpriseOneOnly esseere 98 B 8 7 Influencing the Extended Relationship generation process for PeopleSoft and JIDEdwards Pe lA OMG iDo sats deosinemenaaneadankoaseatccuahdesgcuanienicucsientenanas 99 DENG OK eases dics eres sara AT rain ch asa a ean Ga cae ET eae eee 100 INTRODUCTION 1 Introduction Describes how to use this manual in particular the powerful features for exploring the metadata extracted from your chosen environment W elcome t
75. nt 1 has 3 Repositories defined SAP1 pointing to Database A using Table Owner A as the database user PSoft1 pointing to Database B using Table Owner B as the database user SAP2 pointing to Database C using Table Owner C as the database user Safyr Client 2 has the same 3 Repositories defined Safyr Client 3 is only interested in the PeopleSoft system PSoft1 pointing to Database B using Table Owner B as the database user Safyr Client 4 is only interested in the SAP systems SAP1 pointing to Database A using Table Owner A as the database user SAP2 pointing to Database C using Table Owner C as the database user USER GUIDE BROWSING THE METADATA IN SAFYR 3 Browsing the metadata in Safyr A detailed description of the features for browsing the extracted metadata aphir s main purpose it to make the exploration of the extracted application metadata easy to explore This chapter describes the various features for exploration in detail 3 1 The Safyr workspace When the Safyr application is started a list of available Repositories is displayed and after selecting the appropriate one the Safyr toolbar and menu options provide the means to explore the metadata The following sections describe the characteristics of the Safyr workspace 3 1 1 Elements of the Safyr workspace At the top of the Safyr window is the Menu system and the Toolbar The options available from these are described below At the bottom of the window is the
76. ny node of this tree can be used to populate a subject area Either drag and drop the node or table from the hierarchy into the subject area or use the right mouse menu and select one of the Add all options to add the tables and or views belonging to that node to the subject area ERP Hierarchy Ci Basis Components 4oplComp CRYSTALIBC Business Objects Integrated Reporting DevClass SSA Service Software Addons DeyClass ee l Service Software Framework Dev lass MFTIGRP DEMO Degi fq ae in Hierarchy Ta I FTISAPGUI DE Search in Branch SFTIGRP_DEMO ISFTIINV_AFFL Dev Add all Tables and Views of UMFT GRP_DEMO DevClass to Subject Area demo SFT FINY BASE LT Add all Tables of sAFTIGRP DEMO DeyClass to Subject Area demo BC ABA ABAP Runt Add all views of FTIGRE DEMO DeyClass to Subject Area demo BC BMT Business M BC BSP Business 58 Export Branch FTIGRP_DEMC to File BC Byy BY Service BC COM Computing BC CI f Component Integration Installation Windows Compone 4pplComp BC C5T f Client Server Technology 4pplComp BC CTS Change amp Transport System 4pplComp BC CUS l Customizing t pplTomp El Edit Subject Areas Expand Sub Tree 5 ji B Pat fe Edit Subject Areas Select Subject Area AIX T Tolocenerts expat selected CO the selected subject area contains Table view Mame Table view Description Populating a subject area from the Application Hierarc
77. o Calculate the Rental Duration Driver Master Route Planning Assignment of Drivers Mumbers Weekday Related Customer List Select all or required rows then Right Mouse Click or drag and drop to add to the selected Subject Area Result set from using the Expand Subject Area feature The number of tables in the list is displayed at the top right of the screen From this screen the options for the user can be Clicking the Back button to refine the selection criteria to produce a different list of tables Clicking the Close button to terminate the process Selecting rows from the result set and adding these to the original Subject Area or a different Subject Area USER GUIDE 62 BROWSING THE METADATA IN SAFYR Edit Subject Areas fe Edit Subject Areas Select Subject Area E Expand Subject Area ee i a the selected subject area contains p Total 718 Elements Table view Mame FSBUSTYPE FSS INDUST PE ee ae EJI 1AFITP Te Add the selected 718 tablesviews to Subject Area demo Fe _1BATL2 Tax Law IP J Select Al Eknai Save IBEW EMLGFAD Empties Moverent Customer Billing Status 2 IBEVIJEMLGOFS Empties Billing Document without Update IBEVI LUTS906 Check Table for LU Groups in Material Master 2 IBEVI RBBO Customer Master Data Rebate Processing EY IREBLA Settlement Interval and Date Last Settlement F EY 1I RBMS Conversion Table Material Master Data IBEVI REMS2 Intermediate Table For Conver
78. o the Safyr User Guide This manual describes the various features of Safyr in detail and We recommend that you refer to the Safyr Getting Started Guide for details of how to install and configure the product 1 1 Where do I find what I need 1 1 1 Installing and configuring For information on installing and configuring Safyr refer to Chapter 2 of the Safyr Getting Started Guide Safyr will need to be fully installed before you can attempt an extraction of metadata from your source system 1 1 2 Extracting metadata from the Enterprise Application Once Safyr is installed and configured an extraction of metadata need to be carried out by connecting to the Enterprise Application you require e g SAP PeopleSoft The detailed steps for achieving this are described in Chapter 3 of the Safyr Getting Started Guide 1 1 3 Exploring the contents of the Safyr repository Safyr s main purpose is to allow exploration of the data structures extracted from your environment and stored in the Safyr Repository To understand the features available refer to Chapter 3 of this manual 1 1 4 Exporting metadata from Safyr into other environments Having located particular data structures with the Safyr browsing interface users may wish to export these data structures into other tools and formats See Chapter 4 of this manual for more details 1 2 Safyr manual set There are two Safyr manuals supplied in Adobe Acrobat forma
79. o the tool of choice click the I gt icon on the Safyr tool bar or choose Export Data Model as from the File menu This opens the Export Data Model Wizard Click the Next button to start the export steps The Define Subject Areas form is for selecting one or more subject areas to be exported Click the Add Subject Areas button and then use drag and drop to add one or more subject areas you require Click the Next button to progress to the next stage of the export wizard Export Data Model As Export Data Model Wizard Step 1 Define Subject Areas Please add the subject areas to export by clicking the button Add Subject Areas Ery demo subject area Esia Remove ie Remove All The Export Wizard specifying the subject areas required The next form displayed is the place to choose the export format The actual export formats displayed and the subsequent wizard steps will depend on the formats that your Safyr installation has been configured to use USER GUIDE 66 EXPORTING METADATA FROM SAFYR Export Data Model As gt gt Export Data Model Wizard Step 2 Export Subject Areas To Please select where to export the subject areas and define the export settings Export To File Name and Location ERwin Version C 3 5 ERX 4 x ER1 via API Export Wizard choosing the export format Expott to This is for choosing the target for the Export information The avai
80. or creating a NEW repositOfy sssesesesesesesesstsesereseetsestsesesesesesereseses 6 29 Gopro am CxiStine repository Ge HII ON assie ena a a E E ps ents A 6 2a Delco IKepOciLOl ieee Retest een nace Sie eet emer cere eis 6 2p Tapore por REPOSO ecasessi ca ticietnsheatenecenean N ate eee eas 6 ZS Topor REPOSO rann catch uesesu atu eansteh seingends N aesteuts 6 ZeSiZ EPOR DOSO oinin a a a Dense tay ea Saas aT Dances cased Dea ubeavaunleanyes fi Der ARCO SCO AIM ANC asec tad tasrl na Seals T a ceca isso alr sd deal anand ahaa nated 7 Zr MME REDOSIUOKY aT LUE eitie NE E EE EEEE 8 Po mmm E N CE Re PMR A E E E N 8 29 Mandacie Multiple R Potone innen a T A N A AT 3 Browsine the metadata 1th Salyc erreien ae E E E E E E 10 ue MINING SAVORS PACE esera iiine ianiai aS i a a EE E E tedsoapsecs 10 3 1 1 Elements ot ihe Satyr WOrk sd Ce niieceriire iee NEE EAT ERE 10 Ika ES e S chert nares EN TRE R ERE RAR EER 11 ILS Thesar toolbar omeri a ua aAA EA EEE RA ANERIAN EEE NAON 12 Fa DA OPU ON S Araceli sae atone ets Ste strc oes Geese ge sasha bo eee teeta ees ase ooo eee 13 zo Licens Ormio ena n eT a N ENN 13 2E DOVEN Denie ndi anona aa aaa a a A a 14 6 is EENM I N T a a E ATA O E ONEA 14 20 doy Sat edetermines the ROW Count oniinn nene EEE E 15 3 6 1 Special Considerations for SAP and Siebel Systems s sesesseserseseseserererrrerreresrersesrsrsess 15 3 7 Opening additional Model Overview Windows ssesesesssssesesrsesesestsesesrerereseststsesesesen
81. pecified and this user must be the Table Owner for the database Fach and every Safyr user wishing to share the metadata in a Safyr repository must specify the same database or schema and database user when defining a new Safyr repository within their local Safyr environment The following example shows a typical scenario 4 Safyr users wanting to connect to a mixture of SAP and PeopleSoft systems There are 3 databases or schemas Database A stores metadata from a SAP system Database B metadata from a PeopleSoft system and Database C from another SAP system USER GUIDE THE REPOSITORY MANAGER fe N e SAP1 D base A Tab Owner A 4 Table Owner Saphir Client 1 for A e P Soft1 D base B Tab Owner B ha es Q Database or Schema A r innos fe N S e SAP1 D base A Tab Owner A J S Database or Schema B e P Soft1 D base B Tab Owner B lt e SAP2 D base C Tab Owner C _ gt f Table Owner Saphir Client 2 j for B e F Ni N f D4 N Fi i f j Ny fi ann oo Ph nn Ne Be A Database or Schema C f j i P Soft1 D base B Tab Owner B 7 _ Table Owner x for C Fd Saphir Client 3 of i a i Fi K s i AaAnncitar C antti T R Fi j r f D J a e SAP1 D base A Tab Owner A K O gt e SAP2 D base C Tab Owner C Saphir Client 4 z Safyr Clie
82. pecify a string to be used as a prefix for the View name Add Clent where clause allows specification of a SAP Client MANDT for inclusion in the generated text where clause Add at the end tail the generated statement with an Having made the appropriate selections click the Create SQL button to generate the required statement The Select AI and Copy to Clipboard buttons can now be used to select and copy the generated text for transfer to another application if required USER GUIDE 49 BROWSING THE METADATA IN SAFYR 3 30 Creating a report of table attributes This feature of Safyr can be used to create simple reports of table attributes Right Mouse Click on the appropriate table in the Safyr Model Overview and choose Export Table Properties to display the following form E Show Table A008 Plant Additional selling plant g iol x Field Name FieldLbl PKey Domain Name aj Fos MANDT Client x MANDT Field Name KAPPL Application x KAPPL Field Lbl KSCHL Condition type X KSCHL T Field Desc WERKS Plant X WERKS o WERKV Resale plant x WERKS PKey DATEI Validto X DATUM Req DATAB Valid on DATUM ten KNUMH Condition record no KNUMB Dec Datatype Domain Name Domain Lbl Domain phys Type The Export Table Properties form The check boxes at top left lists the reportable properties Check each property to be included in the report Add Column Headers
83. rchy is opened at the appropriate table or view This allows the selected object to be seen in context to its position in the hierarchy For more details of Application Hierarchy see The Application Hierarchy later in this chapter USER GUIDE 35 BROWSING THE METADATA IN SAFYR 3 21 The Application Hierarchy The Application Hierarchy is an alternative way of looking at the contents of the Safyr repository The same set of Tables and or Views seen in the Model Overview ate organised in a tree structure Depending on the Enterprise Application being viewed there may be more than one Tree to choose between Click the is icon on the Safyr toolbar or click Application Hierarchy from the View menu to display the Application Hierarchy screen If there is more than one type of Hierarchy available for the currently selected Enterprise Application the Tree drop down list box will show the possible choices ERP Hierarchy ji Tree SAP Application DevClass Tree X E E AC Accounting General ApplComp H E AC INT Accounting Interface ApplComp 4 FS AC COB Coding Block ApplComp fa A ARBW f Asset Accounting Reporting Link to BW DevClass fa KPEP_WORKLISTS CO Worklist in Schedule Manager CO Specifi DevClass fa OPO0 Non HR components of Organizational Management DevClass CS Customer Service ApplComp LE Logistics Execution ApplComp SV Service ApplComp WP mySAP com
84. re hierarchy See Searching for tables and views and Searching Tree Nodes below Search in Branch lt branch name gt This displays a form for searching within the currently selected hierarchy branch See Searching for tables and views and Searching Tree Nodes below Show Table View Info This option is only available if the current selected node is a table or view It shows the details of the selected table or view See Viewing Table Details and Showing the View fields earlier in this chapter for more details Show Table Relationships This option is only available if the current selected node is a table The related parent and child tables form will be displayed See Viewing parent child relationships earlier in this chapter for details USER GUIDE BROWSING THE METADATA IN SAFYR Add all Tables and Views of lt node gt to subject area lt subject area name gt This option is only available if the Subject Area form is open See Subject Areas later in this chapter All the tables and or views belonging to the node are added to the current subject area Add all Tables of lt node gt to subject area lt subject area name gt This option is only available if the Subject Area form is open See Subject Areas later in this chapter All the tables and or views belonging to the node are added to the current subject area Add all Views of lt node gt to subj
85. ree search fields are 7 Table Name The physical name of the table Short Desctiption The descriptive name for the table USER GUIDE 17 BROWSING THE METADATA IN SAFYR Subject Area ID The id of the Subject Area see Subject Areas later in this chapter for more details of subject areas 3 9 1 To select tables Enter the selection criteria for the desired tables m Click the Search button The set of tables satisfying the criteria will then be displayed 3 10 Using Advanced Search The selection criteria described in the previous section cover most of the day to to day queries The Advanced Search button displays a form allowing for more flexible search capabilities This is particularly useful when searching for a given field occurrence The form consists of three tabs Standard Filter Search for Field Patterns and Extended Filter Ageanced Search form The Standard Sections tab includes a range of search fields including Field Name Short Description and Long Description These are described below USER GUIDE BROWSING THE METADATA IN SAFYR The search options are grouped into 3 different areas Table related search criteria Table Name Enter a Table Name or partial Table Name Short Description Enter a Short Description or partial Short Description Table Type use the drop down list to choose Transparent SAP Pool or SAP Cluster The latter two are only relevant to
86. rency FK Last Time User Logged Exchange Rate Inter Curen E To Currency FK Password Last Updated Exchange Date Exchange Rate ee a ey ne Currency Code PK ras CTI ACD Login Id Ea To Currency FK aaa SeS Docking Number SON CTI ACD Login Password Ba From Currency FK ciii a _ Created MS Exchange synchro Exchange Type Code a i eee aie amp Created By FK Password Exchange Rate pupe Report Server Password EIM Batch Number m lan a Last Updated Challenge Answer Row Id Bs Lact Undated By IF Challenge Question Conflict Id oe rl P J K Login Domain Modification Number ee Comments Last Updated By PETE E 5 od Pe i eel aa eee The ER Diagrammer window USER GUIDE 71 EXPORTING METADATA FROM SAFYR 4 3 1 The ER Diagrammer toolbar ER Diagrammer has its own toolbar The available options are described in the table below Open diagram Open an existing diagram saved in ER Diagrammer Export diagram as image Export the diagram in bitmap or Windows metafile format Show how the model will look when printed Select Tool Switch to the Select tool for selecting objects on the diagram Snapshot Tool After selecting this click on the diagram and select an area to be copied to the clipboard Increase the magnification level for the diagram Decrease the magnification level for the diagram Set zoom level Enter a percentage scale for zooming the diagram or select one of the preset levels u
87. ritten to the export file HE Delete This option will delete the currently selected item in the subject area ge Delete All This will delete all the items in the subject area A form will be displayed asking for confirmation of the delete action before the items are removed 3 36 Adding tables to a Subject Area There are three main places for populating a subject area each of which is described in the following sections From the Model Overview From the Related Tables pop up menu From the Application Hierarchy 3 36 1 Populating a Subject Area from the Model Overview This approach to populating a subject area uses the current set of tables in the Model Overview The Subject Area form needs to be open in addition to the Model Overview Individual tables can be added to the currently selected subject area by dragging and dropping from the Model Overview into the Subject Area Alternatively use the Select Tables features described above see Selecting tables in the model overview to reduce the list of tables to a manageable size Then Right Mouse Click on the list of tables in the Model Overview and click the Add All to Subject Area button USER GUIDE 56 BROWSING THE METADATA IN SAFYR 1 Model Overview Tables alf fs Tables Wielws Filter Tables by Table Name Short Description Subject 4rea ID T500 bb Search 3 lt Tb Mame Short Desc TEl Type No of Child TEs No of
88. rnrstsreeseeereees 16 3 8 Seeing View Data Element and Domain information ssssssesererssersrsereresestsesesesesesrseseeeeeeeereses 16 IS coelectine tables Aa the Model OVEN E onan nda a aa a eal 17 3 9 1 Tos eee Aa oe ene eee pee Rant a Rte RD ear Et OS ORD eR OOS ean ROSARIO S ERD OSD AROS ea Sate 18 DO EIST AA aC caste cecatr ac inontucn O E EE cota E EN 18 Salk Sorun column AM Cala Odera a a E N E EEA A A A O AO 22 3 12 Clearing Search Criteria in the Model Overview sesesssesessssesesereserereererssetsrsesesenenreesesrseeeeereeees 23 S VIENDO ADEA S y eT meee nT Tr emer mt ry mercy rere merry meee rere errr ert re mer 23 Dlg Tabee iana a NA 29 cpl is 0 eea a ree Re E T A O E 26 Koo Radon hipdeta io ws atoasssangtneietsccndraituetdcatanendcndtust 2i SAA Viewine parent child relations Hips xuccccncsssesaacacaencaisanogsonsentapsaanospheneedtpislsdeenedaawadeptaeeacanensadecantesaneaat 28 Blo JU sinethe Overview tO LOW Ses VIEWS aaner AEREE 29 IADA slowing The Viewed Soare a EAA A A A AOA 30 DAZ New Elemen Morna ON aena E aucun ca nnaomnseennaes 31 Ile Wsing the Overview to browse Dart Elene R ona aa A mane mene 32 Sal Searcmiag tot tables using data BEME mt atiacterisascteecialeiamctneecertGni wetineset eameieendieeacnens 32 Salo Usine the Overview to browse Domains eroriren anere anaE ENE N E NENE 33 3 19 ASCALC MAO for tables usino a A OTA izes ses suiriri minier innin iiini eri i eina 34 3 20 The Model Overview context pop
89. rt Desc Length Entity Table Kod H No of Records 38203 Change No of Rec Limit Model Overview Domains Clicking on a Domain in the list box on the left reveals full details of that domain on the right of the form The search facilities at the top of the form are similar in function to those for Base Tables and described in Selecting Tables in the Model Overview above Where a Domain has associated fixed values these are shown in the panel at bottom right as Domain values USER GUIDE BROWSING THE METADATA IN SAFYR 3 19 Searching for tables using a Domain This feature finds all the tables using a specified Domain From the Model Overview Domains form right mouse clicking on a Domain reveals a pop up menu showing Find Tables using Domain When selecting this a search is initiated to find all Tables containing Fields that belong to the chosen Domain type Note This feature sets the Domain field in the Search parameters see Using Advanced Search above to the selected Domain It is advisable to clear this field after completing the search to prevent further searches from including this setting 3 20 The Model Overview context pop up menu Right Clicking on a row in the Model Overview will display the Model Overview context pop up menu Pop up menu on right mouse click Table Details Table Relationships Add Table KMA1 to Subject 4rea cost center tables Select All Find Table in
90. ry key is not part of the receiving table s primary key and the parent is optional are displayed Full details of any of the tables shown in the parent or child area can be displayed by double clicking on the table This uses the Table Details form to show the structure of the selected table see Viewing table details earlier in this chapter 3 15 Using the Overview to browse Views Safyr can display details of application Views in a similar manner to the way it shows base tables in the Model Overview Note There are no Views available in Safyr for PeopleSoft Enterprise applications To display a list of views in the Model Overview click on the views tab and then click the Search button F Model Overview Views EJ Tables z views HE Data Elements DY Domains View Type View Name Short Description Subject Area ID T Advanced Search friem Type view Name Shot Desc Vo IBREMZ Maintenance view For Maintaining External Key Figures VY _JIBRENZTYPTAB Key Figure Categories vY_JEBRLOSZD Maintenance view Settings For Liquidation Scenario Y_IBRLOSZH Maintenance view Definition For Liquidation Scenario Y_JBROZAKT RM Gap Determination of Mominal Transfer Price Using STC Y_JBRSYGAPHOZ Display of Saved Gap Results Header Information V OIFCPLANORGSRES Search Help For Allowed Product Seg Groups For Planng Org IFIP Activate JFMIP only settings vY_JIT_AMNAR JIT view For JIT_AZYAR and Text Table JIT_AZYART g DE view
91. s of these three applications There are two possible methods for creating these additional relationships USER GUIDE BROWSING THE METADATA IN SAFYR Creating Rules Based Relationships This method is available for PeopleSoft and JD Edwards repositories Safyr uses a set of spreadsheet based relationship definitions to build additional relationships Creating Extended Relationships This method is available for SAP PeopleSoft and JDEdwards repositories Safyr infers additional relationships by looking for possible Primary Key and Foreign Key pairings Full details of these methods are described in Appendix B 3 39 Creating additional Relationships The creation of additional relationships is normally carried out as part of the application extraction process see the Safyr Getting Started Guide Chapter 3 Extracting Metadata for more details Log Source DB Physical Connection Check PeopleSoft Enterprise Environment Clear affected repository tables or recreate the whole repository Log Repository OB Physical Connection Prepare the Repository Environment after deleting unused datat DO LANGUAGES Fill Languages Initialize Language Environment From GO LANGUAGES Domain DataElement DataElement Description default language DataElement Description additonal languages Table Table Description default language Table Description additional languages Check of OD DOMAIN check iF DD LOOKUP ENTITYNAME exists Fields
92. sing the drop down list 4 3 2 The ER Diagrammer Right Mouse Click Menu A right mouse click on the diagram will show a pop up menu with a range of options for refining the model display Zoom Tools Model Display Level Model Display Type Model Display Notation Entity Display View Display Key Display Hide Selected Objects Del Undo Last Ctirl z Undo All Shift Ctrl 7 Copy to Clipboard as Metafile Ctrl c Show Ruler Autolayout AutoSize by Text Length ER Diagrammer Right Mouse Click menu USER GUIDE 72 EXPORTING METADATA FROM SAFYR This menu is context sensitive All available options are summarized in the following table Zoom In Changes the cursor to the Zoom in tool Zoom Out Changes the cursor to the Zoom out tool Fit Model Fits the diagram into the available ER an o Model Display Level Entity Changes the diagram to display only Entity names i e no Attributes are displayed Primary Key Changes the diagram to display only Primary Key attributes Fits the diagram to encompass selected objects If no objects are selected the behaviour is the same as for Fit Model Primary and Foreign Changes the diagram to display only Primary and Keys Foreign Key attributes All Attributes Changes the diagram to display all Attributes Model Display Type Logical Display Logical Entity and Attribute names on the diagram Physical Display Physical Entity and Attribute names on the diagram
93. sion of Material EH Delete f Delete all o ata 2 BEY LIREPA Intermediate Table Material Specific Contrib M aaa Conversion Table for Indirect Customers Reba Intermediate Table Conversion Indirect Cust f Itemized Proof Rebate Settlement Parameter to Calculate the Rental Duration 2 IBEVIIRPFA Driver Master Route Planning 2 IBEVIJRSFS4 Assignment of Drivers Numbers IBEVITSKUN Weekday Related Customer List Select all or required rows then Right Mouse Click or Next drag and drop to add to the selected Subject Area Using the Right Mouse Click menu to select and then add the relationships to a Subject Area 3 38 Creating additional Relationships not extracted from the source Application Safyr represents relationships from SAP by extracting the relationship definitions defined within the SAP Repository This means that the relationships represented by Safyr are the same as those viewable by the ABAP Workbench Data Dictionary tool In the case of J D Edwards EnterpriseOne there are no formal relationship definitions within the data dictionary The PeopleSoft data dictionary defines some relationships but not really enough to allow good data models to be derived Safyr users can use features within the product to add additional relationships to those found in the ERP data dictionary Slightly different approaches have been taken for SAP PeopleSoft Enterprise and J D Edwards EnterpriseOne taking into account the characteristic
94. ss Tree This tree shows Table and Views grouped by Application Component and SAP Development Class An important point to understand is that the location of a Table or View in a tree node is related to which component the table was originally allocated when it was created That is a table will only belong to one node in the tree SAP Program Tree This tree shows Table and Views grouped by Application Component Program Function Group and or Transaction A SAP transaction is associated with a Program or Function Group The Tables and Views are shown in the hierarchy associated with the Program or Function group that uses them So searching for a given Transaction will locate the Program Function Group associated with that Transaction and then the Table Views used by that Program Function Group ate grouped below that Program Function Group Note For a SAP BW system see Chapter 6 Special Product Features for SAP BW 3 25 2 Application Hierarchies for Siebel There are two Application Hierarchies created in Safyr for Siebel These are Stebel Application and Business Objects This tree shows Siebel Applications and for each Application the Business Objects associated with that Application Each Business Object is associated with a set of Business Components which form the next level of the hierarchy Stebel Application Screens and Views This tree shows Siebel Applications at the top level and for each Application the associated Screens then
95. t pdf files with the Safyr software Getting Started Guide Use this manual for details of product installation and an overview of Safyr features User Guide this manual Describes all of the Safyr functions in detail USER GUIDE THE REPOSITORY MANAGER 2 The Repository Manager Describes the features for creating and managing multiple sets of metadata in Safyr and managing one or more Safyr repositories On starting Safyr the Repository Manager form 1s T he Safyr Repository Manager centralises all the features and functions related to creating maintaining displayed a E i Repository Manager aaonx a an TEIL Repositories 0 Repository Details The Repository Manager form To open an existing Repository select the appropriate entry from the list of repositories and click the Open button USER GUIDE THE REPOSITORY MANAGER 2 1 Repository Manager toolbar The options for managing and maintaining repositories are accessed from the toolbar Tool Button Tool Button Name For mote details see Edit repository settings Editing repository settings or creating a new repository F Create a new repository Editing repository settings or creating a new repository Copy a repository Copying an existing repository definition P X ff Satyr Licensing J Nap 2 2 Editing repository settings or creating a new repository Clicking the Edit Repository Settings or Create New Repository
96. t there is a limit to the number of records that are retrieved of 2 500 This limit can be changed by clicking the Change No of Rec Limit Setting this to zero means there is no limit to the number of returned records If the actual number of rows available is higher than the Record Limit set the words Limit Exceeded are displayed beside the No of Records 3 6 How Safyr determines the Row Count The Safyr Row Count shows the number of rows in each table The row count is obtained from the database statistics and can only be evaluated correctly if the database user specified in the connection properties to the source ERP system see Chapter 3 of the Getting Started Guide for details of connecting to the source ERP has access to the DBMS statistics note for a SAP system access to statistics is via ABAP the database statistics are processed normally such a process is scheduled on the DBMS system Safyr only provides the row count feature for ERPS based on Oracle SQL Server or DB2 Other platforms will result in the Row Count being set to 1 If the statistics are unavailable or the Table does not exist in the physical database the Row Count for the table will be set to 1 For a SAP system the row count is only available for Transparent Tables For Pool and Cluster tables the Row Count will show only that there is data or not in the table Those tables with data will have the Row Count set to
97. tes B 8 4 Pass 4 Dimension search J D Edwards EnterpriseOne only A search is made for all Tables with just 1 Primary Key typically those tables that would form the dimensions in a data warehouse Then a search for potential child tables is made by searching all tables for fields with the same Role Name as the potential Dimension Master Table Primary Key A relationship is then added only if the two tables being considered are used in the same Business View B 8 5 Pass 5 Dimension search J D Edwards EnterpriseOne only A search for all Tables with just 1 Primary Key that are already part of an existing relationship is made these will be based on relationships generated by previous passes Child tables are then selected in the same way as for pass 4 but the need for a join to exist in the Business View between the two tables being considered is replaced with a match between the first 3 letters of the two table names involved for example F0111 and F0112 would be a match B 8 6 Pass 6 Dimension search J D Edwards EnterpriseOneOnly A search is made for all Tables with just 1 Primary Key and having an existing relationship these will be based upon relationship generated by previous passes A select of child tables is made similar to in pass 4 but without the restriction on there needing to be a join in the Business Views for the two tables USER GUIDE 98 ADDING ADDITIONAL RELATIONSHIP
98. this chapter Now drag and drop individual tables from the Related Tables form into the current subject area or right mouse click on the Parent Tables or Child Tables area and then choose Add the selected tables to the subject area from the resulting pop up menu USER GUIDE 57 BROWSING THE METADATA IN SAFYR r E Table Relationships lal EF Related Tables to T500L Parent Tables 1 all relationships Table Name Short Desc TS2RELID er in table PCL HR Description of clust Child Tables 1640 all relationships Table Mame Short Desc D trw ttre Time Data ID TWPC PCR PAYD Wade r ypes For Special Payment Reasons PCR ZA0008 dd the selected 1640 Tables to Subj hcl 4 Select All Table Details 2 Edit Subject Areas Select Subject 4rea A LK Toalotienenis export seed Cth f the selected subject area contains Table View Mame o Tableview Description EH Delte R Delete All To add a table drag amp drop it From the Model Overview Related Tables or Application Hierarchy window to this member list Adding related tables to a subject area USER GUIDE BROWSING THE METADATA IN SAFYR 3 36 3 Populating a Subject Area from the Application Hierarchy The Application Hierarchy presents tables and views as nodes of a tree where the nodes represent application modules and sub modules A
99. this file does not exist Safyr will create it 7 Output Encoding Choose the output encoding required This can be ANSI UTF16 or UTF8 a Write Header Checking this option enables the additional options in the panel of Record Counter and Column Names Record Counter Select this option to include a row count at the beginning of the export file 7 Column Names Click the appropriate radio button to include either Logical or Physical names as column headers m Field Separator Choose the appropriate character to act as a field separator in the exported file USER GUIDE 51 BROWSING THE METADATA IN SAFYR Boolean True or False allows the user to specify suitable text values by which to represent Boolean values in the file m Field Delimiter Choose the appropriate character to act as a field delimiter in the exported file m Record Separator Choose the appropriate character to act as a record separator in the exported file The _ Fields button toggles the Field selector portion of the form on and off In the field selector you can select fields for inclusion in the exported file After making the appropriate selections click OK to generate the export to the specified File or the Clipboard 3 32 Viewing Model Statistics The Statistics option on the Safyr View menu will display a form showing a summary of the objects extracted and stored in the Safyr repository Statisti
100. ting tables from the full list Table Name Short Description Subject Area ID C b Z ph Ser Search Criteria The Start Select button uses the entered selection criteria to search for a matching table set Each of the three fields is preceded by a button which allows the type of search criteria to be specified Clicking this button reveals a set of searching options The meaning of each of these buttons is described in the table below Button What Does it Do Wild Card Search find rows starting with or containing the specified string i Negated Wild Card Search find all rows mot containing the specified string Exact Match find rows exactly matching the specified string Negated Match any rows exactly matching the specified string are excluded Greater than finds all rows greater than the specified string in the collating sequence Greater than or equal to find all rows greater than or equal to the specified string in the collating sequence Less than finds all rows less than the specified string in the collating sequence Less than or equal to finds all rows less than or equal to the specified string in the collating sequence Null search finds all rows containing Null value Not Null search finds all rows containing a Not Null value Safyr search types The default search type is Wild Card Search This will probably satisfy most of the normal searching requirements The th
101. ubject areas in the Export Wizard and check Comparison file as the export format A file selection form will request the name and location for a MTA file which forms the Comparison Details file Now switch to another repository define and export a similar subject area set The two MTA files will now be ready for comparison USER GUIDE 75 COMPARING METADATA Export Data Model As gt gt Export Data Model Wizard Step 2 Export Subject Areas To Please select where to export the subject areas and define the export settings Export To File Name and Location MTA File Name PO Choosing the Comparison File format in the Export Wizard USER GUIDE 76 COMPARING METADATA 5 2 Performing the Subject Area comparison The Comparison feature is accessed from the Tools Menu Compare Subject Areas Compare Subject Areas Choose Models to Compare The Compare Subject Areas form Specify the two comparison MTA files to be compared using the file selectors at the top of the form Check the compare only objects box to exclude any objects from the comparison that do not exist in both models Click the Start Compare button to perform the comparison 5 3 Results of a comparison The results of the comparison are displayed in the text window Scroll through this to review the results or click the Copy to Clipboard button and then Paste into a Text Editor or Word Processing pa
102. ues E from ERP GD Generic Domain generated by Safyr TEMP_EXTRACT_INFO aa na TECH_DESC OO Table Name DD_DOMAIN_DESC Definition The descriptive text for a Domain Table Column Name Table Column Comment DD_DOMAINNAME DD_LANGUAGE_ID Language Code SHORT DESC LOGICAL_UNIQUENAME i gt Or LONG_DESC E USER GUIDE 84 THE SAFYR META MODEL Table Name DD_ DOMAINVALUE Definition A set of fixed values associated with a Domain Table Column Name Table Column Comment DD_DOMAINNAME DD_DOMAINVALUEF_KEY Domain Value Key POSIT TECH_DESC EE Table Name DD DOMAINVALUE_DESC Definition The descriptive text for a Domain value SHORT_DESC o G O ONG_DESC o G O Table Name DD_FIELD Definition A Field is an attribute belonging to a Table Table Column Comment E ee KEY_FLAG Indicates a Primary Key field Possible values are Y or N MANDATORY Indicates if Field is Mandatory Possible values are Y or N DD_PARENT_TABLENAME Where the Fields is a Foreign Key the Parent Table Name DD_PARENT_FIELDNAME Where the Fields is a Foreign Key the Parent Field Name TEMP_EXTRACT_INFO1 re TEMP_EXTRACT_INFO2 SOOO TECH_DESC Table Name DD_ FIELD DESC Definition The descriptive text for a Field Table Column Name Table Column Comment DD_TABLENAME Table Name DD_FIELDNAME Field Name SHORT_DESC _ _ _ _ S G O LOGICAL_UNIQUENAME o o o do O LONG_DESC o G O USER GUIDE 85
103. up Menu essessssssssesesesesesesesestststssssesssesesesesenesesesesesesrsestseeseses 34 3 20 1 Finding a table in the Application Hierarchy sssseseessesesesesesersssereresersesesrseseseseeeeeess 35 Jal Wheat pplican on FIErare hy noinen A ONAE OA EEA OTR O 36 Iaa AVAD e acions romaihe CT ar iaae aE E T O 37 3 23 Searching for tables and views in the Application Hierarchy essesessessesrsrsesrsesesrrrrrereresrersees 38 3 24 Searching Tree Nodes in the Application Hierarchy esseeseseseesessseseresesesesesesesesesenrsrererereereeses 40 3 25 What does the Application Hierarchy show for each ERP sessssssesssesssesesesesesesesrsrseereresesrsees 41 Doon APPONI Eear MES TOM SAP oriri i E OORO 41 D202 APPA On Mictarcies OESE Welt sisal ra a E ETEEN 41 3 25 3 Application Hierarchies for PeopleSoft Enterprise sseeseesseessseesesrsrersrsrsrsererrrereeeess 41 3 25 4 Application Hierarchies for PeopleSoft EnterpriseOne JD Edwards oe 41 3 25 5 Application Hierarchies for Oracle Enterprise Business Suite 41 IO DAO a ern a E eee Ten mean nT reser Cer neem nee eae ry 42 22T Using OBE Query by Example toint rrooate dat asrcinnaii haina in aa 43 120 PO MOU daa tE at O aon AEE T TE 45 3281 Expor ne data fronta sinele taDleiiieiiroiarieteiiiai aE E 45 D202 PPO Or Amun oer OI AB eS miene a E A 47 329 Creatine SOL scripts or table ACCESS moriiareri anaa enn a EEE E EOE A OO T 48 3291 Togensrate Views Or Select State Mmes zarian anaa o aR AEA
104. use Clicking on a node in the application hierarchy presents a pop up menu The available options on this menu are context dependant ERP Hierarchy E Tree SAP Application DewClass Tree ka OM Quality Management gApplCompt RE Real Estate Management 4pplComp SCM Supply Chain Management 4pplComp SO Sales and Distribution 4pplComp SLL Global Trade Services 4pplComp Sv Service 4pplComp R l Treasury 4pplComps FFL I Liquidits Calculation Desc lazzi FTA CORE Search in Hierarchy FTAC_CORE Search in Branch AC f Accounting General FTB CORE F FTOF Treas FTI_ BIW Ap FTLC_CORE FTPC CORE I Export Branch AC Accounting General to File FTR COMMA FIT CORE f Expand Sub Tree FTVY CORE TR LORE Former Objects From Frvy TR Cr 4pp deyvllass Fv RIS application development for Financial Assets Manag DevClass Fup CORF t TR CORF Former Ohiects From FWD TR Loans Dewt lassi E E E E MRR E E E E 4dd all Tables and Views of AC Accounting General 4pplCompy to Subject Area demo dd all Tables of AC Accounting General f4pplCompy to Subject Area demo 4d all views of QC l Accounting General f4pplCompy to Subject Area demo F E E E E E E E fa fa fa fa fa fa fa fa fa fa fa fa fa Context menu from Application Hierarchy The available actions are Search in Hierarchy This displays a form for searching the enti
105. vY_JIIT_HO_IT JIT Join JITHD and JITIT YoOIIT_IT_Co JIT JITIT JITCO Data For MATIC not delivered w JIT_TOOIL Define Storage Location vendors v_JIIT_Ti60mM Define Message Types w _JITCOL Assignment of the Color Profile w_JITCOLP Assignment of the Characteristics For the Color Types WY JITCRII View For Selection Criteria in JIT Cockpit w _JITCTYFE Selection of Call Types in JIT Cockpit _JITCU JIT Customer view Y _JITCU_ABLAD Unloading Point at JIT Customer Hda H Mo of Records 44870 Change No of Rec Limit Model Overview Views USER GUIDE 29 BROWSING THE METADATA IN SAFYR The View list is similar in usage and appearance to the base table list in the Model Overview Available fields in the View List include View Name The internal Name for the View Short Desc The Business Name for the View 3 15 1 Showing the View fields Double clicking on the view will show full details of the selected view E DB View AUFK_DT_V View for Orders E View Field Fieldtext Field Details GEIMANDT Client 7 H AUFNR Order E S AUIART Order Type HP AUTYP Order category BE AUFPL Operin task list no Order master data Data Element Descriptions T technical Desciption Field T Data Elem T Key that differentiates orders according to their purpose The order type contains a range of parameters which affect the way the order is processed For example using the order type you can specify The number
106. values are UK Undefined TB maps to a Table VW maps to another View CL Calculated Field DD_TABLENAME Table Name DD_FIELDNAME Field Name DD_PARENT_VIEWTYPE For a future release of Safyr View Name of that Parent View Field Name of that Parent DD_DATAELEMENTNAME Parent Data Element Name TEMP_EXTRACT_INFO1 EO TECH_DESC Orr Table Name DD_VIEWFIELD_DESC Definition The descriptive text for a View Field View Field Name SHORT_DESC _ _ _ _ _ S G O LOGICAL_UNIQUENAME o O So y O LONG_DESC S o O USER GUIDE 90 ADDING ADDITIONAL RELATIONSHIPS Appendix B Adding Additional Relationships Details of the Safyr features for creating additional relationships based upon a series of spreadsheet based rules and inference rules PeopleSoft data dictionary However there are a number of relationships not explicitly defined in these tables For a JDEdwards system there are no relationships explicitly defined in the Data Dictionary For both of these environments Safyr users can extend the relationships extracted from the ERP by defining relationship creation rules in the SafyrSettings xls spreadsheet Safyr refers to these relationships as Rule Based Relationships S aphir creates relationships for a PeopleSoft system by looking at the relationships defined in the In addition Safyr has an inference process which can create relationships for SAP PeopleSoft and JDEdwards Safyr refers to these as Extende
107. xt for a Relationship Table Column Name Table Column Comment DD_RELATIONSHIP_ID Relationship Id DD LANGUAGE ID Language Code SHORT_DESC aa LONG_DESC ei Table Name DD _ RELATIONSHIPITEM Definition A relationship Item is a definition of a Field that belongs to a Relationship POSIT S G O DD_CHILD_FIELDNAME The Child Field for the Relationship Item DD_CHILD_FIELDVALUE_FIXED Where the Relationship Item is to a fixed value the fixed value TECH_DESC Table Name DD_SUBJECTAREA Definition A Subject Area is a grouping of Tables and or Views Table Column Name Table Column Comment DD_SUBJECTAREA_ID Subject Area Id DD_SUBJECTAREANAME ee Table Name DD_SUBJECTAREA_TABLE Definition An intersect table between a Subject Area and a Table Table Column Name Table Column Comment DD_SUBJECTAREA_ID Subject Area Id DD_TABLENAME Table Name Table Name DD_SUBJECTAREA_VIEW Definition A n intersect table between a Subject Area and a View Table Name DD _ TABLE Definition A table is a definition of a database Base Table Table Column Name Table Column Comment DD_TABLENAME Table Name DD_TABLETYPE The Table Type T Transparent P Pool C Cluster P amp C values are only relevant to SAP PHYSICAL_TABLENAME Physical Table Name NUMBER_OF_PARENT_TABLES ee Row Count if available TEMP EXTRACT INFO Jo TEMP EXTRACT INFO O o Ceca Dese oooOOoO OS NUMBER OF CHILD TABLES USER GUIDE 87

Saphir User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents