Hi ,

For the below XML , can someone help me in creating the MFD.

  
<DIMENSIONS>
   <NUM_DVALS>37209</NUM_DVALS>
   <DIMENSION NAME="D_PriceRange" SRC_FILE="/apps/endeca_myapp/eStoreSearch/data/state/autogen_dimensions.xml" SRC_TYPE="INTERNAL">
      <DIMENSION_ID ID="9993916"/>
      <DIMENSION_NODE>
         <DVAL TYPE="EXACT">
            <DVAL_ID ID="10018000"/>
            <SYN DISPLAY="TRUE" SEARCH="FALSE" CLASSIFY="FALSE">D_PriceRange</SYN>
         </DVAL>
      </DIMENSION_NODE>
   </DIMENSION>
   <DIMENSION NAME="D_Channel" SRC_FILE="/apps/endeca_myapp/eStoreSearch/data/state/autogen_dimensions.xml" SRC_TYPE="INTERNAL">
      <DIMENSION_ID ID="9993915"/>
      <DIMENSION_NODE>
         <DVAL TYPE="EXACT">
            <DVAL_ID ID="10013000"/>
            <SYN DISPLAY="TRUE" SEARCH="FALSE" CLASSIFY="FALSE">D_Channel</SYN>
         </DVAL>
         <DIMENSION_NODE>
            <DVAL TYPE="EXACT">
               <DVAL_ID ID="9993754"/>
               <SYN DISPLAY="TRUE" SEARCH="TRUE" CLASSIFY="TRUE">2</SYN>
            </DVAL>
         </DIMENSION_NODE>
         <DIMENSION_NODE>
            <DVAL TYPE="EXACT">
               <DVAL_ID ID="9993735"/>
               <SYN DISPLAY="TRUE" SEARCH="TRUE" CLASSIFY="TRUE">0</SYN>
            </DVAL>
         </DIMENSION_NODE>
         <DIMENSION_NODE>
            <DVAL TYPE="EXACT">
               <DVAL_ID ID="9993569"/>
               <SYN DISPLAY="TRUE" SEARCH="TRUE" CLASSIFY="TRUE">1</SYN>
            </DVAL>
         </DIMENSION_NODE>
      </DIMENSION_NODE>
   </DIMENSION>
</DIMENSIONS>

For example there is a parent node
DIMENSION_NODE and under which there is a child node but it has the same name as the parent node .

MFD:

  
FILENAME=autogen_dimensions, SUFFIX=XML, DATASET='/opt/webfocus/enterprise/adhoc/ibi/apps/egee/autogen_dimensions.xml',$

SEGMENT=DIMENSIONS, SEGTYPE=S0, $
FIELDNAME=DIMENSIONS, ALIAS=DIMENSIONS, USAGE=A1, ACTUAL=A1,$

SEGMENT=DIMENSION, SEGTYPE=S1, PARENT=DIMENSIONS,$
FIELDNAME=DIMENSION, ALIAS=DIMENSION, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSIONS, PROPERTY=ELEMENT,$
FIELDNAME=NAME, ALIAS=NAME, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSION, PROPERTY=ATTRIBUTE, $
FIELDNAME=DIMENSION_ID, ALIAS=DIMENSION_ID, USAGE=A30, ACTUAL=A30,REFERENCE=DIMENSION, PROPERTY=ELEMENT, $
FIELDNAME=ID, ALIAS=ID, USAGE=A30, ACTUAL=A30,REFERENCE=DIMENSION_ID, PROPERTY=ATTRIBUTE, $

SEGMENT=DIMENSION_NODE, SEGTYPE=S2, PARENT=DIMENSION,$
FIELDNAME=DIMENSION_NODE, ALIAS=DIMENSION_NODE, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSION, PROPERTY=ELEMENT,$
FIELDNAME=DVAL, ALIAS=DVAL, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSION_NODE, PROPERTY=ELEMENT,$
FIELDNAME=DVAL_ID, ALIAS=DVAL_ID, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSION_NODE, PROPERTY=ELEMENT,$
FIELDNAME=ID, ALIAS=ID, USAGE=A30, ACTUAL=A30,REFERENCE=DVAL_ID, PROPERTY=ATTRIBUTE, $
FIELDNAME=SYN, ALIAS=SYN, USAGE=A50, ACTUAL=A50,REFERENCE=DVAL, PROPERTY=ELEMENT,$

FIELDNAME=DIMENSION_NODE, ALIAS=CHILD_DIMENSION_NODE, USAGE=A10, ACTUAL=A10,REFERENCE=S2, PROPERTY=ELEMENT,$
FIELDNAME=DVAL, ALIAS=CHILDDVAL, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSION_NODE, PROPERTY=ELEMENT,$
FIELDNAME=DVAL_ID, ALIAS=CHILDDVAL_ID, USAGE=A10, ACTUAL=A10,REFERENCE=DIMENSION_NODE, PROPERTY=ELEMENT,$
FIELDNAME=ID, ALIAS=CHILDID, USAGE=A30, ACTUAL=A30,REFERENCE=DVAL_ID, PROPERTY=ATTRIBUTE, $

Thanks!

This message has been edited. Last edited by: Kerry,

Jan

when there is a XML file in the ideal world there also should be a XSD file that descripes this first XML file with all the tags.
If it is available WebFocus can read and convert that to the proper master file and then you can report on the original XML

you have to search the documentation on this matter , Information Builders should be able to help you

If you do not have the XSD, there are utilities out there, that will generate one from your XML file.

The XSD will be specific to that particular XML file though.