Print Page - how transform triangle relationships to star relationships?

Title: how transform triangle relationships to star relationships?
Post by: gg2vig on 14 Jun 2011 03:01:23 AM

cognos 8

hello

i have 3 tables which have each one relationship together. (triangle)

how can i transform this schema to a star schema with framework manager?

Title: Re: how transform triangle relationships to star relationships?
Post by: bvk.cognoise on 14 Jun 2011 03:08:46 AM

Hi gg2vig,

what i understood is your asking about loops.if i am correct.crate shortcuts to avoid loops are triangle relation ship.

thanks
bvk

Title: Re: how transform triangle relationships to star relationships?
Post by: hthakkar on 14 Jun 2011 06:19:30 AM

Hi,
What i get from your requirement is that you have somewhat scenario like two fact with one confirmed dimension,so all the tables are related to each other.

Simple solution to this is to create a shortcut alias of the confirmed dimension in the FM.so that now each fact will get a separate dimension.

Let me know if this helps.

Thanks,
Hitesh
--------------------------------------------------------
hthakkar@infocepts.com|www.infocepts.com
---------------------------------------------------------

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: gg2vig on 14 Jun 2011 03:01:23 AM