<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space">
<DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=007474219-06062007>I
understand that you'd like to use a common set of functions, but we were there
first :-)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007>Seriously, are there SQL functions that don't have
PowerHouse equivalents? Keep in mind that we're not using pure SQL but a Cognos
version of it. Our middleware must allow the functions and then passes them on
to the database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=007474219-06062007>I'd
like to make sure I understand the passed in values request. Can you
elaborate?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=007474219-06062007>As for
the left hand functions, that's because of the way our parser was designed
(>25 years ago). A few years ago, we looked at it again but found that it got
confused if we allowed expressions on the left. And at this point, we don't want
to introduce something new at that fundamental a level and risk
stability.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=007474219-06062007>CSV is
still on the table but don't hold your breath. One of the reasons for the dearth
of QUIZ enhancements is the prevalence of reporting options from relational
databases. Also, we are constrained by the architecture.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=007474219-06062007>By the
way, it's easy to output a pdf report in QUIZ for Windows. Simply get hold of
one of the pdf printer drivers, such as PDFCreator at sourceforge.org, and use
it in the string following SET REPORT DEVICE PRINTER.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=007474219-06062007>Bob</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com] <B>On Behalf
Of </B>Darren Reely - Lists<BR><B>Sent:</B> June 6, 2007 3:24 PM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> Re: Qdesign enhancement -
Required Secondary file<BR><BR></FONT></DIV>Me to.
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV style="MARGIN: 0px">More interesting feature additions from my experience
is the ability to use native SQL functions for the DB engine I'm using, or an
_easy_ way to add functions that would be useable from Quick, Quiz, and
QTP.</DIV>
<DIV style="MARGIN: 0px"><BR class=khtml-block-placeholder></DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica">Local scope
variables.</DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><BR
class=khtml-block-placeholder></DIV>
<DIV style="MARGIN: 0px">Another one is the ability to use a passed in value
to a screen as the input for a fetch, when that value is passed as opposed to
empty, otherwise allow for interactive user input.</DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><BR></DIV>
<DIV style="MARGIN: 0px">My favorite is that you can't have left sided
evaluations;</DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><BR></DIV>
<DIV style="MARGIN: 0px"><SPAN class=Apple-tab-span
style="WHITE-SPACE: pre"></SPAN>define x = value if function1() =
function2()</DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><BR></DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica">You have
to do;</DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><BR
class=khtml-block-placeholder></DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><SPAN
class=Apple-tab-span style="WHITE-SPACE: pre"></SPAN>define z =
funciton1()</DIV>
<DIV style="MIN-HEIGHT: 17px; MARGIN: 0px; FONT: 14px Helvetica"><SPAN
class=Apple-tab-span style="WHITE-SPACE: pre"></SPAN>define x = value if
z = function2()</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>As far as HTML support, Quiz seems the natural place to start as its
output can be used almost anywhere. Also recall our recent CSV file
discussion. Perhaps dump Quiz for ReportNet.</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV><BR>
<DIV>
<DIV>On Jun 6, 2007, at 9:22 AM, Pickering, John (NORBORD) wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV class=Section1>
<DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">></SPAN></FONT><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">A new
option (REQUIRED) to a secondary file that would NOT generate the OPTIONAL
in the generated FIND procedure.</SPAN></FONT><O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Me too. Me too. Me
too.</SPAN></FONT></P></DIV></DIV></BLOCKQUOTE><BR></DIV><BR></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. </DIV></BODY></HTML>