tag:blogger.com,1999:blog-7650953985627040991.comments2024-02-14T05:30:55.538-05:00Cameron's Blog For Essbase HackersCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger823125tag: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-57040350422829073882018-02-28T18:21:30.380-05:002018-02-28T18:21:30.380-05:00Hi,
I am using $? to capture MAXL error in shell....Hi,<br /><br />I am using $? to capture MAXL error in shell. But $? returns value 'zero' even though it fails at the first step(Login $1 $2 on $3;)<br /><br />Please suggest.<br /><br />login $1 $2 on $3;<br />IFERROR 'errLogin';<br />spool stderr off;<br />EXIT 0<br /><br />define label 'errLogin';<br />echo "*******";<br />logout;Ronaldhttps://www.blogger.com/profile/12291144717546175427noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-32671597767422281302018-02-28T18:17:47.526-05:002018-02-28T18:17:47.526-05:00Hi,
I am using $? to capture the return value of ...Hi,<br /><br />I am using $? to capture the return value of MAXL.<br />But even though my MAXL is failing in the fist step(login $1 $2 on $3;) , I am getting $?=0.<br /><br />Please suggest.<br /><br />My code<br />--------<br /><br />login $1 $2 on $3;<br />IFERROR 'errLogin';<br />spool stderr off;<br />EXIT 0<br /><br />define label 'errLogin';<br />echo "*******";<br />logout;Ronaldhttps://www.blogger.com/profile/12291144717546175427noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-27941675788043809012017-12-14T15:46:43.994-05:002017-12-14T15:46:43.994-05:00Wish you well Cameron, I too am starting my transi...Wish you well Cameron, I too am starting my transition to a new and probably more exciting career after 20+ yrs in the Hyperion world of consulting.Anonymoushttps://www.blogger.com/profile/13340561530027778636noreply@blogger.comtag: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-31224231698505890032017-10-13T12:36:26.526-04:002017-10-13T12:36:26.526-04:00I think I may have to change careers also because ...I think I may have to change careers also because I'm not really sure how I'm supposed to do my job without you or your blog. <br /><br />In all seriousness, best of luck. You're going to knock 'em dead.Unknownhttps://www.blogger.com/profile/06282514002315444412noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-47671626055428911662017-10-10T10:56:39.727-04:002017-10-10T10:56:39.727-04:00Thanks for your many years of invaluable contribut...Thanks for your many years of invaluable contributions to the Oracle EPM Community. Wishing you the best over at OneStream.Erichttps://www.blogger.com/profile/10748271236048284415noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-78074939288351503312017-10-04T15:43:28.112-04:002017-10-04T15:43:28.112-04:00Best of luck with the new gig. You'll, no doub...Best of luck with the new gig. You'll, no doubt, crush it.TimFhttps://www.blogger.com/profile/05962713873726067372noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-12610029789827288582017-10-04T14:23:35.819-04:002017-10-04T14:23:35.819-04:00Best Wishes Cameron. Hope that our paths cross aga...Best Wishes Cameron. Hope that our paths cross again sometime in the near future<br /><br />Kannan Krishnan.Kannan Krishnanhttps://www.blogger.com/profile/10280984214724840425noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-32663655711597254122017-10-03T20:41:05.641-04:002017-10-03T20:41:05.641-04:00CK Dexter Haven? How's Philly? Okay, you'...CK Dexter Haven? How's Philly? Okay, you've heard that before, haven't you?<br /><br /><br />I'm not a fan of MAD. How about this version: <br />https://www.youtube.com/watch?v=zMUuuaUGff0<br /><br />All kidding aside, thank you for your kind words.<br /><br />CameronCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-46531436188667317082017-10-03T18:56:04.595-04:002017-10-03T18:56:04.595-04:00Good Luck Cameron
https://www.youtube.com/watch?v...Good Luck Cameron<br /><br />https://www.youtube.com/watch?v=mEtldt-FI8YCK_Dexterhttps://www.blogger.com/profile/16584112893778013417noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-1047122289084040062017-10-03T09:19:11.324-04:002017-10-03T09:19:11.324-04:00Good Luck Cameron, it is hard to leave a technolo...Good Luck Cameron, it is hard to leave a technology you have work with for decades, I did it a few years ago. I wish you well. It is exciting and scary at the same time. You are in good company with OneStream!<br /><br />Judith Wassermannoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-12378365111545366372017-10-03T08:20:56.053-04:002017-10-03T08:20:56.053-04:00All the best Cameron for your new journey
We all m...All the best Cameron for your new journey<br />We all miss you and your blog posts. All your blog posts can become one whole book :)<br /><br />We never know, we may cross paths amarnathhttps://www.blogger.com/profile/12749240552285136096noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-85271198972466803572017-10-02T20:26:27.071-04:002017-10-02T20:26:27.071-04:00Congratulations on your new adventure Cameron.
We...Congratulations on your new adventure Cameron.<br /><br />We folks that are stuck in the Oracle EPM world are going to miss your blog posts and conference presentations but I'm sure all of us agree that we're happy to see you move on to bigger and better things.<br /><br />Good luck - and I hope to bump into you agains soon.Jackhttps://www.blogger.com/profile/00907243397984859926noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-77603430539737484812017-10-02T17:36:38.188-04:002017-10-02T17:36:38.188-04:00All the best for the next adventure Cameron! I kno...All the best for the next adventure Cameron! I know we only met the one time and I have bothered you far too many times than would probably be considered polite but your generosity, kindness and willingness to help guide, teach and share your knowledge with a crazy chick from <br /> (a sometimes backwards) South Africa will never be forgotten.<br />I hope to stay in touch and follow the next chapter with interest. To infinity and beyond I would say... :-) KerryAnonymoushttps://www.blogger.com/profile/13676859005169599985noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-62061336504421921772017-10-02T17:34:58.079-04:002017-10-02T17:34:58.079-04:00All the best for the next adventure Cameron! I kno...All the best for the next adventure Cameron! I know we only met the one time and I have bothered you far too many times than would probably be considered polite but your generosity, kindness and willingness to help guide, teach and share your knowledge with a crazy chick from <br /> (a sometimes backwards) South Africa will never be forgotten.<br />I hope to stay in touch and follow the next chapter with interest. To infinity and beyond I would say... :-) KerryAnonymoushttps://www.blogger.com/profile/13676859005169599985noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-4440920229424655322017-10-02T17:10:38.963-04:002017-10-02T17:10:38.963-04:00WIsh you the best!WIsh you the best!Amitnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-44387449994834909652017-10-02T16:28:55.015-04:002017-10-02T16:28:55.015-04:00You have been a great teacher. All the very best i...You have been a great teacher. All the very best in your endeavor.Sandeepnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-57681226213079093252017-10-02T14:27:14.856-04:002017-10-02T14:27:14.856-04:00Good luck, Cameron. Your blog has been an excelle...Good luck, Cameron. Your blog has been an excellent source of ideas. Thank you.<br /><br />I don't know you but, given the generosity evident in these posts, I'm sure you will do well in your next endeavor.<br /><br />That said, you'll be back. It's Essbase that decides who gets out.Javiernoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-68108628134225380812017-10-02T11:54:35.682-04:002017-10-02T11:54:35.682-04:00Agreed. The renaming functionality is possible wit...Agreed. The renaming functionality is possible within the application. Why they don't expose it to "EPM Automate" I don't know. Maybe in time?!<br /><br />Nice post though. I'll be considering this.Dermott Beverleyhttps://www.blogger.com/profile/14429310189272002407noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-11788095010097533642017-09-28T05:23:02.208-04:002017-09-28T05:23:02.208-04:00Hi Cameron, Even I'm facing the same issue as ...Hi Cameron, Even I'm facing the same issue as Cord.How to overcome with this type of error.<br />Is there any workarounds for this.<br /><br />Cord, if you have found any way to overcome this, please drop in your solutions.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-33789495744045363282017-09-03T18:27:05.633-04:002017-09-03T18:27:05.633-04:00I cannot for the life of me get the Native Essbase...I cannot for the life of me get the Native Essbase format to work! My single-row file looks like this (tab-delimited file, but have also tried comma- and space-delimited):<br /><br />“KRO” “Actual” “Final” “D100” “W1” “Day7” “FY16” “S1101” “P5” “A91003” 0.00<br /><br />And I get this error:<br /><br />EssImport Member Error – Member “��”” not found in Essbase database. Error code: 3303 Record: ��”<br /><br />All of the above are valid members. Any thoughts?www.sagacandycrushapkgame.com/http://sagacandycrushapkgame.com/candy-crush-apk-free-download/noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-32246620794623877592017-08-29T02:22:53.972-04:002017-08-29T02:22:53.972-04:00All Readers, have a look at this interview. As Ess...All Readers, have a look at this interview. As Essbase Veteran (can I say this with almost 20 years working with Essbase?) I enjoyed it and got different insights on some topics! Well done.<br />Regards,<br />PhilipPhilip Hulseboschhttp://www.trexco.nlnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-48581524236210632792017-07-28T12:39:53.068-04:002017-07-28T12:39:53.068-04:00Hi,
We are trying Replicated partition from BSO c...Hi,<br /><br />We are trying Replicated partition from BSO cube to ASO. We want to replicate all the members form a dimension except one parent and its descendants. using except command below gives error.<br />Command in partition: Except({Descendants([EC],[ECDIM].Levels(0))},{Descendants([EC.1],[ECDIM].Levels(0))}),"AEntity"' sourcearea1<br /><br />Error : ERROR - 1023040 - msg from remote site [[Thu Jul 27 15:49:45 2017]Servername/ASOapp/ASOcube/Custadmin/Error(1023040) msg from remote site [[Thu Jul 27 15:49:45 2017]Servername/BSOApp/BSOcube/admin/Error(1023007) Parse error in partition definition line [0]]].<br /><br />Export data from BSO and import to ASO is taking long time, I want to go with partition option.vhttps://www.blogger.com/profile/13578952786987143149noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-19562347823538911572017-07-07T16:01:39.724-04:002017-07-07T16:01:39.724-04:00Sounds great, wish I were there. Sounds great, wish I were there. GlennShttps://www.blogger.com/profile/12820725959526528201noreply@blogger.com