Hi,
I am a beginner and would like to check whether we can create a loop in Cognos FM. As an example let us say if we have a same dimension used for different purposes, then loop is not allowed as that will give us an unwanted result. But if the same dimension is used for same purpose, can we connect and form a loop? Is it acceptable at FM level?
Thanks,
By "a same dimension used for different purposes" do you mean role-playing, where aliases of a dimension will have different relationships to other objects (like time order date and time ship date)?
What do you mean by "loop" ?
Describe the business case you are attempting to deal with.
By "a same dimension used for different purposes" do you mean role-playing, where aliases of a dimension will have different relationships to other objects (like time order date and time ship date)?
Yes. That is correct. I meant that. In that case, we need aliases.
What do you mean by "loop" ? Describe the business case you are attempting to deal with.
Let us say I have an year dim. The year is linked to the fact directly to show data belongs to which year(part of alternate key. I also have funds associated with a particular year. So I use a fund dimension (attached to fact) and a cross walk table (fundkey + year) linking to the year dimension (creating a loop "YearDim to Yeardim"). Technically this should work. But is it allowed in the tool?
YearDim----> Fact <----Fund--->Fund+year<----Year Dim
Fund is presumably a dimension.
Is Fund+year a fact or more like a bridge table and fund fund+year and yeardim are all part of one big dimension?
YearDim----> Fact <----Fund--->Fund+year<----Year Dim1
Dim Fact
Year Dim1 would be an alias shortcut.
One dimension: YearDim -----> Fact
another dimension: YearDim --->Fund+year <-----Fund ----->