Hi All,

I am preparing a cube to run in infoassist using cluster join tool.. I am stucking in following issues:

--while creating hierarchy, I want it to create as:

Departure Dimension
-DepartureID
-DepartureDate
-DepartureTime
(means all three fields must be at same level)

but I am getting the following levels in Infoassist window:

Departure Dimension
-DepartureID
--DepartureDate
---DepartureTime
(all three at three different levels i.e. one into another)

I have made the code as:

asmpl_three.acx file-------

  

SEGNAME=DEPARTURE, TABLENAME=RTS_PO.dbo.Departure, CONNECTION=rtspo, 
   GUI_PARAMS='1,40,40,268,160,228,120,1', KEYS=1, $
  FIELD=DEPARTURE_ID, AUTOINCREMENT=YES, START=1, INCREMENT=1, $
  FOREIGN_KEY=FK_Departure_Routes, PRIMARY_KEY_TABLE=RTS_PO.dbo.Routes, 
     FOREIGN_KEY_COLUMN=Departure_RouteId_fk, PRIMARY_KEY_COLUMN=Route_Id, $

asmpl_three.mas file-----------

 

FILENAME=asmpl_three, SUFFIX=SQLMSS  , $
  SEGMENT=DEPARTURE, SEGTYPE=S0, $
    FIELDNAME=DEPARTURE_ID, ALIAS=Departure_Id, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
      TITLE='Departure ID', DESCRIPTION='Departure ID',
      WITHIN='*Departure Dimension', $
    FIELDNAME=DEPARTURE_ORIGINALDATE, ALIAS=Departure_OriginalDate, USAGE=HYYMDs, ACTUAL=HYYMDs,
      TITLE='Departure Date', DESCRIPTION='Departure Date',
      WITHIN='*Departure Dimension', $
    FIELDNAME=DEPARTURE_ORIGINALTIME, ALIAS=Departure_OriginalTime, USAGE=A4, ACTUAL=A4,
      TITLE='Departure Time', DESCRIPTION='Departure Time',
      WITHIN='*Departure Dimension', $
 DIMENSION=Departure Dimension, CAPTION='Departure Dimension', $
  HIERARCHY=Departure Dimension, CAPTION='Departure Dimension', HRY_DIMENSION=Departure Dimension, HRY_STRUCTURE=STANDARD, $ 

Please help me, any suggestion regarding any tutorial for hierarchy creation would help.

-Regards
-Kumud Vaish

There sre some examples on this forum, try searching for CHILDREN or CHILDREN ALL

Hi Waz,

We looked on the cases for CHILDREN and CHILDREN ALL, but we didn't find any coding sample for the master file edition for creating this kind of hierarchy.

Can you please provide us any coding sample??

thanks in Advance

-Regards
-Kumud Vaish

I think I led you down the garden path.

Search for HIERARCHY and PROPERTY=PARENT.

Here is one example: http://forums.informationbuild...697019995#5697019995