</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_PROPERTIES" --><!--DXMETADATA end --> <div style="display: none"> <input type="hidden" id="userDataCache" class="userDataStyle" name="userDataCache"> <input type="hidden" id="hiddenScrollOffset" name="hiddenScrollOffset"> </div> <img id="collapseImage" style="display:none; height:0; width:0;" src="images/collapse.gif"> <img id="expandImage" style="display:none; height:0; width:0;" src="images/expand.gif"> <img id="copyImage" style="display:none; height:0; width:0;" src="images/copycode.gif"> <img id="copyHoverImage" style="display:none; height:0; width:0;" src="images/copycodeHighlight.gif"> <img id="dropDownImage" style="display:none; height:0; width:0;" src="images/drpdown.gif"> <img id="dropDownHoverImage" style="display:none; height:0; width:0;" src="images/drpdown_orange.gif"> <div id="pagetop"> <!--DXMETADATA start type="DesignBanner" --><!--DXMETADATA end --> <table width="100%" id="pagetoptable2" cellspacing="0" cellpadding="0"> <tr> <td><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_RATING%%%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end --></td> </tr> </table> <table width="100%" id="pagetoptable1"> <tr id="pagetoptable1row1"> <td align="left"> <span id="projecttitle"> <!--DXMETADATA start type="ProjectTitle" -->GrapeCity ActiveAnalysis Online Help<!--DXMETADATA end--> </span> </td> <td align="right" rowspan="2"> <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end--> </td> </tr> <tr id="pagetoptable1row2"> <td align="left"> <span id="pagetitle"> <!--DXMETADATA start type="ItemTitle" -->Optimize ActiveAnalysis<!--DXMETADATA end--> </span> </td> </tr> <tr id="pagetoptable1row3"> <td colspan="2"> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=linkcategory" value="<a href=""#seealsobookmark"">%%Phrase:Name=SeeAlso,BlankFormat=See Also%%</a>" --><a href="#seealsobookmark">See Also</a><!--DXMETADATA end --> <span id="feedbacklink"><!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><a href="http://our.componentone.com/groups/forum/business-intelligence/grapecity-activeanalysis/">Support Forum</a> <!--DXMETADATA end --></span> </td> </tr> </table> <!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><table width="100%" id="pagetopbreadcrumbs" cellspacing="0" cellpadding="0"><tr><td> <a href="ActiveAnalysis2.html">ActiveAnalysis 2</a> > <a href="DataDynamicsAnalysisDeveloperGuide.html">ActiveAnalysis Developer Guide</a> > <a href="DeveloperHowTo.html">Developer How To</a> > Optimize ActiveAnalysis</td></tr></table><!--DXMETADATA end --> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_MENU" --><!--DXMETADATA end --> </div> <div class="hspopupbubble" id="hsglossaryitembox"> <p>Glossary Item Box</p> </div> <div id="pagebody"> <div id="mainbody"> <!--DXMETADATA start type="TopicSection" name="BodyText"--><p>There are several things that you can do to improve the performance of your ActiveAnalysis project. The following are concepts to take into consideration when designing your solution.<br></p> <ul> <li>Use Analysis Services as a data source. Since queries are passed to the server and only the needed data is returned, the processing can be much faster. <li>Limit the number of attributes and measures available to certain users. For example, you could provide sales staff with only sales-related fields. <li>Limit the amount of detail data being passed into ActiveAnalysis. For example, if the end users do not need the lowest level of detail, you can pre-aggregate some of the data before passing it in. <li>Instead of relational data sources (*.mdb), create local cubes for faster access to data.</li></li></li></li></ul><!--DXMETADATA end--> <a name="seealsobookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><h1 class="heading"><span class="expandcollapse" tabindex="0"><img id="seealsoToggle" class="toggle" name="toggleSwitch" src="images/collapse.gif">See Also</span></h1><div id="seealsoSection" class="section" name="collapseableSection"><a href="DeveloperHowTo.html">Developer How To</a> <p> <p><b>Troubleshooting</b><br><a href="Troubleshooting.html">Troubleshooting</a> </p> </div><!--DXMETADATA end--> </div> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end --> <div id="pagefooter"> <!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p> </p><p> </p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><!--DXMETADATA end --> </div> <!--DXMETADATA start type="FeedbackSection" --><!--DXMETADATA end --> </div> <!--DXMETADATA start type="Variable" name="NonScrollingPageFooter" format="<div id=nonscrollingpagefooter>%%variable%%</div>" --><div id="nonscrollingpagefooter">©2014. ComponentOne, a division of GrapeCity. All rights reserved.</div><!--DXMETADATA end --> </body> </html>