Data expression error
Deskin, Bob
Bob.Deskin@Cognos.COM
Thu, 16 Oct 2003 13:26:09 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3940A.9697CB20
Content-Type: text/plain;
charset="iso-8859-1"
Sorry if this is obvious but this message comes from the expression
processor. So look at the expressions in the screen which includes all data
sources, not just things that use functions. For example, if you have a LET
verb (LET A = B), the source (B) is treated as an expression. If A is
numeric and you've substructured B (or B is in a substructure) such that B
has non-numeric data, you'll get a data expression error. Other than that,
things like division by zero, nested functions where the function result is
invalid, etc. are the things I'd look for. Note that if your message verbs
use the = option, the source is an expression.
Hope this helps.
Bob Deskin
Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Johnson, Harold A EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]
Sent: Thursday, October 16, 2003 12:55 PM
To: Powerhouse List (E-mail)
Subject: Data expression error
Hi all. Does anyone know of an easy method of tracking down these "Data
Expression Errors" in a quick program? The message only seems to come out
when either an Info/Warning/etc statement is issued or the quick program
ends.
thnx
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details.
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.
------_=_NextPart_001_01C3940A.9697CB20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: Data expression error</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Sorry if this is obvious but this message comes from =
the expression processor. So look at the expressions in the screen =
which includes all data sources, not just things that use functions. =
For example, if you have a LET verb (LET A =3D B), the source (B) is =
treated as an expression. If A is numeric and you've substructured B =
(or B is in a substructure) such that B has non-numeric data, you'll =
get a data expression error. Other than that, things like division by =
zero, nested functions where the function result is invalid, etc. are =
the things I'd look for. Note that if your message verbs use the =3D =
option, the source is an expression.</FONT></P>
<P><FONT SIZE=3D2>Hope this helps.</FONT>
</P>
<P><FONT SIZE=3D2>Bob =
Deskin =
</FONT>
<BR><FONT SIZE=3D2>Product Manager, Application Development Tools, =
Cognos Inc.</FONT>
<BR><FONT SIZE=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: =
(613) 727-1178</FONT>
<BR><FONT SIZE=3D2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON =
K1G 4K9 CANADA</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Johnson, Harold A EDUC:EX</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:Harold.A.Johnson@gems1.gov.bc.ca">mailto:Harold.A.Johnson=
@gems1.gov.bc.ca</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, October 16, 2003 12:55 PM</FONT>
<BR><FONT SIZE=3D2>To: Powerhouse List (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: Data expression error</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi all. Does anyone know of an easy method of =
tracking down these "Data</FONT>
<BR><FONT SIZE=3D2>Expression Errors" in a quick program? =
The message only seems to come out</FONT>
<BR><FONT SIZE=3D2>when either an Info/Warning/etc statement is issued =
or the quick program</FONT>
<BR><FONT SIZE=3D2>ends.</FONT>
</P>
<P><FONT SIZE=3D2>thnx</FONT>
</P>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<P><FONT SIZE=3D2>Join us at Cognos' biggest event of the year<I> =
Enterprise 2003, The Cognos Business Forum</I>. Taking place in =
over 25 cities around the world, it's an opportunity for Business and =
IT leaders to learn about strategies for driving performance. Visit<U> =
<A HREF=3D"http://www.cognos.com/enterprise03" =
TARGET=3D"_blank">http://www.cognos.com/enterprise03</A></U> for more =
details. </FONT></P>
<P><FONT SIZE=3D2>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.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C3940A.9697CB20--