<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:Roboto;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:82462462;
mso-list-template-ids:-1683955822;}
@list l0:level1
{mso-level-start-at:19;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:478960498;
mso-list-template-ids:-767684550;}
@list l1:level1
{mso-level-start-at:26;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2
{mso-list-id:760374463;
mso-list-type:hybrid;
mso-list-template-ids:1933329760 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l2:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l3
{mso-list-id:1099444423;
mso-list-template-ids:43663782;}
@list l3:level1
{mso-level-start-at:16;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l4
{mso-list-id:1754627196;
mso-list-template-ids:-238626314;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Datamart users,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We are starting the process to identify the next tool the Datamart team will use to access the Datamart and we would like your help updating the previous ‘Datamart query tool preferences’ list below. The list was created from suggestions
by our Datamart user’s when we transitioned from Hyperion to OBIEE. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">To be clear, <u>based on the current query tool state, we believe we can continue to use OBIEE for at least a few years</u>. However, we plan to search for a suitable replacement to make sure we are in compliant with our query tool standards.
Additional information about this topic will follow in the coming months.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please review the below list and provide suggested updates. In addition, rate your top six most wanted items in order of priority (1 is the highest, 2 is next, and so on down to 6). Send the final info to ‘Datamart.Support@das.oregon.gov’
by <b>November 4, 2024</b>. <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><u>Datamart query tool preferences</u></b>:<o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><u>Category:</u><br>
Features: <span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-ligatures:none">
<o:p></o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormal" style="mso-list:l2 level1 lfo3">Works with all web browser applications (Edge, Chrome, Firefox, etc.).<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Ability to query large volumes of data (over 1 million rows of data).
<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Ability to query other databases (including individual agency databases).<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Easy to integrate with Microsoft Office Products (Excel, Access, etc.) Importing and exporting.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Dashboard features, drag and drop filters.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Conversion capability with old data queries.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Ability to join internal data sources with Datamart data.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Undo button.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Copy query to another file.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Custom programming of fields (formula add).<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Easy documentation feature that allows you to describe how query/report was built. Put text anywhere not just on the dashboard.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Ability to interface with applications like ORBITS to bring together many sources of information.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Easily integrate with Acrobat both importing and exporting.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Ability to import or connect to an .rpt or .pdf file.<o:p></o:p></li><li class="MsoNormal" style="margin-bottom:8.0pt;line-height:105%;mso-list:l2 level1 lfo3">
Being able to create a model that you build once, then open on any other similar file.<o:p></o:p></li></ol>
<p class="MsoNormal">Query building:<o:p></o:p></p>
<ol style="margin-top:0in" start="16" type="1">
<li class="MsoNormal" style="mso-list:l2 level1 lfo3">Complex formulas in request fields along with in the Results section.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">A way to subtotal pivots.<o:p></o:p></li><li class="MsoNormal" style="margin-bottom:12.0pt;mso-list:l2 level1 lfo3">Append new data to existing results of a query (‘Local Results’).<o:p></o:p></li></ol>
<p class="MsoNormal">Reporting capability: <o:p></o:p></p>
<ol style="margin-top:0in" start="19" type="1">
<li class="MsoNormal" style="mso-list:l2 level1 lfo3">Interactive reports, filters and parameters can easily be changed by the user, not the report creator.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Scheduler – schedule reports to run certain times of month, year, automatically run report and email reports to customer, web based.
<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Robust report format functionality and customization.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Repository of reports – statewide.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Forecasting and Modeling features.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Web data query capability.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">The ability for the report server to produce output based on a URL request in an html viewer.<o:p></o:p></li></ol>
<p class="MsoNormal"><br>
Other: <o:p></o:p></p>
<ol style="margin-top:0in" start="26" type="1">
<li class="MsoNormal" style="mso-list:l2 level1 lfo3">ODBC compliant connectivity<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Long life expectancy of product.
<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">If desktop based, has the ability to work with 64-bit based system.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">The query tool program is similar to what other states are using.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Ease of agency technical staff to understand the connectivity.<o:p></o:p></li><li class="MsoNormal" style="mso-list:l2 level1 lfo3">Does the query tool company have a user group where users can learn from each other or a user manual/guide that can be readily accessed to troubleshoot items.<o:p></o:p></li></ol>
<p class="MsoNormal"><span style="font-family:Roboto"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Thank you for your time and if you have any questions, please contact Datamart support.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;mso-ligatures:none">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;mso-ligatures:none">Sr. Datamart Business Analyst<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
</body>
</html>