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

How to Create relation between multiple query subjects?

Started by bvk.cognoise, 25 Jan 2012 10:28:09 AM

Previous topic - Next topic

bvk.cognoise

Hi ,

I have more than 30 query subjects in my project. i am not able to join two query subjects among these query subjects . because these two query subjects doesn't have foreign keys.in this case how can i create relation among query subjects.please find the attachment which gives clear information.may i am not able to explain properly please find the attachment you can understand my requirement easily.




Thanks
bvk
Regards
BVK

MFGF

Unless there is something common that can link your query subjects, you cannot define a relation between them. Bear in mind that the items you use do not have to be defined as keys in the database.

Can you explain your particular situation?

MF.
Meep!

blom0344

Also bear in mind that the concept of 'joins' does not exist in the database. FK's are foremost a mechanism for adding referential (and other) constraints. Blindly using existing (and imported) PK-FK relationships can be a bad way to start. And as the muppet  ;D   stated not all possible joins are related to FK's

barrysaab

Boy! Cognos getting on to me!!!

MFGF

Quote from: barrysaab on 26 Jan 2012 03:58:10 AM
Well,Muppet hardly goes wrong! Thanks

Blush. I wish that was true! Thanks for the kind words, but if anyone ever tells you the muppet is infallible, just remind them that muppet is his description not his name :-)


Snet form my fumblefingers
iPhon 5 usig Tapatalk
Meep!

bvk.cognoise

#5
Hi ,

For Eg: I used go sales sample DB for creating a model in FM. I imported all the table which is in Gosales DB in to Frmework Managaer model.but if observe Time Dimension table doesn't have any relation (Join) with other tables(Query subjects).how can i create at least one relation(join) between Time Dimension Table and any other table in the model?

sorry while i am trying to attach my screenshot i am getting errors like "The attachments upload directory is not writable. Your attachment or avatar cannot be saved."



Thanks
Vamsi
Regards
BVK

tjohnson3050

It sounds like your question is how to create a join in framework manager.  If that is what you are asking, you ctrl + click the two query subjects, the right click and choose Create -> Relationship.

Then you define the fields, join type and cardinality of the relationship that you want to define.

bvk.cognoise

Hi johnson,

Thank you very much for your reply.if i am not clearly explained sorry for that.but my question is how to launch relation between two query subjects when there is no matched filed or column.?

Thnaks
bvk
Regards
BVK

blom0344

Creation a join is based on whether you can define a relationship between 2 query subjects. Without a potential relationship a join would make no sense since not data would come from a query over both subjects

cognostechie

I agree with blom. You can create relationship between query subjects even if the names of fields are
not the same but you have to make sure that the data in those fields will match. If the data exists in one
table but not in the other table is still ok because you can create outer joins but if the data exists in both
the tables, then for that particular record, the values in both the fields should be the same.

If the values are not the same then I don't see any reason why you would even try to create the join.