tag:blogger.com,1999:blog-36303858975176374232024-03-03T16:25:31.683-08:00Look Smarter Than You Are - Tracy's BlogTracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-3630385897517637423.post-5162042470196390062011-04-10T13:48:00.000-07:002011-04-10T13:56:36.526-07:00New Book Released on Essbase StudioWow... it has been a <em>REALLY<strong> </strong></em>long time since I've posted a entry to this blog (where has the time gone?). Though I certainly have a great reason to post news today! Oracle ACE Director and fellow interRel employee, Glenn Schwartzberg has written the new edition the Look Smart Than You Are series, Look Smarter Than You Are with Essbase Studio. Glenn has done a great job and I recommend this book to all Essbase Administrators. You can find the book here on Lulu (<a href="http://www.lulu.com/product/paperback/look-smarter-than-you-are-with-essbase-studio/15261669">http://www.lulu.com/product/paperback/look-smarter-than-you-are-with-essbase-studio/15261669</a> ).Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com16tag:blogger.com,1999:blog-3630385897517637423.post-49340954842332643822008-12-02T14:38:00.000-08:002008-12-02T14:45:10.566-08:00How do I learn about Hyperion / Oracle EPM System?This posting is for those folks new to Essbase/Hyperion / Oracle EPM System. You're just starting out... where to go?<br /><br />Where to start in Oracle EPM System / Hyperion… Training is the best place to start when learning Oracle EPM System. For Planning or Essbase, start with Essbase. Planning data is stored in Essbase (so does the new Hyperion Profitability & Cost Management solution and other upcoming tools) so learning the fundamentals of Essbase is key. I definitely recommend attending interRel or Oracle training classes.<br /><br />Attend the conferences – Collaborate 2009 (May) will host a number of presentations on Oracle EPM System with a focus for the business users. Kaleidoscope 2009 (June) will provide an extensive track on Oracle EPM System with a focus for the administrators and developers. Last year Kaleidoscope was essentially a 4 day advanced Essbase training course (limited marketing, main content focus) and I expect this year to be even better.<br /><br />If training isn’t possible with your budget, find live / recorded webcasts and literature. Shameless but helpful plug: interRel offers FREE webcasts on Oracle EPM System / Hyperion every Thursday at 1pm CST. Oracle and other partners host webcasts as well. How do you find about them? Join a user group like ODTUG, OAUG, IOUG, or local user groups.<br /><br />Related to available reading…We’ve also written two books on Essbase: Look Smarter Than You Are with Essbase System 9 that will teach you Essbase from start to finish, building an Essbase database, managing the database, and analyzing data in the database and for end users, we have written Look Smarter Than You Are with Essbase: An End User’s Guide. Coming early next year we will have the 11x Essbase books out along with a Hyperion Planning series. I would love to recommend some other books but as of now there aren’t any other Essbase/Hyperion specific books.<br /><br />You can also get some good information in the technical documentation as well – <a href="http://www.oracle.com/technology/documentation/epm.html">http://www.oracle.com/technology/documentation/epm.html</a>.<br /><br />Definitely join the Users forum - <a href="http://forums.oracle.com/forums/category.jspa?categoryID=16">http://forums.oracle.com/forums/category.jspa?categoryID=16</a><br /><br />Blogs are a great way to learn and find information… My favorite blogs for Hyperion / Oracle EPM System:<br /><a href="http://www.looksmarter.blogspot.com/">http://www.looksmarter.blogspot.com/</a><br /><a href="http://www.looksmarterthanyouare2.blogspot.com/">http://www.looksmarterthanyouare2.blogspot.com/</a><br /><a href="http://glennschwartzbergs-essbase-blog.blogspot.com/">http://glennschwartzbergs-essbase-blog.blogspot.com/</a><br /><a href="http://essbaselabs.blogspot.com/">http://essbaselabs.blogspot.com/</a><br /><a href="http://john-goodwin.blogspot.com/">http://john-goodwin.blogspot.com/</a><br /><a href="http://timtows-hyperion-blog.blogspot.com/">http://timtows-hyperion-blog.blogspot.com/</a><br /><br />Download and install the applications and begin to play with them. Make sure to read the installation documentation because order is important as you install / configure the components. Most of the products have sample applications that you can utilize to learn about the various features.<br /><br />And finally (last shameless plug), give your friendly consultants a call. I personally recommend interRel Consulting. :-)Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com18tag:blogger.com,1999:blog-3630385897517637423.post-54770715354066550672008-12-02T14:27:00.000-08:002008-12-02T14:35:39.142-08:00Outline Order in BSO Databases<p class="MsoNormal">So what should the outline order be for your BSO databases? Many of you Essbase experts have heard this before but just in case…</p><p class="MsoNormal">Outline ordering (and in general Essbase tuning) is not an exact science. But I recommend you start here and then tune / test …</p><ol style="MARGIN-TOP: 0in" type="1"><li class="MsoNormal">Largest Dense Dimensions</li><li class="MsoNormal">Smallest Dense Dimensions</li><li class="MsoNormal">Smallest Aggregating Sparse Dimensions</li><li class="MsoNormal">Largest Aggregating Sparse Dimensions</li><li class="MsoNormal">Non-aggregating Sparse Dimensions</li></ol><p class="MsoNormal" style="MARGIN-LEFT: 0.25in"> </p><p class="MsoNormal">Dense dimensions - define the data block and must reside at the top of the outline</p><p class="MsoNormal">Aggregating Sparse dimensions - dimensions that will be calculated to create new parent values</p><p class="MsoNormal">Non-Aggregating Sparse dimensions - dimensions that organizes the data into logical slices </p><ul><li><div class="MsoNormal">Placing these dimensions as the first Sparse dimensions positions them to be the first dimensions included in the calculator cache</div></li><li><div class="MsoNormal">Data is often times more dispersed within the database</div></li><li><div class="MsoNormal"> Example - Scenario, Year or Version</div></li></ul><p class="MsoNormal">Here’s an dimension ordering example based on member count:</p><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 255pt; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="340" border="1"><tbody><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Dimension</b> </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Type-Size</b> </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><i>Accounts </i></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><i>D – 94 </i></p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Time Periods </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">D – 21 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Metrics (Hrs, AHR, $) </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">D – 14 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Scenarios </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">AS – 9 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Job Code </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">AS – 1,524 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Organization </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">AS – 2,304 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Versions </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">NAS – 7 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Years </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">NAS – 7 </p></td></tr></tbody></table><p class="MsoNormal"> </p><p class="MsoNormal">Here’s an example based on dimension density (Ordering the dense dimensions from most dense to least dense maximizes the clustering of thedata):</p><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 638pt; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="851" border="1"><tbody><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Dimension</b> </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Type-Size</b> </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Density After Calc</b> </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Density After Load</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b>Data Points Created</b> </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Time Periods </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">D – 21 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">85% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">85% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">- </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Metrics (Hrs, AHR, $) </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">D – 14 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">22% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">22% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">- </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><i>Accounts </i></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><i>D – 94 </i></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><i>3 % </i></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><i>2% </i></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">- </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Scenarios </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">AS – 9 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">22% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">11% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">199 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Job Code </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">AS – 1,524 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">.56% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">.23% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">853 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Organization </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">AS – 2,304 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">.34% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">.09% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">783 </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Versions </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">NAS – 7 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">19% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">19% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">- </p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Years </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">NAS – 7 </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">14% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">14% </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 128pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="171"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">- </p></td></tr></tbody></table><p class="MsoNormal"> </p><p class="MsoNormal">How do I find the density of each dimension?</p><ol style="MARGIN-TOP: 0in" type="1"><li class="MsoNormal">Make the dimension the lone Dense dimension</li><li class="MsoNormal">Load and calculate just that dimension</li><li class="MsoNormal">Check the block density value in Administration Services >Database<> Statistics</li></ol><p class="MsoNormal"> </p><p class="MsoNormal">Another consideration for outline ordering is your compression type. One compression type RLE (Run Length Encoding) is a good compression type when your data has many zeros or often repeats (found in our budgeting applications. RLE will evaluate and use RLE, Bitmap or IVP for compression. So how does outline ordering impact compression? The first dense dimension determines your “columns” in PAG file. Compression will take place from left to right, top to bottom. </p><p class="MsoNormal">The standard method is to place Accounts / Measures first in every outline. If we were to do that, the .pag file would look like the following (simplified version):</p><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 8.5in; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="816" border="1"><tbody><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b><i>BUDGET</i></b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Sales</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">COGS</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Margin</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Exp.</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Profit</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">January</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">100</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">20</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">February</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">100</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">20</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">March</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">100</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">20</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">April</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">120</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">70</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">40</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">May</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">120</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">70</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">40</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 134.25pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="179"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">June</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">120</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 97.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="130"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">70</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 93.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="124"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 105.15pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="140"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">40</p></td></tr></tbody></table><p class="MsoNormal"> </p><p class="MsoNormal">But if we move Time to first dense dimension and we get the following (notice repeating values):</p><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 9in; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="864" border="1"><tbody><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 125pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="167"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal"><b><i>BUDGET</i></b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 79pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="105"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Jan</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Feb</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Mar</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 87pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="116"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Apr</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">May</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 76pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="101"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Jun</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 125pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="167"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Sales</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 79pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="105"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">100</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">100</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">100</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 87pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="116"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">120</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">120</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 76pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="101"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">120</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 125pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="167"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">COGS</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 79pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="105"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 87pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="116"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 76pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="101"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 125pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="167"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Margin</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 79pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="105"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">50</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 87pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="116"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">70</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">70</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 76pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="101"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">70</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 125pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="167"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Exp.</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 79pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="105"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 87pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="116"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 76pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="101"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">30</p></td></tr><tr><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 125pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="167"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">Profit</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 79pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="105"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">20</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">20</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 91pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="121"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">20</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 87pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="116"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">40</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">40</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 76pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid" valign="top" width="101"><p class="MsoNormal" style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal">40</p></td></tr></tbody></table><p class="MsoNormal"> </p><p class="MsoNormal">So… Time should be dense and listed first in the outlinewhen using RLE compression.</p>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com1tag:blogger.com,1999:blog-3630385897517637423.post-76167033740600583042008-12-02T14:10:00.000-08:002008-12-02T14:26:13.523-08:00ASO vs. BSO?A common question that I get - when should I implement an ASO database vs. a BSO database? First, let's view some similarities between the two...<br /><br /><table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=405 style='width:303.4pt;border-collapse:collapse;border:none'> <tr style='height:30.0pt'> <td width=145 valign=top style='width:108.9pt;border:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'></td> <td width=120 valign=top style='width:1.25in;border:solid black 1.0pt; border-left:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'><b>BSO </b></p> </td> <td width=139 valign=top style='width:104.5pt;border:solid black 1.0pt; border-left:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'><b>ASO </b></p> </td> </tr> <tr style='height:30.0pt'> <td width=145 valign=top style='width:108.9pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Build dimensions </p> </td> <td width=120 valign=top style='width:1.25in;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=139 valign=top style='width:104.5pt;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> </tr> <tr style='height:30.0pt'> <td width=145 valign=top style='width:108.9pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Load data </p> </td> <td width=120 valign=top style='width:1.25in;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=139 valign=top style='width:104.5pt;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> </tr> <tr style='height:30.0pt'> <td width=145 valign=top style='width:108.9pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Write back to level 0</p> </td> <td width=120 valign=top style='width:1.25in;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=139 valign=top style='width:104.5pt;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> </tr> <tr style='height:30.0pt'> <td width=145 valign=top style='width:108.9pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Retrieve data </p> </td> <td width=120 valign=top style='width:1.25in;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=139 valign=top style='width:104.5pt;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> </tr> <tr style='height:30.0pt'> <td width=145 valign=top style='width:108.9pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Partitioning / Sharing Data </p> </td> <td width=120 valign=top style='width:1.25in;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=139 valign=top style='width:104.5pt;border-top:none;border-left: none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:30.0pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y (target or source in 11x) </p> </td> </tr></table><br /><br />Key differences ...<br /><br /><table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=437 style='width:328.1pt;border-collapse:collapse;border:none'> <tr style='height:29.2pt'> <td width=251 valign=top style='width:188.0pt;border:solid black 1.0pt; padding:0in 5.4pt 0in 5.4pt;height:29.2pt'></td> <td width=91 valign=top style='width:68.1pt;border:solid black 1.0pt; border-left:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'><b>BSO </b></p> </td> <td width=96 valign=top style='width:1.0in;border:solid black 1.0pt; border-left:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'><b>ASO </b></p> </td> </tr> <tr style='height:29.2pt'> <td width=251 valign=top style='width:188.0pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Unlimited dimensions and members </p> </td> <td width=91 valign=top style='width:68.1pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>N </p> </td> <td width=96 valign=top style='width:1.0in;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> </tr> <tr style='height:29.2pt'> <td width=251 valign=top style='width:188.0pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Write back to any level </p> </td> <td width=91 valign=top style='width:68.1pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=96 valign=top style='width:1.0in;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>N </p> </td> </tr> <tr style='height:29.2pt'> <td width=251 valign=top style='width:188.0pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Advanced calculation engine </p> </td> <td width=91 valign=top style='width:68.1pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=96 valign=top style='width:1.0in;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>N </p> </td> </tr> <tr style='height:29.2pt'> <td width=251 valign=top style='width:188.0pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Calc scripts vs. MDX formulas </p> </td> <td width=91 valign=top style='width:68.1pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=96 valign=top style='width:1.0in;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>N </p> </td> </tr> <tr style='height:29.2pt'> <td width=251 valign=top style='width:188.0pt;border:solid black 1.0pt; border-top:none;padding:0in 5.4pt 0in 5.4pt;height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Partitioning / Sharing Data </p> </td> <td width=91 valign=top style='width:68.1pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Y </p> </td> <td width=96 valign=top style='width:1.0in;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt; height:29.2pt'> <p class=MsoNormal style='margin-bottom:10.0pt;line-height:115%'>Limited – pre-11x </p> </td> </tr></table><br /><br />In short, use BSO when you need to write back to any level or perform complex calculations. Use ASO for the larger, aggregation focused databases with many dimensions and many members.<br /><br />In the 11 world where I can now make an ASO database the source of a partition, I can take advantage of the BSO strengths (write back to any level, powerful calculation engine) and then source this information to a consolidated ASO database that maybe has the volumes of detail from other sources. (Note - the new Hyperion Profitability and Cost Management solution uses this model: BSO for allocation calcs and loads to an ASO cube for reporting).<br /><br />Check out the DBAG for detailed comparison tables on ASO vs. BSO.Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com7tag:blogger.com,1999:blog-3630385897517637423.post-64598643368122491392008-10-12T18:14:00.000-07:002008-10-12T18:18:55.095-07:00SOX Report Card - Enterprise vs. Financial ManagementI can't take credit for this table - I came across this in a Hyperion presentation and it is pretty helpful in making the case to switch to Financial Management.<br /><br /><table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" width="508" style="'width:381.35pt;border-collapse:collapse;border:none'"> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"></td> <td width="144" valign="top" style="'width:1.5in;border:solid"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;"><b>Financial Management</b></p> </td> <td width="114" valign="top" style="'width:85.5pt;border:solid"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;"><b>Enterprise</b></p> </td> </tr> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Single version of the truth</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Timeliness / Speed of close</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Adjustment capabilities</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Workflow</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">C</p> </td> </tr> <tr style="'height:26.5pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Audit functionality</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">C</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Documentation</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">F</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="250" valign="top" style="'width:187.85pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Internal controls / email alerting</p> </td> <td width="144" valign="top" style="'width:1.5in;border-top:none;border-left:none;"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">A</p> </td> <td width="114" valign="top" style="'width:85.5pt;border-top:none;border-left:"> <p class="MsoNormal" align="center" style="'margin-bottom:10.0pt;text-align:center;">F</p> </td> </tr></table>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com0tag:blogger.com,1999:blog-3630385897517637423.post-33084918056354413092008-10-12T18:09:00.000-07:002008-10-12T18:12:22.537-07:00Enterprise vs. Financial ManagementStill on Enterprise and wondering if it is time to make the jump to Financial Management? Enterprise is still a solid product but the table below will help you understand some of the benefits of the FM solution:<br /><br /><table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" width="502" style="'width:376.85pt;border-collapse:collapse;border:none'"> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'"><b>Hyperion Financial Management</b></p> </td> <td width="294" valign="top" style="'width:220.5pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'"><b>Hyperion Enterprise</b></p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Unify financial and operating results</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Consolidation and reporting (regulatory filings)</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">12 Smart dimensions</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">4 Fixed dimensions</p> </td> </tr> <tr style="'height:26.5pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Scalable to thousands of users</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Client / server architecture – limit to 150 users</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Web enabled</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Microsoft Windows architected – distributed deployment – some web</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">24 by 7 Availability</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Offline maintenance and backup required</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Easy to customize Web User interface</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">HTML programming required for customized user interface</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Hyperion Financial Management</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Hyperion Enterprise</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Drag and drop, oriented reporting with Financial Reporting</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Script based reporting</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Adhoc analysis with drill down capabilities</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Not available</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Process Workflow</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Not available</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Robust controls and audit trails</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Some controls and audit trails</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Integration with Hyperion Planning</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Not available</p> </td> </tr> <tr style="'height:26.4pt'"> <td width="208" valign="top" style="'width:156.35pt;border:solid"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Shared security maintenance of users and groups across Hyperion products</p> </td> <td width="294" valign="top" style="'width:220.5pt;border-top:none;border-left:"> <p class="MsoNormal" style="'margin-bottom:10.0pt;line-height:115%'">Not available</p> </td> </tr></table>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com2tag:blogger.com,1999:blog-3630385897517637423.post-7689863094293820462008-10-12T17:42:00.000-07:002008-10-12T18:12:15.186-07:00UFC: Web Analysis vs. Interactive ReportingPretty exciting matchup, right? At a high level review, you'll note that Web Analysis and Interactive Reporting overlap on a number of key features. So which tool is the right tool? Historically, IR was good at relational reporting and analysis. WA was good at Essbase reporting and analysis. With version 9.3.1, Interactive Reporting introduced a new CubeQuery feature that now allows it to better report against Essbase (prior to 9.3.1, there were many frustrations when trying to use IR with Essbase). CubeQuery closely models the functionality that is provided with Web Analysis. What is really cool? You can now easily combine Essbase and relational data very easily in IR dashboards and reports.<br /><br />Let's look in a bit more detail, comparing the advanced analytic capabilities between IR CubeQuery and WA:<br /><br /><br /><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 672pt; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="896" border="1"><tbody><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>WA Studio </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>WA Workspace </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>IR Studio </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>IR Web Client </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>IR HTML </b></p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Basic Drilling </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Swap Rows and Columns </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Client install </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Required first the first time </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No install necessary </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Client application </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Required the first time </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No install necessary </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Adhoc Query </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Member Selection </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">High </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">High </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Medium </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Medium </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">None </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Traffic Lighting </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes – Called Spotlighter </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes – Called Spotlighter </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Formatting / Presentation </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Save Personal Queries </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 112pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="149"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No </p></td></tr></tbody></table><br /><br /><br />Next let's compare the dashboarding capabilities between the two:<br /><br /><br /><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 6.3in; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="605" border="1"><tbody><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Web Analysis </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Interactive Reporting </b></p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Complexity to Create </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Medium </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Medium - Complex </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Requires Programming </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">None </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes – Java scripting</p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Flexibility </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">High </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Very high </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Drillable within the Dashboard (Essbase sources) </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">No (but in future versions) </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Present Essbase Data with Relational Data </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes – but not well </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Data Controls </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Yes </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Risk (when using Essbase as data source) </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Low </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Medium-High (new) </p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Time to Implement (when using Essbase as a data source) </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Lower </p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 2.1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="202"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%">Higher (new) </p></td></tr></tbody></table><br /><br /><br />So in summary, what is the best tool?<br /><br />It depends…<br /><br /><ul><li>Technically you could use both but … </li><li>IR requires Java Scripting knowledge for creating and maintaining dashboards </li><li>Learning curve for both products (similar concepts but steps and design considerations are completely different) </li></ul><p> </p><ul><li>Web Analysis if you are only reporting on Essbase</li><li>Interactive Reporting if you report against relational sources </li><li>Interactive Reporting if you report against Essbase and relational sources in the same report or dashboard with considerations*<br />*Java scripting<br />*New (available in 9.3.1); Some fixes and enhancements in 11.1.1<br /></li><li>Web Analysis if you don’t have any technical resources available / programmers (Web Analysis is easier to learn for administrators and no Java Scripting or “coding” required)</li><li>From an basic end user perspective using Essbase, IR and WA have the same functionality for the most part (there may be a few more features in WA)<br /> - Keep only, remove only<br /> - Navigation is different between the 2 tools – training consideration<br /></li><li>From a power end user perspective, Web Analysis provides more adhoc advanced analytic features against Essbase<br /><br /><br /><br /></li></ul>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com20tag:blogger.com,1999:blog-3630385897517637423.post-18276544759693821072008-10-12T16:00:00.001-07:002008-10-12T16:10:25.366-07:00IR vs. WA vs. FR vs. Smart ViewA number of products are currently available for reporting and analysis against the Hyperion Suite of products. Which tool is the right tool for me? The answer is probably not just one tool but at least two. Here is a high level matrix comparing the strengths of each of one of the tools:<br /><br /><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 513.9pt; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="685" border="1"><tbody><tr style="HEIGHT: 59.15pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 59.15pt" valign="top" width="181"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 59.15pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Interactive Reporting</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 59.15pt" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Financial Reporting</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 59.15pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Web Analysis</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 59.15pt" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Smart View</b></p></td></tr><tr style="HEIGHT: 36.85pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 36.85pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Relational Data Source</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 36.85pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 36.85pt" valign="top" width="114"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 36.85pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">(Technically, yes but not well)</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 36.85pt" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes, OBIEE in v11.1.1</p></td></tr><tr style="HEIGHT: 57.9pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.9pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Essbase Data Source</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.9pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">(9.3.1)</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.9pt" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.9pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.9pt" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td></tr><tr style="HEIGHT: 57.75pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Printable, Formatted Reports</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="120"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td></tr><tr style="HEIGHT: 57.75pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Adhoc Analysis</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="114"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td></tr><tr style="HEIGHT: 57.75pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Dashboarding</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="114"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt" valign="top" width="132"></td></tr><tr style="HEIGHT: 57.65pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Charting</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes, but not as good as the others</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="132"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td></tr><tr style="HEIGHT: 57.65pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 135.9pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="181"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Web</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 85.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="114"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.25in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="120"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">X</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 99pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.65pt" valign="top" width="132"></td></tr></tbody></table><br /><br />So the big question, which of these tools will be around in the future? Financial Reporting - Yes. We're already hearing about a new tool Oracle Answers+ that will be the direction for advanced analytics and dashboarding. From what I've hear (I've haven't seen this product yet), it is going to be a great solution but it is not Hyperion ready just yet. Smart View - Yes.<br /><br />So what about Interactive Reporting and Web Analysis? This is completely unofficial / my own opinion so please take that into consideration. IR will have lifetime support but I think we will see new features not added to this product in the future (not any time soon though). I think Web Analysis will be around until we see Answers+ matching the feature set of WA (which I think is a ways down the road).<br /><br />A related question - Web Analysis and Interactive Reporting have many of the same capabilities. Which tool is the best? I have a separate blog entry addressing that question. Check it out.Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com0tag:blogger.com,1999:blog-3630385897517637423.post-75788656538619081772008-10-12T15:52:00.000-07:002008-10-12T15:55:52.219-07:00Smart View Query Designer vs. Regular Adhoc QueryIn the latest versions of Smart View, a query designer is provided to create queries in Excel against Essbase. I've gotten a few questions from clients related to this new tool ... Why would I use the Query Designer vs. just using the adhoc analysis / member selection capabilities? See the matrix below to view a comparison:<br /><br /><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 430.2pt; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="574" border="1"><tbody><tr style="HEIGHT: 15.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><i>Regular Query vs. Query Designer </i></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Regular Adhoc Query</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Query Designer</b></p></td></tr><tr style="HEIGHT: 15.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>POV, Rows, Columns </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 15.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.2pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Member Filters </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.2pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.2pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 15.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Data Filters </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">N</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 19.7pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 19.7pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>You know the Query Definition at the Beginning </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 19.7pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Good</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 19.7pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Best</p></td></tr><tr style="HEIGHT: 12pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 12pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>You’ve drilled into a query and want to go back to original starting point </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 12pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Good</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 12pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Best</p></td></tr><tr style="HEIGHT: 15.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Free form MDX </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">N</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 15.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Save Queries using Microsoft Save </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 15.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 218.7pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="292"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Copy across worksheets </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="138"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 15.95pt" valign="top" width="144"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr></tbody></table>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com1tag:blogger.com,1999:blog-3630385897517637423.post-66596196127765565702008-10-12T15:13:00.000-07:002008-10-12T15:48:47.084-07:00Formatting Options in Smart ViewSmart View provides a few different formatting options - Use Excel Formatting, Capture Formatting and Cell Styles. Which should you use? The most common will be either Excel formatting or Capture Formatting so I compare the two below - in general, I think Excel formatting is the best. Save Styles for possibly budget templates or common formatting when analyzing.<br /><br /><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 5in; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="480" border="1"><tbody><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="240"></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 95.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="127"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Capture Formatting</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 84.6pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="113"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Use Excel Formatting</b></p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="240"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Apply to Data Cells </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 95.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="127"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 84.6pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="113"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 19.6pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 19.6pt" valign="top" width="240"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Apply to Members </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 95.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 19.6pt" valign="top" width="127"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">N</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 84.6pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 19.6pt" valign="top" width="113"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="240"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Retains formatting on Drill </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 95.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="127"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y – for specific data cells</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 84.6pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="113"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">N</p></td></tr><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 2.5in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="240"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Retains formatting on POV change </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 95.4pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="127"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 84.6pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="113"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Y</p></td></tr></tbody></table><br />So the lesson learned here - set up the query / layout first and then apply formatting (probably Excel Formatting for your reports). Know that if you have to drill from there, formatting changes in most cases are lost.Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com0tag:blogger.com,1999:blog-3630385897517637423.post-47127138539107581262008-10-12T14:35:00.001-07:002008-10-12T14:39:07.874-07:00Excel Add-in vs. Smart View 9.3.1 - 50,000 Foot ViewThis tables compares the Excel Add-in vs. Smart View from a high level. The main point you'll find here is that the Excel Add-in only works with Essbase and Excel while Smart View works with the full suite of Hyperion products and with all of the Office products (including PowerPoint and Word).<br /><br /><table class="MsoTableGrid" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 4.75in; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="456" border="1"><tbody><tr style="HEIGHT: 29.2pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b><i>Excel Add-in vs. Smart View (overall)</i></b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Excel Add-in</b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: black 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.2pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center"><b>Smart View</b></p></td></tr><tr style="HEIGHT: 29.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Excel </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 23.35pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 23.35pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Word, PowerPoint, Outlook </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 23.35pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">No</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 23.35pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 29.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Essbase </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 23.35pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 23.35pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>FM and Planning </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 23.35pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">No</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 23.35pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 46.7pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Reporting and Analysis Modules (FR, WA, IR) </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">No</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 46.7pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Copy and Paste Data Points across Office </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">No</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 46.7pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>Visual Data in Excel from Word or PowerPoint </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">No</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 46.7pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr><tr style="HEIGHT: 29.95pt"><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: black 1pt solid; WIDTH: 192pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="256"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%"><b>POV Manager across Office </b></p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 1in; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="96"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">No</p></td><td style="BORDER-RIGHT: black 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 78pt; PADDING-TOP: 0in; BORDER-BOTTOM: black 1pt solid; HEIGHT: 29.95pt" valign="top" width="104"><p class="MsoNormal" style="MARGIN-BOTTOM: 10pt; LINE-HEIGHT: 115%; TEXT-ALIGN: center" align="center">Yes</p></td></tr></tbody></table>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com0tag:blogger.com,1999:blog-3630385897517637423.post-27195292396093925272008-10-11T19:17:00.001-07:002008-10-12T14:23:36.326-07:00Excel Add-in vs. Smart View 9.3.1 - Essbase AnalysisHave you made the switch from our beloved Excel Add-in to the Smart View Add-in? I've been slow to make the change too (I love the Excel Add-in and can use it in my sleep). But Smart View 9.3.1 makes a compelling case and version 11 seals the deal for me (feature comparison for 11.1.1 coming soon). Here is a side-by-side comparison of the Excel Add-in vs. Smart View (for Essbase) features:<br /><br /><table class="MsoNormalTable" style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; WIDTH: 324.5pt; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="433" border="1"><tbody><tr style="HEIGHT: 19.1pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 19.1pt" valign="top" width="200"></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 19.1pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><b><span style="font-family:'Arial','sans-serif';">Excel Add-in 9.3.1 </span></b></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 19.1pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><b><span style="font-family:'Arial','sans-serif';">Smart View Add-in – Essbase 9.3.1 </span></b></p></td></tr><tr style="HEIGHT: 16.55pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.55pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Drill Capabilities </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.55pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.55pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Keep only, Remove Only </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Member Selection </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Query Designer </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes (different) </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Retain Formulas </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes (must select formula preservation) </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes (by default) </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Formatted Reports </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Cell Text / LROs </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Adjust function </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">DTS </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Substitution Variables </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No; Coming Soon </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Member name referenced in a linked formula </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No; Coming Soon </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Cascade </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No; Coming Soon </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Ancestor Position </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.55pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.55pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Use Excel Formatting & Cell Styles </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.55pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.55pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Flashback / Undo </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes – One Undo </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes – Multiple Undo’s </span></p></td></tr><tr style="HEIGHT: 16.85pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.85pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">POV Manager – Copy and Paste POVs </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.85pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.85pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Share POVs </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 16.2pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.2pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Define Default Starting POV </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.2pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.2pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No; Coming soon with Smart Slices </span></p></td></tr><tr style="HEIGHT: 16.2pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.2pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Multi-Source Grids / Reports </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.2pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 16.2pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes (using data points) </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Alias Table defaults to Default </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Submit Data to Essbase </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">MDX vs. Rpt Script </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Rpt Script </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">MDX </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Copy / Paste Data Points </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Refreshable Essbase Data in Word and PowerPoint</span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No</span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes</span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Visualize in Excel </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">Yes </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: left" align="left"><span style="font-family:'Arial','sans-serif';">Launch business rules </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"><p class="MsoNormal" style="TEXT-INDENT: 0in; TEXT-ALIGN: center" align="center"><span style="font-family:'Arial','sans-serif';">No </span></p></td></tr><tr style="HEIGHT: 15.25pt"><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 119.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="200"></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 103.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"></td><td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; WIDTH: 101.5pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.25pt" valign="top" width="150"></td></tr></tbody></table>Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com2tag:blogger.com,1999:blog-3630385897517637423.post-8624918468827112922008-08-04T12:51:00.000-07:002008-10-11T19:49:59.164-07:00Why this blog?Deciphering information from Oracle/Hyperion is difficult. Even if you can find it through the thousands of pages of documentation. So I'm creating this blog with all of my comparison tables for the Oracle Hyperion products. How does Smart View compare to the Excel add-in? When should I use Financial Reporting or Web Analysis? Tables and matrices are how I best assimilate the information and I thought I would share with you. So no lengthy paragraphs on this blog... but hopefully some helpful Oracle Hyperion information.Tracy McMullenhttp://www.blogger.com/profile/15818560855460329671noreply@blogger.com1