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

 

No column between Fact and Dimension tables in FM its shows wrong data in report

Started by rama83, 27 Apr 2009 05:32:06 AM

Previous topic - Next topic

rama83

Hi Gurus,

I am creating model in FM.I am having different type of fact and dimension tables. I am facing following problem there is no common column between Dimension and fact table. For that purpose I am giving the relation through third table. Like...

FT_Application_CC-Fact (Application_No_Key)
FT_Application_status_CC-Fact (Application_No_key, Decision_Date_Key)
LU_MIS_Time-Dimension (Day_Key)

I am giving the relations as follows.

Applcation_No_Key.Ft_Application_cc=Application_No_Key.Ft_applcation_status_CC and

Decision_Date_key.FT_Application_CC=Day_Key.LU_MIS_Time and creating the package pulish to congos server.

In the reporting level it shows wrong data like same data repeating every row. And same thing working fine for Character data types in fact table(like Application No) but sum wise it showing wrong data.

In data base level it shows proper data only.

Please any one suggests me how to give the relations for above tables. Please answer the above query its very needful.

Regards,
Rama

blom0344

If a database query yields the proper results, then Cognos must be performing it's own little magic on the query it is trying to build   :-\  (like splitting the query in 2 and not recombining properly)

My tip is to try and remodel your case into 2 Model query subjects which means you end up with one join between the model subjects (n:1 cardinality).

Your example is not detailed enough to suggect exactly which model to build , but I would suggest the query it generates now for splitting (check coalesce and full outerjoins)