COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: dammora on 03 May 2007 12:53:49 PM

Title: (SOLVED) Round-down function in ReportNet/FM 8
Post by: dammora on 03 May 2007 12:53:49 PM
Is there an equivalent Impromptu 'Round-down' function in ReportNet or FrameWork Manager? I haven't seen any functions that are comparable.  The 'round' function doesn't provide the result I require.

Any ideas?
Title: Re: Round-down function in ReportNet/FM 8
Post by: COGNOiSe administrator on 04 May 2007 08:35:58 AM
What results do you require, old friend?
Title: Re: Round-down function in ReportNet/FM 8
Post by: dammora on 04 May 2007 02:44:12 PM
What a nice surprise!  :P

Actually I figured it out, I used the 'FLOOR' function.  I do have another question though, if you are interested.

How do you deploy just the user from CRN to Cog 8 CRN?  I think I wiped out the users but not the roles.

Thanks!   :D
Title: (CLOSED) Round-down function in ReportNet/FM 8
Post by: dammora on 04 May 2007 03:24:54 PM
OK, I have figured this one out too.  Thanks!!!
Title: Re: (SOLVED) Round-down function in ReportNet/FM 8
Post by: COGNOiSe administrator on 05 May 2007 09:24:30 PM
You know, around here, it is a common practice to share a solution, even if you've figured it out yourself ...
Title: Re: (SOLVED) Round-down function in ReportNet/FM 8
Post by: dammora on 10 May 2007 10:54:59 AM
Ooops! My bad  :-[

The 'FLOOR' function replaces the 'ROUND-DOWN' function in ReportNet.   If you create the report in QS using 'ROUND-DOWN' and open it up in RS, it translates the query for you automatically.

Thanks for you help buddy  ;D
Title: Re: (SOLVED) Round-down function in ReportNet/FM 8
Post by: COGNOiSe administrator on 10 May 2007 03:37:34 PM
Any time, sweetie ...  ;D