<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v = "urn:schemas-microsoft-com:vml" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.6000.16825" name=GENERATOR>
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:sans-serif;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US style="MARGIN: 4px 4px 1px; FONT: 12pt Trebuchet MS" vLink=purple link=blue>
<DIV>Currently, I am using the export/import options to transfer data from excel to hyperion and vise versa. </DIV>
<DIV>I found out that running a query via excel also gives you the ability to pick your parameters, however, using excel to connect to the Datamart as an external data source requires a privilege to perform such operation. </DIV>
<DIV> </DIV>
<DIV>Please let me know who would provide us the access to do this ? It'll be interesting to explore this tool.</DIV>
<DIV> </DIV>
<DIV>Thank you.</DIV>
<DIV> </DIV>
<DIV><BR>>>> "FLICKER Linda * SCD SARS" <linda.flicker@state.or.us> 6/1/2009 8:05 AM >>><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Good Morning,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">A fellow Datamart user is trying to use Excel to connect to the Datamart and is having some issues. If anyone has knowledge that they can share on this topic please respond! Any information we get will be shared with all.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">See below! Thanks and have a great day!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=sans-serif color=blue size=2><SPAN style="FONT-SIZE: 11pt; COLOR: blue; FONT-FAMILY: sans-serif">"I was wondering if anyone out there had set up an .odc file (this is the Excel equivalent to an .oce file) to connect in to the datamart that included the nifty custom joins that comes with the .oce for Hyperion queries?"</SPAN></FONT><FONT face=Arial color=blue size=2><SPAN style="FONT-SIZE: 11pt; COLOR: blue; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><B><FONT face="Times New Roman" color=purple size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: purple">Linda Flicker</SPAN></FONT><o:p></o:p></B></P>
<P class=MsoNormal><B><FONT face="Times New Roman" color=purple size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: purple">Sr. Datamart Business Analyst</SPAN></FONT><o:p></o:p></B></P>
<P class=MsoNormal><B><FONT face="Times New Roman" color=purple size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: purple">State Controller's Division-SARS</SPAN></FONT><o:p></o:p></B></P>
<P class=MsoNormal><B><FONT face="Times New Roman" color=purple size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: purple">(503) 373-7277 Ext. 281</SPAN></FONT><o:p></o:p></B></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>