...

Connect key fields between tables using Drag & Drop to establish join relaitonshipsrelationships.

1. Drag & Drop the fields to connect. The default join type is set to inner join.

   

   
   

   참고사항
   title Note : Changing Join Properties
   After the connection, right-click to modify the connection properies from the created [Link].

   
   

...

1. Check all data fields from the table to add to the meta items.

   

   
   

2. Rename the created folder.
   
   • Folder Name : Date, Customer Info, Store Info, Product Info, Sales Performance, Sales Target

   
   
   

   참고사항
   title Note : Changing Folder/Field Names
   To rename a folder or field in i-META items, double-click the item or press F2 key to modify. Alternatively, right-click the item and select [Properties] - [Description] to modify.

   
   

   참고사항
   title Note : Manual Folder Creation Option
   If [Table Automatic Generation] is activated in i-META Designer window [Settings], folders are created automatically. Disable this This option is disabled, when it table is created manually.

   
   

   참고사항
   title Note : How to Add Folders
   Right-click in the Items window to add a folder.

   
   

...

1.  Right-click the [Date] field and select [Property]. In the Properties window, modify the settings.
   
   Category : Period
   DefaultFormat : yyyyMMdd
   
   
   
   

2. Modify the properties of the [YearMonth] field.

   Category : Period
   DefaultFormat : yyyyMM

   
   

3. Modify the properties of the Measure item.

   DefaultFormat : #,###0

   

Step 4. 

...

Add Hierarchical Items

Fields can be structured hierarchically, allowing for Drill Up/Down 분석이 가능합니다analysis on the added items.

1.  i-META 항목 창의 빈 공간에서 마우스 오른쪽을 클릭한 후 [계층 구조 항목 추가] 메뉴를 선택합니다.
     Rigt-click on an empty space in the i-META items window and select [Add hierarchy items].
    Now a [Field Group] 필드가 생성되었습니다. 계층 구조 항목을  field is created. Change the hierarchical item to 'Product Group'으로 변경합니다.
   

   

   
   
   
2.  기존 필드를 복사하여 계층 구조로 표현하기 위해 필드를 복사합니다.
    복사한 필드를 생성한 계층 구조 항목 그룹으로 Drag & Drog하여 이동합니다.
     복사할 필드 : 상품대분류, 상품중분류 Copy the existing fields to represent them hierarchically.
    Drag & Drop the copied fields into the created hierarchical item group.
   
     Fields to copy : Product Category, Product Subcategory
   
   

Step 5. 

...

생성한 메타를 서버에 저장합니다.

...

Share/Distribute the Meta File

Save the created meta to the server.

1. Click the [Save] or [Save As] button.
   
   
2. Enter the file name in the authorized folder and click [OK] button to save.