If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Loops in FM

Started by dssd, 18 Nov 2012 10:27:11 AM

Previous topic - Next topic

dssd

I have mulitple stars, say 5 facts and few common dimensions between those facts. How do i identify if there are loops in there?   At a generic level what thats the strategy to identify loops

tjohnson3050

#1
What do you mean by loops?

With multiple star schema's, you just need to define the relationships between the facts and dimensions only.  At query run time, separate queries will be generated for each star, then the queries for each star will be stitched together based on shared dimensions.

More information on Query Stitching:

http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page605-pdf.pdf

cognos4321

Hi experts,

I understand the concept of Stitch Query that when 2 facts are joined using a conformed dimension and cognos performs a full outer join to avoid any missing data.

Strategy to avoid Loops
If the join is between A-B-C tables then an alias table should be created and then join will be as follows
A-B
B-C
A-C2

I still don't get an answer to the original question asked here "At a generic level what's the strategy to identify loops" after creating a model. What kind of result would make me suspect a loop??

I read a lot of posts here to avoid double posting as per the norms of the forum.

Please guide.
Many Thanks Always

MFGF

Quote from: cognos4321 on 30 Jan 2016 02:16:50 PM
Hi experts,

I understand the concept of Stitch Query that when 2 facts are joined using a conformed dimension and cognos performs a full outer join to avoid any missing data.

Strategy to avoid Loops
If the join is between A-B-C tables then an alias table should be created and then join will be as follows
A-B
B-C
A-C2

I still don't get an answer to the original question asked here "At a generic level what's the strategy to identify loops" after creating a model. What kind of result would make me suspect a loop??

I read a lot of posts here to avoid double posting as per the norms of the forum.

Please guide.
Many Thanks Always

The simple answer is to run Model Advisor - it will tell you about all sorts of modelling issues and traps, including multiple relationship paths.

MF.
Meep!