Many a times instead of using cognos own automatic functionalities , seen people using star schema groupings.
Start schema groupings are mainly used when you want to present clean picture of query subjects to the user so that they don't mix business subjects in the report.
It should not be used when you are having multiple facts in design as multiple facts will be taken care automatically when cardenilities are set 1-n between facts and dimensions. FM will automatically resolve multiple paths via stitched queries.
Thank You,
Vishwas Gupta
Start schema groupings are mainly used when you want to present clean picture of query subjects to the user so that they don't mix business subjects in the report.
It should not be used when you are having multiple facts in design as multiple facts will be taken care automatically when cardenilities are set 1-n between facts and dimensions. FM will automatically resolve multiple paths via stitched queries.
Thank You,
Vishwas Gupta
No comments:
Post a Comment