tag:blogger.com,1999:blog-4019598559914347729.post8689779451151199103..comments2024-02-09T04:19:32.395-06:00Comments on Tim Tow's Hyperion Blog: Smart View 11.1.2.1.102 Performance TipTim Towhttp://www.blogger.com/profile/01455458983202814616noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4019598559914347729.post-3847625196740830302012-07-04T12:26:18.211-05:002012-07-04T12:26:18.211-05:00This would probably be a better question for the i...This would probably be a better question for the infrastructure experts. <br /><br />We have run Dodeca using https through a proxy server and then https to our server and not seen a noticeable degradation in performance. My guess is that it is not a Smart View issue but rather a networking issue.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-46268955439691339242012-07-03T16:41:48.919-05:002012-07-03T16:41:48.919-05:00Tim, had a SV perf issue and wanted to pick your b...Tim, had a SV perf issue and wanted to pick your brain.<br /><br />Our Production environment is the following:<br />We have One Web Server with (Oracle HTTP Server), two application servers with the following products: Foundation, Reporting and Analysis (Financial Reporting) HFM Server and FDQM Server; each one of the Application Servers have all this products and both are working as HFM Cluster Nodes, Weblogic Servers of clusters and FDQM Load balance servers. Finally we have one RDBMS Server With SQLServer 2008 R2. All four servers are Windows 2008 R2 Standard Edition.<br /><br />We made this installation and weeks later The company tell us that the Product must be in a Full SSL Scenario (Stage) we reconfigure all the environment on a Secure mode. All four Servers and the clients comunicate only with https protocol and everything have all the respective Certificates.<br /><br />When users use Excel to connect to Smartview they experimented a very slow connection:<br />They use the following URL https://External_OHS_Virtualhost/workspace/SmartView, the System asks the user to logon with validate credencials and this process works with normal time delay, after that SmartView present the users the possible browse products, when we choose "Hyperion@ Financial Mangement, Fusion Edition" (HFMOffice Provider), Smartview takes about 3 or more minutes to chose as the registered HFM Machines/cluster, then we chose the HFM Application and in the last Connection procces Smartview takes again 3 or more minutes.<br /><br />When users browse https://External_OHS_Virtualhost/workspace/, they can navigate on workspace without issues<br /><br />The Smartview Log Does not chose any error<br />Users use Smartview without any delay on our test environment, which it is only one server with http protocols available only<br /><br />We attach a word file with the pics of the process and we resalt the exacts steps of long delays, also we attach the registry of the shared ServicesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-30539553742967023352012-03-14T14:43:41.862-05:002012-03-14T14:43:41.862-05:00I have contacted Oracle and have an SR open with t...I have contacted Oracle and have an SR open with them. So far no progress has been made, but I will send an update once we figure out what is causing the issue.<br /><br />Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-50621908511815021412012-03-08T21:50:32.599-06:002012-03-08T21:50:32.599-06:00I doesn't make sense that Smart View performan...I doesn't make sense that Smart View performance would get worse with the patch. Have you contacted Oracle support? I will think about the issue; if you find the reason for this performance issue, I would love to hear about it.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-84508781897368526472012-03-08T17:12:23.247-06:002012-03-08T17:12:23.247-06:00Thanks for the information Tim. To clarify, the p...Thanks for the information Tim. To clarify, the performance issue wasn't a problem before the .102 patch. SV 11.1.2.1 worked great, no performance issues. Once we installed .102 patch we started seeing significant performance issues when drilling in on Sparse dimensions. The number of members in the dimension doesn't seem to make a difference. Drilling in on any sparse dimensions is very slow. Thanks again for your input.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-18447152338512828362012-03-08T16:03:06.500-06:002012-03-08T16:03:06.500-06:00Thank you for the information Tim! Much appreciat...Thank you for the information Tim! Much appreciated.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-71273496048410125002012-03-08T12:26:43.139-06:002012-03-08T12:26:43.139-06:00Also, I would make sure the client is a fairly pow...Also, I would make sure the client is a fairly powerful machine as well.. Compared to the classic add-in, which brought the data to the client in a highly optimized binary artifact, Smart View brings the data down to the client as xml and thus has to parse the xml and process the string values returned by the xml.<br /><br />I have heard through the grapevine that the Smart View team is working on performance, but my expectation is that it will not be as fast as the classic add-in on a comparable machine. That being said, the new functionality makes Smart View more capable than the classic add-in, so the benefits may outweigh the costs.<br /><br />Finally, if you need really fast operations into a spreadsheet against Essbase, perhaps you should give Dodeca a try.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-24673036475752918762012-03-08T12:21:43.581-06:002012-03-08T12:21:43.581-06:00My expectation is that it will not be as fast as t...My expectation is that it will not be as fast as the Excel add-in due to a difference in how the data is actually returned to the client. That being said, I would make sure your APS server is installed on a fast of a server as possible and that ample amounts of memory are allocated to WebLogic on that server (to prevent the server from thrashing memory).<br /><br />In my testing, my entire stack is running on my laptop, but the laptop is a quad core Dell with 8 Gb of RAM and an SSD drive.<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-36388486668027263602012-03-08T11:41:38.677-06:002012-03-08T11:41:38.677-06:00I have been experiencing performance issues with t...I have been experiencing performance issues with the .102 patch. I applied the patch to APS, Essbase, and Smartview. Drill bottom on a large dimension (10,000 members) is taking quite a bit longer than it does through the add-in. I have tried your suggestions above and I am not seeing a significant improvement. Do you have any other suggestions?<br /><br />Thanks, RBAnonymousnoreply@blogger.com