Hi Guys,
Earlier i used to work mostly with dimensional reporting and so did not use For clause often.However wheni started to work on relational reporting i noticed that here for clause is used quite often.
So what is the reason for this.Why we do not use for clause much in dimensional reporting.
When working with dimensional model we do not use for much .What is the reason for this .If you use ( FOR clause) sometimes you might get a warning op-ER -0144 .The reason is simple whenever you drag items from a level in a for clause the item should be key of the level because by default cognos will group by key of the level irrespective of what you specify in your for clause.
The error 0144 is just trying to warn you that your for will not be taken into account
Please go through below link on how to solve the error
http://cognossimplified.blogspot.in/2011/10/op-err-0144-grouping-on-property-or.html
Earlier i used to work mostly with dimensional reporting and so did not use For clause often.However wheni started to work on relational reporting i noticed that here for clause is used quite often.
So what is the reason for this.Why we do not use for clause much in dimensional reporting.
When working with dimensional model we do not use for much .What is the reason for this .If you use ( FOR clause) sometimes you might get a warning op-ER -0144 .The reason is simple whenever you drag items from a level in a for clause the item should be key of the level because by default cognos will group by key of the level irrespective of what you specify in your for clause.
The error 0144 is just trying to warn you that your for will not be taken into account
Please go through below link on how to solve the error
http://cognossimplified.blogspot.in/2011/10/op-err-0144-grouping-on-property-or.html
No comments:
Post a Comment