Business Model Extensions
If you want to store logical information instead of descriptions or need more than 1024 characters to store description information, consider importing information into the business information extensions to the Database Information Metamodel (DIM). These are shown in the following picture:
Figure 8: Business Extensions to the DIMAs is the case with loading business descriptions, you can do this either by using Excel or with an XML script.
Microsoft Excel Import
Example 4 in the sample\macro directory of your Teradata MDS installation provides an Excel macro for loading the Business Data (Subject Areas, Business Entities, Business Rules, and so on).
Following the instructions in the readme.txt file, you create an Excel workbook containing Subject Areas, Entities, Attributes and Business Rules. See the example following:
Figure 9: Sample Excel Workbook for loading Business DataIf you are using Excel 2010, you may need to enable the Developer option, as follows:
1 Select File > Options > Customize Ribbon.
2 In the Customize the Ribbon pane on the right select Main Tabs from the drop-down menu, and then select the Developer check box.
3 In the Excel Visual Basic Editor, import the modules and forms:
✔ In Excel, click Tools > Macro > Macros and run the MDSLoadBIZ macro.
In Excel 2010, you can display the macro list in one of the following ways:
Alt+F8
.
XML Script
You can create an XML script to import the business data. See as an example the file metabusobjects.xml in the sample\xml directory of your Teradata MDS installation.
Figure 10: Example XML Script for Loading Business Classes