tag:blogger.com,1999:blog-7650953985627040991.post8986190586253912774..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Limitations in Hybrid BSO EssbaseCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7650953985627040991.post-53291890597877198462017-11-16T12:04:53.400-05:002017-11-16T12:04:53.400-05:00I am facing one issue in hybrid cube. In account d...I am facing one issue in hybrid cube. In account dimension, the proper value is not aggregating at the parent member level though the property has been set to the "dynamic calc". It's aggregating the wrong value. What should be the cause of this issue? <br />Can anybody please respond? Thanks.<br /><br />Best Regards,<br />DipankarAnonymoushttps://www.blogger.com/profile/08964188874368309146noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-66053475834464318592017-03-01T14:21:03.754-05:002017-03-01T14:21:03.754-05:00Chava,
Member parents should not have these funct...Chava,<br /><br />Member parents should not have these functions.<br /><br />In fact, if you have level zero members with these functions make sure that upper level accounts (or whatever) don't pull those level 0 members through a unary operator because that will result in the Hybrid query processor failing. <br /><br />If you *do* need that, set the formulas to stored, run a CALC DIM (Account), and then go on your merry way. Fwiw, I haven't written a CALC DIM (Account) in literally years but for the time being at least, it's still needed.<br /><br />Regards,<br /><br />CameronCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-85672233603127488252016-05-12T04:20:11.603-04:002016-05-12T04:20:11.603-04:00Hi I have one question on limits to the functions
...Hi I have one question on limits to the functions<br />Does it mean that member formula for parent members should not have these functions or does it mean in hierarchy no member either level 0 (Store/Dynamic) or parents should not have these restricted members in the formulaChavahttps://www.blogger.com/profile/09737579445517175087noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-46615235289195708832016-03-07T15:16:47.911-05:002016-03-07T15:16:47.911-05:00Hi Cameron,
This is a little late to the party, bu...Hi Cameron,<br />This is a little late to the party, but you mentioned that Cross-dim operators do not work with essbase hybrid. Is this true when all crossdims are at level 0? <br /><br />Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-62607173465293244432014-12-18T07:55:06.206-05:002014-12-18T07:55:06.206-05:00Hi Cameron. I'll send you an email with the de...Hi Cameron. I'll send you an email with the details. I think there may be a bug in how Hybrid BSO deals with dataexport commands (at Lev0). My export file(s) do not contain 100% of the data they should. The key is that the results differ each time I run the exports. I've only begun to test this functionality, so I'll re-post if my code is wrong.Billhttps://www.blogger.com/profile/17570690057828826521noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-31347606338951101862014-04-30T21:37:19.622-04:002014-04-30T21:37:19.622-04:00Amarnath,
I like to think of Hybrid as a way for ...Amarnath,<br /><br />I like to think of Hybrid as a way for BSO databases to have the advantages of ASO databases. Choice is good, right?<br /><br />Re your first point, I direct you to the ReadMe's statement:<br />"You are using a transparent partition between an empty aggregate storage target and a block storage source. If the formulas on the aggregate storage target are simple and translatable to block storage formula language, you can achieve fast results on block storage using hybrid aggregation." Could it be that Hybrid is as fast as ASO? Could be.<br /><br />The second: yes, BSO is still going to be limited (we think) to the 2^104 stored member count of sparse dimensions. OTOH, you wouldn't really have that many stored sparse members. So the database really could be quite big, although I do agree that ASO will trump Hybrid unless Oracle changed something at level of the kernel.<br /><br />So much of Hybrid actually is ASO, it is a bit difficult to know where one stops and the other starts so these are just guesses on my part.<br /><br />Lastly, the purpose of Hybrid is to give choice. At least in my opinion.<br /><br />Regards,<br /><br />Cameron Lackpour<br /><br />P.S. Please don't think because I disagree with your conclusions that I don't value your input. Who knows if I am even a little bit right.Cameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-60450883590191098802014-04-30T17:16:58.777-04:002014-04-30T17:16:58.777-04:00I would still bet on ASO rather than going out to ...I would still bet on ASO rather than going out to the route of Hybrid. It's good to see a mix of both.<br /><br />1) Rack & Stack<br />When we say Hybrid (Aggregation power of ASO), if we just have a rack & Stack BSO and do some basic operations like Retrieve, ZoomIn, ZoomOut, Retrieve at all levels and I think ASO would win in this case<br /><br />2) Dimensions<br />ASO supports more number of dimensions and members and BSO is still limited in this case including hybrid I guess.<br /><br />this would be the first move but I still don't get the actual purpose of hybridamarnathhttps://www.blogger.com/profile/12749240552285136096noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-19883770060946965762014-04-29T11:29:03.655-04:002014-04-29T11:29:03.655-04:00Cameron, thanks again for this blog and all the in...Cameron, thanks again for this blog and all the information provided. <br />You were for days (weeks) into the subject, but what I missed is a short description of what the hybrid in BSO is. <br />I started reading with Hybrid Analysis kind of approach, where we get the lowest levels from an RDBS into Essbase.<br />Looking in the Readme, I saw it is half BSO half ASO. This also explains a couple of limitations.<br /><br />Does it support other aggregation than + in the outline?<br /><br />Regards,<br />Philip<br />Philip Hulsboschnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-72623099992153335392014-04-29T08:44:43.192-04:002014-04-29T08:44:43.192-04:00Thanks a lot for the wonderful information. yeah a...Thanks a lot for the wonderful information. yeah as you said, this is just a starting and way to go. We can not achieve everything in the first release, but i feel this is one of the great move by Oracle. Once again thanks a lot for providing such a wonderful informationDinesh Kumar Ammayappannoreply@blogger.com