How to re order Joins in Framework manager packages.

[saikrishna86]

Hi Team,

We have Framework manager packages in Cognos 8.4,  Client Users are accessing package and extract info of 2 dimensions without fact table columns ( there are 4 fact tables). Suppose, the default relation is coming from some ABC Fact table, How do I change the default relation to extract from other table suppose DEF,

We have recently upgraded the cognos 8.4 to cognos 10.2 and published the packages, now default relation is coming from another table. How do I change to use previous table which is like cognos 8.4.

We have two packages,  the default relation is coming from fact table 1 in package 1 in cognos 8.4, but after upgrade default relation is coming from fact table 5 in package 2, so the output comes wrong when compared to cognos 8.4 as long as we did not extract fact table columns

Please let me know if my query is unclear.

Thank you..

[Francis aka khayman]

i think this is not a good practice.

I think -- if there are multiple paths to two dimensions and you are not using a fact table, Cognos will randomly choose a path (or maybe use the first path it encounters as it is executing its internal commands or whatever).

the best thing to do is define the proper relationship between the dimensions, provide a short-cut/alias, and in your presentation layer, force the user to use only those if they need a report on only those two dimensions.

[Lynn]

i think this is not a good practice.

I think -- if there are multiple paths to two dimensions and you are not using a fact table, Cognos will randomly choose a path (or maybe use the first path it encounters as it is executing its internal commands or whatever).

the best thing to do is define the proper relationship between the dimensions, provide a short-cut/alias, and in your presentation layer, force the user to use only those if they need a report on only those two dimensions.

Yup. What kyaman said  :)