COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: kchandan on 22 Feb 2012 05:55:01 AM

Title: loop for query item
Post by: kchandan on 22 Feb 2012 05:55:01 AM
Hi All,
How can i write a loop in calculation definition for a query item?
Title: Re: loop for query item
Post by: blom0344 on 22 Feb 2012 07:22:57 AM
procedural logic should be covered by a stored procedure in the database. The definition of a dataitem should be such that set-based SQL can be build from it
Title: Re: loop for query item
Post by: navissar on 22 Feb 2012 11:51:40 AM
No loop in SQL, so no loop in query item. What is the calculation? I seldom encounter something that demands a real loop.