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..
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.
Quote from: khayman on 14 May 2014 01:45:34 AM
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 :)