Cognos Relationship Correction

[sheetal kumar]

Hi All,

Does anybody knows how cognos relates objects while building query in report net?

I have built the model long back but today I am noticing one issue.

Overview -

In a single model I am maintaining 5 packages. Each package is associate to only one fact except one.
(say F1, F2, ... F5).

In except one package is having two facts (say F1 , F2). The fact f2 was brought into this package based on the customer requirement.  But we still have F2 published separately.

Relationship between fact is f1 left outer join f2

Concern -
The report which I have developed is using the confirmed dimension which is related to both f1 and f2.

I have the confirmed dimension item to point f1. but the model is pointing to f2. How do I force cognos to choose the fact I want.

Pls. share your experience on this

[MFGF]

Hi,

The best practice modelling guidelines for both ReportNet and Cognos 8 indicate that data should be modelled to emulate star schemas. If you are referring to F1 and F2 as query items, as long as these are at the same level of granularity they should probably be in the same model query subject, emulating a star schema fact table with multiple measures.

Alternatively, if F1 and F2 are different fact query subjects, they should not be directly linked in the FM model, but rather link via conformed dimension query subjects.

Regards,

MF.

[sheetal kumar]

Hi,

yes, F1 and F2 are two facts. If I link them via conformed dimension the report will give a redudant record set. Which will increase the complexity of report development.

If I have to conformed fact and dimension then probably your method will work.

Do you think about anyother solution?

Thanks