Print Page - Level under Dimension doesnot appear in cube--urgent

Title: Level under Dimension doesnot appear in cube--urgent
Post by: sys2674 on 14 Sep 2005 10:24:32 AM

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

Title: Re: Level under Dimension doesnot appear in cube--urgent
Post by: Darek on 14 Sep 2005 10:02:17 PM

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

Title: Re: Level under Dimension doesnot appear in cube--urgent
Post by: senbi on 15 Sep 2005 12:45:22 AM

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

Title: Re: Level under Dimension doesnot appear in cube--urgent
Post by: sys2674 on 15 Sep 2005 01:19:55 PM

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

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: sys2674 on 14 Sep 2005 10:24:32 AM