Introduction of Calling Quick Screens as Functions
Robert Edis
robeconsult@sbcglobal.net
Wed, 26 May 2004 13:53:46 -0700 (PDT)
--0-652805246-1085604826=:8389
Content-Type: text/plain; charset=us-ascii
Chuck
You say here that PH is a language for NORMALIZED data yet you then say Quick offers a solution for multi-dimensional programming. OLAP or multi-dimension data is usually DENORMALISED.
I'm confused.
Blue
"chuck.reinke" <chuck.reinke@sbcglobal.net> wrote:
@font-face { font-family: Tahoma;}@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"}LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"}DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"}A:link { COLOR: blue; TEXT-DECORATION: underline; text-underline: single}SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; text-underline: single}A:visited { COLOR: purple; TEXT-DECORATION: underline; text-underline: single}SPAN.MsoHyperlinkFollowed { COLOR: purple;
TEXT-DECORATION: underline; text-underline: single}P.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"}LI.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"}DIV.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"}P { FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto}SPAN.EmailStyle16 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial}SPAN.EmailStyle20 { COLOR: navy;
FONT-FAMILY: Arial; mso-style-type: personal-reply; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.0pt}SPAN.GramE { mso-style-name: ""; mso-gram-e: yes}DIV.Section1 { page: Section1}OL { MARGIN-BOTTOM: 0in}UL { MARGIN-BOTTOM: 0in}On the subject of perverting Quick, you can think of PowerHouse as a language for NORMALIZED data, which most of us learned (painfully by experinece) was the best way to organize business records.
Yet not all computing is for business records. Statistics, for example, often means mulitdimensional computing. So when it comes to multidimensional programming, Quick offers a solution.
To complicate things further, you can use multiple processes and use the output of a (Quiz,QTP, QUICK) process as the input to a QUICK process.
Set up a file equation to direct QKIN to the process and let it rip. As I remember, the QKIN file needs to be a semicolon delimited file.
I was once involved in developing a student scheduling project, with students, teachers, rooms, classes, and times, that used this approach quite successfully.
Chuck
--0-652805246-1085604826=:8389
Content-Type: text/html; charset=us-ascii
<DIV>Chuck</DIV>
<DIV> </DIV>
<DIV>You say here that PH is a language for NORMALIZED data yet you then say Quick offers a solution for multi-dimensional programming. OLAP or multi-dimension data is usually DENORMALISED. </DIV>
<DIV> </DIV>
<DIV>I'm confused.</DIV>
<DIV> </DIV>
<DIV>Blue<BR><BR><B><I>"chuck.reinke" <chuck.reinke@sbcglobal.net></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content=Word.Document name=ProgId>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<META content="Microsoft Word 10" name=Originator><LINK href="cid:filelist.xml@01C44302.49753470" rel=File-List>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle16 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial
}
SPAN.EmailStyle20 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial; mso-bidi-font-size: 10.0pt
}
SPAN.GramE {
mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
<DIV><FONT face=Arial size=2>On the subject of perverting Quick, you can think of PowerHouse as a language for NORMALIZED data, which most of us learned (painfully by experinece) was the best way to organize business records. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Yet not all computing is for business records. Statistics, for example, often means mulitdimensional computing. So when it comes to multidimensional programming, Quick offers a solution. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>To complicate things further, you can use multiple processes and use the output of a (Quiz,QTP, QUICK) process as the input to a QUICK process.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Set up a file equation to direct QKIN to the process and let it rip. As I remember, the QKIN file needs to be a semicolon delimited file.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I was once involved in developing a student scheduling project, with students, teachers, rooms, classes, and times, that used this approach quite successfully.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Chuck</FONT></DIV></BLOCKQUOTE>
--0-652805246-1085604826=:8389--