Come in from cold ...
By Tim Dexter-Oracle on Aug 27, 2007
I blogged a while back on how to move EBS BIP related objects and meta data from development to production ... the BIP standalone folks were left out in the proverbial cold. Well now we can let you back in.
Come in, come in ... get warm and cozy by the fire. This post needs to have been written back in January when we had 4 feet of snow outside our house ... or maybe at the end of April when amazingly we had more snow. Anyway, its the tail end of August and at a get together yesterday in 100 degrees of heat there was a discussion on who had the best snow blower. Never mind, best cars, fastest motorcycles here, we discuss the important stuff of life here in the Front Range - how much snow can you shift and how comfortable can you be while doing it? I lost, of course, someone had a sit on blower with heated hand grips and a cup holder. I jest but you know what I mean, big boys toys and all that.
Getting back to moving report objects in standalone - there is of course a simple way to move all of your reports in one hit. Find the Reports Repository location where all your reports, security, etc information is held.
Zip it up, move it to the production environment, unpack it and point the server to the new location ... simple. It's a blunt instrument but it works.
What if you wanted to move a single report? You can do that too ... a somewhat hidden feature but if you navigate to the folder in which the report you interested in lives and click on the report icon.
You'll see the menu on the right hand side updates with an option to dowenload the report. Clicking will not only grab the report but all of the templates, translations, sample data, etc available for that report in the form of a zip file.
You can then off course log into the production environment and load the zip file via the Upload Report link in the menu and your report will load. Just remember that you might possibly need to update the datasource name on the new server.
Now, do you want marshmallows in that cocoa?