Level under Dimension doesnot appear in cube--urgent

[sys2674]

Hi
I got stuck in some situtation,
I have 3 data source all are txt files.
All have a common column called Part. which have made unique.
I want to build cube:-
I have Dimenison
Part_status
Levels Part_Status
           Part
           Part_Desc
When i build a cube
I can see Part_status--->Part--->Part_desc in cateogories but i cannot see this in Cube.In cube. i can just see Part_Status-->part-->

Pls let me know How to proceed with this.I am struglling for that.
Thanks
SYS2674
           

[Darek]

I am guessing, that there is no measure associated with Part_Desc and Inclusion is specifed "Only when needed".

[senbi]

This could be because of datatype problem. If the part_desc is of CLOB/BLOB datatypes then it would not display. I have observed this datatypes doesn't get displayed in the catalog folders during catalog creation.

-Senbi

[sys2674]

Hi Darek,

You hit the goal.I got it working.
I had three data source one w/o measure and ,second  with only measures.and third one both measure and dimension.
So made a New datasource combining first and second.(a complete new flat file).
It is working fine.Now i have a model with only two datasources.

Cheers
Thanxs
SYS2674