tag:blogger.com,1999:blog-7650953985627040991.post3490661302662163268..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Stupid Programming Tricks #13 -- Exporting in EAS so you can importCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-7650953985627040991.post-67761350460761474072016-06-23T16:12:40.838-04:002016-06-23T16:12:40.838-04:00You are my hero! Just used this!
Looking forward t...You are my hero! Just used this!<br />Looking forward to see you again at KSCOPE this year!<br /><br />Best,<br />MeiAnonymoushttps://www.blogger.com/profile/08286891909483467555noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-18318215655115510902016-06-23T16:11:49.611-04:002016-06-23T16:11:49.611-04:00You are my hero! Just used this trick.
Thank you a...You are my hero! Just used this trick.<br />Thank you and looking forward to seeing you again at KSCOPE!<br /><br />Best,Anonymoushttps://www.blogger.com/profile/08286891909483467555noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-64553170533623611402014-03-24T16:25:53.677-04:002014-03-24T16:25:53.677-04:00Hello,
there is extension to it... sometimes EAS c...Hello,<br />there is extension to it... sometimes EAS can see different essbase servers, while they are on different domains and data can not travel between them. <br />Export the file and give it the extension .rep. Then you can copy a rather large report file (aka. data export) from one Essbase server to the other via EAS.<br />Regards,<br />Philip H.Philip Hulseboschnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-15314478115849962862012-11-23T07:48:36.020-05:002012-11-23T07:48:36.020-05:00Nat,
Take a look in the application log. Here...Nat,<br /><br />Take a look in the application log. Here's an example of Sample.Basic being exported:<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample///8196/Info(1013210)<br />User [hypadmin@Native Directory] set active on database [Basic]<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample/Basic/hypadmin@Native Directory/7840/Info(1013091)<br />Received Command [ParExport] from user [hypadmin@Native Directory]<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample/Basic/hypadmin@Native Directory/7840/Info(1019020)<br />Writing Free Space Information For Database [Basic]<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample/Basic/hypadmin@Native Directory/7840/Info(1005029)<br />Parallel export enabled: Number of export threads [1]<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample/Basic/hypadmin@Native Directory/8276/Info(1005031)<br />Parallel export completed for this export thread. Blocks Exported: [1]. Elapsed time: [0.02].<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample/Basic/hypadmin@Native Directory/7840/Info(1005002)<br />Ascii Backup Completed. Total blocks: [1]. Elapsed time: [0.022].<br /><br />[Fri Nov 23 07:44:00 2012]Local/Sample/Basic/hypadmin@Native Directory/7840/Info(1013270)<br />Database export completed ['Sample'.'Basic']<br /><br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-51010321800269334952012-11-22T15:01:32.374-05:002012-11-22T15:01:32.374-05:00excellent! Could i do a query here about Export?
H...excellent! Could i do a query here about Export?<br />Here goes: where could i find a log indicating if the export was successfully or not?<br /><br />thank you!Natnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-5738804052792293332012-11-07T21:46:03.059-05:002012-11-07T21:46:03.059-05:00Paul,
I am always happy when my ignorance makes o...Paul,<br /><br />I am always happy when my ignorance makes other people look good by comparison.<br /><br />:)<br /><br />Regards,<br /><br />CameronCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-33111487554765438302012-11-07T17:41:30.270-05:002012-11-07T17:41:30.270-05:00Hi,
OMG Sometimes I feel like I know nothing when...Hi,<br /><br />OMG Sometimes I feel like I know nothing when I read around the blogs etc. However, you have gave me great encouragement that maybe I do know "stuff"!!<br /><br />I've always done it this way, and to be honest I didn't even know if you didn't where the files actually went.....so I guess I learned they go to the EAS sevrer somewhere..... lol<br /><br />THANKS for making me feel just the little bit smarter.....<br /><br />Oh - I bought your book, can I have a refund? lolDiabloPaulonoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-24830691718251212182012-11-05T17:51:20.934-05:002012-11-05T17:51:20.934-05:00Another useful trick related to this I have used i...Another useful trick related to this I have used in the past is for transferring data between apps. Simply put the app/dbname of the destination in the export path. For example you could export from Sample Basic to Sampeast\East\transferdate.txt and then load the data directly into Sampeast:East. For those working on UNIX servers keep in mind the UNIX is case sensitive and that since this is a filesystem write, it will matter.<br /><br />BrianBriannoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-38647107498841181272012-10-30T10:32:25.468-04:002012-10-30T10:32:25.468-04:00Hello Cameron,
Forget my previous comment, my lac...Hello Cameron,<br /><br />Forget my previous comment, my lack of knowledge of Unix...<br /><br />if instead of putting the backlash you put / it works perfectly.<br /><br />Thanks for the trick.<br />Best regardstiscohttps://www.blogger.com/profile/04395962047286018148noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-45505781340748499222012-10-30T10:09:00.286-04:002012-10-30T10:09:00.286-04:00Hello Cameron,
Good post as always. I tested it o...Hello Cameron,<br /><br />Good post as always. I tested it on my Essbase server 11.1.1.3 on windows and it works as you say but when the essbase server is on unix the text file gets saved as Sample\Basic\test.txt or Sample\test.txt or whatever path you indicate...<br /><br />Would you know why this happens?<br /><br />Best regardstiscohttps://www.blogger.com/profile/04395962047286018148noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-65676568402273949342012-10-25T03:22:38.091-04:002012-10-25T03:22:38.091-04:00Brilliant! I was so used to picking it off the ser...Brilliant! I was so used to picking it off the server 15+yrs that I never thought of that when I was blocked the occasional time. How the heck did I miss that one? :) More stupid tricks please!Anonymousnoreply@blogger.com