tag:blogger.com,1999:blog-7650953985627040991.post5365855427343238314..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Stupid Programming Trick No. 25 part C -- Hybrid allocations purely in BSOCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7650953985627040991.post-91488399816595045582015-12-07T02:52:53.071-05:002015-12-07T02:52:53.071-05:00Hey,
Because I actually was interested, I did so...Hey, <br /><br />Because I actually was interested, I did some performance testing. <br /><br />Hybrid is absolutely amazing at these kinds of calculations. Limited upper level blocks means that there is limited 'noise' to work through. <br /><br />The worst case I saw was the aggregation code being around 3.3-3.5x slower than the associated MDX Export and load. Given that the time difference was 2.7 secs tto 9.5 secs, that's not too terrible.<br /><br />The test case was summing up a distribution from Wrkforce to GL. 5000 employees across 150 entities - with the code aggregating the distribution across 85k entity members. <br /><br />So, ridiculously quick in all methods. <br /><br />Cheers<br />PPetehttps://www.blogger.com/profile/06439105832806165572noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-67403375088382490382015-09-24T12:21:43.091-04:002015-09-24T12:21:43.091-04:00Glenn,
Follower? Really? This is a blog called ...Glenn,<br /><br />Follower? Really? This is a blog called "Cameron's blog for Essbase hackers".<br /><br />There can't be too much left brain thinking here, can there?<br /><br />Now if ask me if it looks pretty, nope, I still don't think it does.<br /><br />:)<br /><br />But yes, MMIC, I do follow you to the best of my somewhat bad abilities. Really, I do.<br /><br />I don't know what Edward's sum approach entails.<br /><br />CameronCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-19078492931269314192015-09-24T10:36:20.807-04:002015-09-24T10:36:20.807-04:00Cameron,
I am glad you have finally seen the ligh...Cameron, <br />I am glad you have finally seen the light and elegance of my solution. While you consider left side equations horrendous, it is only because you are left brained. Only left handed people are in their right mind. I actually think it has more to do with you being a rule follower. You were told early on that cross dims on the left hand side of equations were bad, you assimilated that and now use it as a mantra. I on the other hand embrace simplistic out of the box methods to accomplish what others create elaborate solutions and struggle with them. For comparison, you could try Edwards approach to use a single sum statement instead of my loop. It may be faster but I doubt it GlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-71079169070068748522015-09-21T12:12:30.181-04:002015-09-21T12:12:30.181-04:00I commend you, sir, on your fondness for easy list...I commend you, sir, on your fondness for easy listening, and your taste in comedy. As a rapid SCTV fan I must mention that the C Man was also the target of another SCTV bit, this time played by the brilliant Eugene Levy: https://youtu.be/zj5A7W-0zPY<br /><br />Still Como was no Sinatra...<br /> Bob Rhubarthttp://bit.ly/archbeatpodcastnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-41753390552391198432015-09-21T12:06:02.266-04:002015-09-21T12:06:02.266-04:00As a rabid SCTV fan I must correct an error in you...As a rabid SCTV fan I must correct an error in your post. That's Eugene Levy portraying the prostrate Perry in the comedy clip. Bob Rhubartnoreply@blogger.com