Essbase Studio issue building dynamic hierarchy from text file as source

Hi Gurus,

I am trying to build this structure.

Scenario_Src (Label Only)

            + TOTAL_ACT (Stored hier)

                         + ACT

                         + ADJ

              ~ BUD (Dynamic Hier) (Label Only)

                          ~ GROSS_BUD

                                        + GROSS_OFF

                                         + GROSS_ADJ        

                           ~ GROSS_BUD_VAR

                           ~ GROSS_BUD_VAR_PCT

I am using text file as data source and file is created with parent/child relationship with recursive join defined in Essbase Studio schema. In Essbase properties of model, i am using conslidating operator, Data storage for Label only and Aggregate Storage option for gen 2 member as external source from text file.

File looks like below:

CHILD|PARENT|CONSOLIDATING OPERATOR|AGG_STORAGE_OPTION|DATA_STORAGE|SORT_ORDER