Sorting rows in a cluster
Harvey Orom
harvey@oromconsulting.com
Wed, 20 Oct 2004 21:07:55 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C4B6E8.DEB63ED0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Conrad,
Many thanks. That worked beautifully.
Cheers ... Harvey
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Whittall, Conrad
Sent: Wednesday, October 20, 2004 10:28 AM
To: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
You could use a database view as a non-updateable Primary, and then
retrieve the underlying row from the 'real' table as a Secondary (access via
the primary key included in the view) and allow the user to interact with
the fields from the secondary records...so retaining the default PowerHouse
processing and eliminating the need for procedural loops, etc.
I have used this technique quite a few times with great success.
Best regards,
Conrad
Conrad Whittall
Senior Solutions Architect, Global Customer Services, Cognos Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
----------------------------------------------------------------------------
--
-----Original Message-----
From: Harvey Orom [mailto:harvey@oromconsulting.com]
Sent: Tuesday, October 19, 2004 5:01 PM
To: powerh-l@lists.sowder.com
Subject: Sorting rows in a cluster
Is there any way to present the rows in a cluster in a
PowerHouse Quick screen in a sequence by a column that is not in the primary
file (I.e., the column I want to sort by comes from a reference file.) The
primary file is being updated in this screen.
Thanks in advance...
Harvey Orom
------=_NextPart_000_0000_01C4B6E8.DEB63ED0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:eXclaimer =3D "http://www.exclaimer.co.uk"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><O:SMARTTAGTYPE name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></O:SMARTTAGT=
YPE><O:SMARTTAGTYPE=20
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></O:SMARTTAGT=
YPE><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Arial Black;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: =
"Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D526260404-21102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Conrad,</FONT></SPAN></DIV>
<DIV><SPAN class=3D526260404-21102004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D526260404-21102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Many=20
thanks. That worked beautifully.</FONT></SPAN></DIV>
<DIV><SPAN class=3D526260404-21102004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D526260404-21102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Cheers=20
... Harvey</FONT></SPAN></DIV>
<P><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Whittall, Conrad<BR><B>Sent:</B> Wednesday, October 20, =
2004=20
10:28 AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> =
RE:=20
Sorting rows in a cluster<BR><BR></FONT></DIV>
<DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004>You could use a database view as a =
non-updateable=20
Primary, and then retrieve the underlying row from the 'real' table as =
a=20
Secondary (access via the primary key included in the view) and allow =
the user=20
to interact with the fields from the secondary records...so retaining =
the=20
default PowerHouse processing and eliminating the need for procedural =
loops,=20
etc.</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004></SPAN></FONT> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004>I have used this technique quite a few =
times with=20
great success.</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004></SPAN></FONT> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004></SPAN></FONT><SPAN lang=3Den-us><FONT =
face=3DVerdana=20
size=3D2><SPAN lang=3Den-us><FONT face=3DVerdana size=3D2>Best=20
regards,</FONT></SPAN><BR><SPAN lang=3Den-us><B><I><FONT face=3D"Times =
New Roman"=20
color=3D#000080 size=3D6>Conrad</FONT></I></B></SPAN> </DIV>
<P><SPAN lang=3Den-us><FONT face=3DVerdana color=3D#808080 =
size=3D1>Conrad=20
Whittall</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DVerdana =
color=3D#808080=20
size=3D1>Senior Solutions Architect, Global Customer Services, Cognos=20
Incorporated</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DVerdana=20
color=3D#808080 size=3D1>3755 Riverside Drive, Ottawa, Ontario, K1G =
4K9,=20
Canada</FONT></SPAN></P></FONT></SPAN>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> =
Harvey=20
Orom [mailto:harvey@oromconsulting.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 19, 2004 =
5:01=20
PM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> Sorting rows in a=20
cluster</SPAN></FONT><O:P></O:P></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DSection1>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm">
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm">
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is there any =
way to=20
present the rows in a cluster in a PowerHouse =
Quick screen=20
in a sequence by a column that is not in the primary file =
(I.e., the=20
column I want to sort by comes from a reference file.) =
The=20
primary file is being updated in this=20
screen.</SPAN></FONT><O:P></O:P></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><O:P></O:P></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in=20
advance...</SPAN></FONT><O:P></O:P></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><O:P></O:P></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Arial Black" color=3Dnavy =
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: 'Arial =
Black'">Harvey=20
Orom</SPAN></FONT> <O:P></O:P></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><O:P></O:P></SPAN></FONT></P></DIV></BLOCKQUOTE></BLOCKQUOTE></DIV>=
</BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV>
<P><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT> </P></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0000_01C4B6E8.DEB63ED0--