tag:blogger.com,1999:blog-7650953985627040991.post3457221931909854876..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Stupid Programming Tricks #15 -- @SHARE the pain with FIXCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-7650953985627040991.post-44003550859834774152018-03-16T14:23:05.267-04:002018-03-16T14:23:05.267-04:00Since I had the shared member in multiple alt hier...Since I had the shared member in multiple alt hierarchies I used @LIST("Member_Name", @SHARE("Member_Name")) in the @REMOVE and it worked! Thanks Cameron!Adeebanoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-30012556212767429952014-07-10T21:49:04.605-04:002014-07-10T21:49:04.605-04:00This was very fascinating, Cameron. I tried using...This was very fascinating, Cameron. I tried using EXCLUDE/ENDEXCLUDE today with a DATAEXPORT to remove Shares (to remove the pesky derived cells "errors" in ASO loading) and did not get the results I was expecting. Only around 1.8% of the data came through. Alas, it was the end of the day and I will return to it tomorrow. Sarahhttps://www.blogger.com/profile/00957247687874800338noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-84178387151815398332014-04-03T09:54:38.153-04:002014-04-03T09:54:38.153-04:00Hi Cameron!
Thanks for your awesome blog! I ran i...Hi Cameron!<br />Thanks for your awesome blog! I ran into this nasty issue this morning in 11.1.2.1. Neither @Remove nor EXCLUDE was working for me despite specifically listing a single ahared member that I wanted removed from a FIX. I saw this post and I added the @SHARE to my @Remove and it finally worked!<br />Looking forward to seeing you at Kscope14! :) Robin BanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-38474780956513461062014-04-01T05:58:13.859-04:002014-04-01T05:58:13.859-04:00Ed,
AFAIK, this functionality has not been change...Ed,<br /><br />AFAIK, this functionality has not been changed.<br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-40937411358268605392014-03-31T23:59:27.155-04:002014-03-31T23:59:27.155-04:00Hi Cameron,
Do you know if this issue has been fi...Hi Cameron,<br /><br />Do you know if this issue has been fixed by Oracle yet. I searched on Oracle support but did not find any reference to this issue.<br /><br />Thanks,<br />EdAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-48237674845548383132013-05-21T22:39:04.864-04:002013-05-21T22:39:04.864-04:00Hi Cameron,
I had noticed similar bugs and I just...Hi Cameron,<br /><br />I had noticed similar bugs and I just saw this blog entry, which means I was not insane.<br /><br />Something that I would like to add is that this illogical behavior also happens when using Shared members and 'AND' instead of remove.<br />For example if you have an alternate hierarchy and want to select all the shared members tagged with a specific UDA it will not work properly. And you cannot use EXCLUDE in this case. <br />I have not had the occasion to try @INTERSECT, the new function in 11.1.2.3 but hopefully replacing 'AND' by @INTERSECT will work. <br /><br />Thanks,<br />JulienAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-81954717583357437592012-11-25T11:16:07.008-05:002012-11-25T11:16:07.008-05:00Hello and thanks Cameron,
In the good old days of ...Hello and thanks Cameron,<br />In the good old days of hyperion at a time I has been told by a technical stuff member that there maybe a lot of "minor" that will have to be fixed it will be fixed by developement. However if there are bugs regarding computing inside of essbase ALL alarm bell are ringing at hyperion developement.<br />Why ? Oh no, nobody working with (and relying in) essbase should ever ask these question.<br />Hm - I ask myself , is Oracle seeing this the same rigourous ethos.<br />What would happen when two differently formulated (but regarding the outcome technical identical) SQL statements in Oracle DB would deliver different results.<br />It's quite clear this would be a desaster.<br />I really hope Oracle is seeing a clear parallel here... and that is all that I can say.<br />AndreAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-33192245431390132222012-11-23T07:19:45.584-05:002012-11-23T07:19:45.584-05:00Santiago,
The point behind case #1 was to show th...Santiago,<br /><br />The point behind case #1 was to show that I could remove a non-shared member from the scope of the FIX.<br /><br />When I try to do that same bit of code, but with a shared member, the code does not work. But it should, right? 200-20 should be #Missing but instead it is 100. That's the bug.<br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-84403953966055807222012-11-22T09:55:50.131-05:002012-11-22T09:55:50.131-05:00Cameron, I think you have an error in Case #1
You...Cameron, I think you have an error in Case #1<br /><br />You are @REMOVEing member '200-10' but your validation worksheet (and the outline, for that matter) don't have that member. The correct child of "Diet" would be "200-20", not "200-10" so.... you're removing the wrong member !!<br /><br />in the remaining cases, the result is consistent, remove the prototype and all the shared members get also pulled outAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-19395322241781377682012-11-20T17:50:38.001-05:002012-11-20T17:50:38.001-05:00Dear Anon,
You can use EXCLUDE...ENDEXCLUDE in a ...Dear Anon,<br /><br />You can use EXCLUDE...ENDEXCLUDE in a Calc Mgr business rule, at least on 11.1.2.1.<br /><br />I recall back in the 9.3.1 days that EXCLUDE didn't work in HBR (I think I was burnt by this), but that was four odd years ago.<br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-55905828549620605472012-11-20T14:32:30.911-05:002012-11-20T14:32:30.911-05:00Can you use Exclude in a Business Rule? I seem to...Can you use Exclude in a Business Rule? I seem to remember it only works in calc scripts.Anonymousnoreply@blogger.com