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

Trace back error on joining 4 tables

Started by neelimakoppu, 23 Apr 2015 01:01:10 AM

Previous topic - Next topic

neelimakoppu

Hi All,

I have 4 tables to join in FM and each table has one filter prompting for user input. When I joined first 3 tables (A innerjoin B lefouterjoin C), I'm able to apply filters and get results. When I join the 4th table with first three tables (A innerjoin B lefouterjoin C innerjoin D), I'm able to get some records in FM using test sample. However in Report studio, when I apply this package, i'm getting trace back error.

There is no center fact table etc. Joins are like A == B += C == D . Can any one tell me does this type of joins work fine or anything that I need to takecare? Thanks in advance.