how transform triangle relationships to star relationships?

[gg2vig]

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?

[bvk.cognoise]

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

[hthakkar]

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
---------------------------------------------------------