Monday, September 24, 2012

Oracle Open World Essbase/EPM meetup


Introduction

I know many (some?  one or two?) of you are coming to OOW, or will be in the Bay Area vicinity next week.

We (Tim Tow and I) are hosting an Essbase/EPM meetup at Specchio-Ristorante at 8 pm, Tuesday 2 October.

What’s it all about, Alfie?

What's it going to be about?  Agenda tbd, but I hope you enjoy improvisational situations because that's exactly what it's going to be.

What I would expect:
  • Networking
  • Knowledge sharing
  • Completely legal drugs in liquid form at the cash bar.  No, not antipsychotics in liquid suspension, but I do believe Specchio has a liquor license.  OTOH, if it's a really trying conference, I may be drinking coffee.  Or thinking maybe Risperdal might be an option.  It might be that good of a conference.  We shall see.   Once upon a time, I worked for the company that invented that drug.  No, I am not a pharmacologist.  I did however replace their IRI Express (soon to become Oracle OLAP Server) instance with Essbase.  :)
  • Hanging out with like-minded people.  Which I suppose is pretty darn close to Networking, so I think I am done with the listing of benefits.

There's only room for 50, and Tim and I have both rsvp'd, so that means 48 slots are open as of this writing.

Here’s the gen

Here's the meetup invitation:
http://www.meetup.com/Oracle-Open-World-Essbase-EPM-meetup/events/83903872/

And the restaurant's web site:
http://www.ristorantespecchio.com/about/

I hope you can make it -- it should be a lot of fun.

Good News About Metro-North



So often this column is a screed of complaints about Metro-North.  This time, the good news, because I really think in the last year we have turned the corner in everyone’s goals and hopes for making Metro-North service better.
MORE SEATS:       The latest monthly reports reviewed by the CT Rail Commuter Council show that 99% of all trains have enough cars.  That’s a major improvement compared to a few years ago when “consist compliance” was in the 85% range (i.e. 15% of all trains didn’t have enough cars for the passenger load they usually carried).   Why the improvement?  The new M8 cars.
NEW CARS:           The new M8 cars continue to arrive at the rate of about ten new cars a month, an aggressive delivery schedule few thought Kawasaki could ever achieve.  On average, each car is going 139,000 miles before it has a problem.  That’s an MDBF (mean distance between failure) twice as good as the M4 and M6 cars.  So far 128 new M8’s are in service, meaning you have about a 30% chance of riding in a new-car train at rush hour and a 50% chance on weekends.
RIDERSHIP:           Despite the economy, ridership continues to climb about 5% annually.  The biggest increase?  Weekend day trippers.
ON TIME:               This has always been a justifiable point of pride with Metro-North, as 97% of the trains arrive “on time” (within 6 minutes of the timetable).
NEW SIGNALS:      The signalization system being installed on the Danbury branch continues apace with one of the first sections to be activated within a month.  When it’s completed this will mean more trains, in both directions, on this one-track railroad.
NEW SERVICE:      With the new October timetable there will be added service on weekends… eight more trains on Saturdays and 20 more trains on Sundays.
MORE STOPS:       Thanks to years of persuasion by The CT Rail Commuter Council to the CDOT, that new timetable will also eliminate the old “skip stops” at less used stations like Rowayton, East Norwalk, Greens Farms and Southport.  Now, instead of trains every two hours, those stations… in fact, all stations… will have train service every hour.  The brief added time for these stops will hardly be noticed but will offer vastly improved service to hundreds of daily riders.
QUIET CARS:         It took about a decade of lobbying by the CT Rail Commuter Council, but since Metro-North initiated the “Quiet CALMute” cars a few months ago, they’ve been a big success.
BETTER COMMUNICATIONS:    By cell phone, e-mail, PA system and ‘seat-drops’, the railroad is doing a much better job of communicating with its passengers on the rare occasions when things go wrong.
THE PASSENGER PLEDGE:      Though not quite the “Passenger Bill of Rights” that the CT Rail Commuter Council had crafted, this first-time-ever written pledge to passengers about the kind of service they deserve and can expect was a major step by Metro-North.
But wait, there’s more!   There are further enhancements being considered by the railroad:
WI-FI:           Testing continues, but we could be seeing on-train Wi-Fi accessibility in a matter of months, not years.
SMARTPHONE TICKETS: Yes, you’ll soon be able to buy a ticket on your phone, show it to the conductor, and never have to handle paper.
So, for those of you who think that all I do is moan and complain, re-read everything above and let’s both give credit where it is due.  Good job Metro-North!

Saturday, September 22, 2012

China 2 stage 5

Bombed out big time today. I had been so so confident going into todays 18km individual TT and this in the end proved to be my downfall. I ultimately finished 5th on the day and dropped to 4th on GC and am very very disappointed in wasting such a golden opportunity.

I had everything mapped out and plan in place to ride the exact time and speed I felt would be enough to win the stage and the race. In the end it would have been more than enough but unfortunately it was not me who performed it. Stefan shumacher defended his lead by proving he was the strongest man in the race of truth and winning todays TT.

For me all went perfect in my preperation and I arrived on the start line supremely confident. My warmup which I have completed so many times before went perfect and I was ready to rock and role. I started great and it all felt so easy. I was immediately a couple of kmph above the speed I planned and was having to hold back my enthusiasm to keep a lit on blowing my engine. I could immediately see that I was gaining quickly on the 2 riders ahead of me and assumed I was most likely putting time into my greatest rival shumacher in the process. In the absence of race radios our team director and I had devised a plan using the car horn to keep me updated on shumacher relative to me. Pretty simle, 1 honk was I was pulling away and 2 honks he was closing. Just as I started to settle into a perfect rythm and confident I was flying into the race lead I got a 2 honk when I had been exppecting 1. This immediately changed my mindset and confidence and while I could still clearly see I was closing on the 2 riders ahead of me to the tune of taking 20seconds out of them in the first 8km, shumacher was not following my script and was surprisingly closing. This was where the wheels feel completely off. Instead of relaxing into my comfortable fast rhythm I was now on edge and pushing the fraction harder than I knew or wanted to and was no longer racing my race. The 2 honks continued and I started to concede that if he was closing I had to except he was stronger and simply start to conserve in a bid to hold my own position of 2nd on GC. This seemed a relatively easy task considering I had taken 20-25 seconds out of the 2 riders directly behind me within the first 10km.

By half way I was completely puzzled and no longer racing my own race. I knew I was going quick but was demoralized that shumacher was apparently closing in on me. With the u turn it gave me a chance to see for myself exactly how close to me he was. To my surprize I was 15 seconds ahead by my rough calculation however It was a pretty accurate calculation give or take a few seconds. So now I was really confused and could understand why chris kept telling me I was down when I was clearly up at that stage. After this the wheels continued to fall off as the fatigue of pushing slightly harder than I knew I was capable of in the first half was beginning to take its tole. It not easy pushing a rd bike at 50kmph on the flat rd and 15min into the race I had averaged around 450 watts so I was certainly at my limit of capacity for an effort like this and to be able to pull it off I not only needed my body to be in perfect shape but most importantly my head which had gone from concentrating on what I was doing to thinking about everything else around me that I had stupidly allowed myself to worry about.

I pushed on and started rapidly loosing power and speed. I was now down around 46kmph and nudging closer to 45's and 44's instead of the 50's I knew I had to maintain to win. Still I maintained a big advantage over the riders ahead of me while chris kept honking his horn 2 times to remind me shumacher was coming. This was starting to really bug me as I had seen with my own eyes that it was not the case however as I was starting to suffer I assumed now he most probably was closing fast. At 5km to go I had my expert teammate in timing joris balit from switzerland!! To do some time checks and let me know where I was at at what I believed would be the most crucial part of the TT, the final 5km run to the line. I knew joris would be spot on with his time checks so I was confident I could believe in time check. As I passed he let me know I was 15 seconds up which I knew was about the amount of time I was ahead of the riders ahead so figured he was just telling me that but it turns out he was telling me I still had 15 seconds on shumacher which he had calculated with the use of a friend a km down the rd helping out. Talk about swiss precision!! As expected joris had not let me down but by this point I had well and truly let myself down and joris said he could see it in my face. He could not understand why I looked so defeated and did all he could to enthuse me as I went past but it was 2 late. He had seen me pedaling so perfectly as it felt in the first half when I passed him but now where I needed to hit the turbo I was dropping the anchor and visibly coming to a grinding holt.

At this point with 5km to go I was fastest by 15 seconds and in the virtual lead of the tour by 10seconds but I had already lost the race to what turned out to be my biggest rival, myself. If I had been more alert and focused on joris's time check which I knew I could trust and realized I was infact in this position as planned who knows how I would have approached that final 5km. I am pretty sure knowing your winning the tour would have a bit of a mental impact on you and boost which at this moment I desperately needed. In this case however there was to be no miracle. The wheels had well and truly fallen off. I continued to loose power and lose speed coming to the realization that I pushed to my limit and believing i was being still beaten by a stronger rider and was in survival mode. Even though it was not actually the situation and I was actually still on track to achieve exactly what I had set out to do 5km before this thought was long gone. As I slowed my rivals all sped up as I knew I needed to do to win the race. In the all 3 riders, the 2 infront and schumacher behind would take between 25-45 seconds out of me in the final few km and I was all of a sudden dropping completely off the podium into 4th and had blown a golden opportunity.

I reflected a lot and knew it was all my own undoing. I had made the fatal error of taking the focus of myself when I knew all was going perfectly with myself but allowed the honking of a horn to completely change my focus in the race. In chris's defense he said they found it difficult to take time splits of trees looking a minute behind them in the rear view mirror. He said they were doing there best but not really sure exactly what was going on. In reality it was dum of me to even suggest using such system and even dumber allowing it to dictate how I raced considering I felt I had a full proof plan anyway. I was confident I could win the race and did not need any more information than that. I needed to simply execute what I knew I was capable and when things got tuff which they do for eveyone use some mental strength to stay within my own body and push through and execute my plan. I have blown a great opportunity to win a race in the circumstances I always dreamed I could win one. Start the final day TT in a perfect position and ride into the jersey. It was my first chance to make the dream come true and I let it slip. I simply choked in every sense of the world.

It is days like today that remind you how important it is to be not only be physically at your peak but mentally aswell. Whenever I have done my best races or sporting performances it has always been after using a sports psychologist which are hugely under rated or arriving at an event with a clear mental plan and not allowing any outside distractions to waver me from my path. Today this focus alluded me and the result was disastrous, it brings me to the very simple conclusion. No matter how good I think I am or confident in my condition I have to ensure I am 100% mentally on the money as well. I am not and have never been the athlete that can rock up to any old event and use natural talent to dominate a field. The simply explanation is because I don't have any natural talent. I have only ever performed at the highest level and achieved my best performances when I have perfectly prepared for an event, both physical and mental. I don't have a switch I can flick. Any results I will ever garner will come from a specific period of training and preparation and its as simple as that. I am sad it taken another spectacular failure on my behalf to reinforce a fact that I certainly knew deep down but just another little reminder that we are always learning! Its ok to make mistakes, we all do!! The most important thing is what you learn from it and do differently in the future to ensure it does not happen again.

Cjw

Sent from my BlackBerry® wireless device

Friday, September 21, 2012

China 2 stage 4

Same same but different was the order of today. Same race plan as previous days with same expected outcomes. And as it has often turned out in this race that is exactly what transpired. A break got away a little earlier than normal which gobbled up all the intermediate sprints preventing our "sprint machine" anwa manan from adding to his tally of points in the sprint competition. The stage was by far the slowest and easiest of the tour which meant a more chaotic sprint than normal was on the cards. This is a by product of a peleton full of fresh legs and all of sudden every tom dick and charlie fancy them as a sprinter and riders go absolutely everywhere. Its at these moments I simply take no risks and sit up and ensure I don't lose time and maintain my position on GC. The crazy sprint rendered me useless in aiding our "sprint machine" and "bundy bullet" in the final km however the craziness of it all meant that after a few more riders than they were comfortable with bumping into and off them they also aborted the mission and were simply happy to finish the stage with all skin intact. With that anwa lost his blue jersey however in his true flare and exuberant nature declared it "no problem mate" in his finest aussie accent and plans to have it back by the time the race wraps up on sunday.



So the day has finally arrived that I have been waiting for with anxious anticipation. A 18.2km test against the clock which will most likely decide the winner of the tour of china 2. I feel good and have had the luxury of saving as much energy as possible for the race of truth so will see what happens.



Time for a little shut eye



Cjw

Sent from my BlackBerry® wireless device

Thursday, September 20, 2012

China 2 stage 3

Stage 3 of china is done and dusted and by dusted I mean that quite literally dusted!! Head to toe in fact. I can not remember ever having not only my hair turned a light grey brown but also my feet. Yes the dust here or whatever they have in the air has a unique ability to not only get all over you but also infiltrate your shoes and socks!!

Back to the racing and we had again some simple objectives for what has been a very simple race thus far. Firstly was to set up our "speed machine" from malaysia anwa manan for the intermediate sprints should the group be together. Anwa Is perhaps my favorite team mate I have ever had, just having him around cheers everybody up. While he could be describe as a little lazy by many I beg to differ!! He is just a true blue through and through sprinter. He want waste a single lick of energy he does not need to such as you will often need to knock on his door for about 10minutes until you either wake him up or he has decided that you must really need him so he will raise himself from his royal rest and greet you at the door!! He is without a doubt a great character and one guy I love racing with! In malaysia anwa is a serious sporting star thanks to being the only malaysian to ever win a stage of there national tour, le tour de lankawi which he achieved in 2010. Why is this significant well I will explain. He is the regarded as the fastest and greatest rider from malaysia. Here in the tour of china there is also his old team from malaysia whom are determined at every turn to try and steel the kings thrown. Where he goes they follow!! Look in tour of china 1, one day anwa 4, another malaysian 5, anwa 30 another malaysian 31st and so it goes through out each stage it is so funny to watch!!

So back to the race and having anwa fighting for the blue sprinting jersey which he now leads has many benefits. Firstly it gets our super hero up on the stage every day and him a chance to try his charm on the podium girls. Secondly by him going for all the intermediate sprints also means taking time bonus's. This is where it has an extra benefit for us as with me 2nd on GC we don't really want anybody putting any time into me before the penultimate day TT. So with anwa sprinting away that means all his little buddies from malaysia also are going hell for leather for the intermediate sprints and swallow up all the time bonus's!! Its great, anwa is the star and maintains his malaysian superiority and I can stay in 2nd on GC!

Our other plan today was to set anwa up for the sprint at the finish which finished 4th in, oh and you guessed it a malaysian safely tucked onto his wheel in 5th!! but after winning an intermediate sprint he took the lead in the points classification so great day all round. I remain in 2nd so another rd stage tomorrow where I expect much of the same and the race of truth arrives on saturday with the 20km individual TT which will most likely decide the winner of the 2012 Tour of China 2.

this race has also been containing a much more challenging component than the race itself, that been long driving transfers before and after stages and also on designated days of racing which we have had 2 off this week. On both occasions spending 7hrs in the car. And that is where I wright from at this moment, a 250km transfer which we have been informed will take 4hrs despite the fact we have a full police escort and 6 lane wide HWY all to ourselves. Like everything here in china, it makes EVERYTHING EXCESSIVE. Anyways best get back to work directing our mechanic risto whom is driving of picking our way through the convoy so we win the race after the race!! The one to the best spot in the bike mechanics work area!!

Cjw

Sent from my BlackBerry® wireless device

Sunday, September 16, 2012

IMG00592-20120916-0823.jpg

The chinese bob sleigh team!!

Sent from my BlackBerry® wireless device

Correction

Today my time was 7:40 not 6:40!! Oops if only

Sent from my BlackBerry® wireless device

My Dad

Other exciting news from the wurf cycling stable is that my dad today raced the world masters qualification event on the great ocean rd in victoria. In his age category which I regret to inform I have no idea what it was!! He placed a steller 16th out of 300 placing him easily inside the top 10% required in his category to qualify for 2013 world masters rd race in a yet to be announced location. Dad is very similar to me in his approach to cycling, a well suited engine which unfortunately gets used perhaps a little to much in training and consequently turning up to races and not seeing the same results as on the training track!! Fortunately this week which is coincidental as I experienced this aslo, we both came down with the flu and have had to go easy easy to be right for our respective events held today. Surprize surprize we both rocked up fresh as daisies and both performed at a level that is probably our better race performance we have ever done. Could be a good lesson in that!!

Anyway I am very proud of dad's achievement although it comes as no surprize he is going so well so soon after taking up cycling. Firstly he is fiercely competitive with his daily routine consisting of training before cross referencing his session with mine to see where he is at!! This is followed hrs of research on diet, equipment, race courses, training and often uncovering any information on my fellow competitors which he may deem to be usefull info for me. So not only is he a die hard for his own success but like he as always been he a great support and continued driver behind ensuring I get the most out of myself and keeping me armed with as much info and knowledge as possible to achieve it. Unfortunately he lives in queensland while I spend my time in tasmania so we can't train together but that is probably lucky as I am sure we would destroy each other constantly pushing ourselves that little bit further!! He is the perfect training buddy and dude to have in your corner so I am real pleased he has taken an interest in the sport I love and also now enjoying the success's of all his hard work and unrivaled dedication. He is an endless support in so many ways and it is great sharing the journey 1st hand with him.

I am sure with dads qualification for the world masters that his training and daily research will go to a whole new level as he looks to uncover all the 1%'s possible. I am just very fortunate that he does all this hard work for me and look forward to learning daily what he uncovers. Great stuff dad, look forward to seeing you take on the world in 2013. Now I need to get my backside into gear and get back on that national team to maintain the family standard!! Pressure is on!!

Cjw

Sent from my BlackBerry® wireless device

china 2 stage 1

The 2nd part of our adventures in china kicked of today with The Tour of China 2. The race was not due to begin until the 18th however yesterday afternoon race organisers decided that 4 days between the races was to much rest and figured it would be a great idea to hold a 6.2km prologue today to kick things of before we have another day off tomorrow to drive 600km and continue the race as planned on the 18th from where ever it is we end up after the rd trip tomorrow!



To be honest i am glad they did through in this extra day as 6.2km of a dead flat circuit and 1 corner, i.e. a turn around so we could go back the way we went out, was about as perfect a stage as possible for me. Perfect in as much as it was not techniqual and also the effort is about as close as it is ever going to be to do the 2km rowing ergometer test i used to love so much from my days in the national rowing team. I have done so many of these efforts that at one time in my youth, dad would make me complete this test every 2nd day for about 2 years!! surfice to say i was pretty confident i would do a solid ride as possible, i was pretty much on auto pilot. This experience however proved to be my downfall as on the rowing machine the fear is always going out to hard and blowing up. When you run out of power on a rowing machine you litterally stop counting down the meters as there is no other element than yourself to keep the machine cranking. For this reason i had over the years of many failed perfromances on the machine developed a full proof strategy in my final years in rowing which rarely saw me fail to attain a PB.



This approach was starting pretty solid for about 100m and pulling 1:28 per 500m splits for this time before i would gradually let the pace rise to my cruising speed of 1:33-1:34 by the time i had rowed 300m. from there i would hold this split easily at first before it would start to get harder to maintain in the final 1000m. From here i would really grit my teeth and fight to hold more 1:33's the 1:34's until i got to the final 300m where i would start to go hell for leather counting it down in 10 stroke increments with the aim of again pulling 1:28's in the final 100m. If all goes to the script as it usually did i would finish up with 6:11-6:12 and be either at the top or very close to it depending on how hard my mate mighty mike mc bryde decided pull on the handle.



Back to today and this full proof plan i felt like i was armed with all the knowledge and perfect plan i could have. Again this proved to be a backfire. I had decided that i could average between 460-480 watts depending on how well my legs felt and needed to be at this pace after my initial 10second accelleration up to speed. This was error 1!! after 10seconds i was only at 51kmph which ended up being merely 1kmph slower than i averaged for the entire effort. Once in my crove hovering around 450 watts i felt great and wanted to push hard but kept saying hold back hold back!! mistake number 2!! at the turnaround at halfway i was barely puffing and thought perfect as i had decided from 3km i would start to build gradually to the line. This was mistake 3, i built nice and gradually very carefull not to push to hard and explode and i did this. With 1km to go i was touching on 480-500 watts and still feeling fresh as i began to wind to the line and finished with a perfect average power as predicted bang on 475 watts. Where i had gone horibly wrong was not thinking like a cyclist and realising it is much easier to push a little harder and reach a higher speed where it is then easy to maintain with less power by tapping out a rythm to hold the speed. It is much had to increase speed with a steady power and you simply get bogged on where you have accellerated to. So while i did exactly as planned i also lost the race bace 3seconds to stefan schumacher and finished in 2nd place again, just like in tour of japan prologue behind my team mate will clark. I am sertain that had i have used a cycling brain as apposed to my useless rowing one when racing a bike, i could have ridden my bike much quicker. Anyway i did not and basically playing it safe meant i was never racing to win but simply not to lose. In the end i was the only loser!!



Fortunately we have an individual Time Trial of 18kn on the second last day so i have the chance to make a mends and this time race like a man and see what happens. Will certainly approach the stage with the attitude that it is better to fly and die than never fly at all!! Will see what happens on saturday!



data



Distance/Time: 6.2km/6'40"

Speed ave: 49.5kmph

Watts Ave/Max: 478/890watts

Heart Rate Ave/Max: 188/201

Cadance Ave: 100



cjw

Wednesday, September 12, 2012

IMG00588-20120912-1653.jpg

A classic example of our team director showing his competitive spirit in the race to the hotel for the best bike washing position!

Sent from my BlackBerry® wireless device

China 1 stage 5

Yet another day of chaos here in the tour of china. With a 6 lane rectangle pancake flat wet rd circuit of 11km x 10 laps there was always 3 things certain!! Ridiculously fast speed, massive crashes, and a crazy chaotic bunch sprint.

All duly transpired which was good on one hand for us as our plan remained unchanged with setting up the sprint for the bundy bullet aaron kemps, and defend the "great chinese rider" jersey for xu gang. Unfortunately the bundy bullet hit the deck in a big pile with 25km remaining which also stopped me in my tracks, fortunately I remained of the tarmac!! On a positive I spent nearly half the race riding full bannanas on the front to keep the field together so was happy to have finished a stage feeling like I had been run over by a truck which is a feeling I actually enjoy. The post race coke always taste's so much better when you have ridden yourself into the ground!! The crash took the edge of aaron so he did not get involved in the chaotic bunch sprint but xu gang successfully defended his "great chinese rider" jersey so that was a big objective met. After the race was stage 2 which involved a 300km transfer to the start city for tomorrow's final stage. These are always a bit of a hoot as its the team managers turn to race each other up the hwy in a bid to get to the hotel 1st so respective team mechanics can get the best possy to work on the bikes!! Yes everything associated with a bike race is a RACE!! That's what happen when the ex bike riders become staff members you end up with a big big group of competitive dudes. So the jostling for position on the hwy at 150kmph was that terrifying that I put on the neck pillow on and went to sleep with the hope that I would wake up safely at the hotel. Arrived safely and found my room which seemed to be a bit stuffy, like it was not use much. I pulled back the curtains and low and behold a bat flew out!! That is unique!! I can honestly say I have never had a bat hide out in my hotel room curtain in all my world travels!!

The adventure continues!!

Race data
Distance: 115km
Time: 2hrs 18min
Speed: 51kmph
Heart rate ave/max: 150/195bpm
Power ave/max: 310/943 watts
Energy burnt: 2427kcal

Cjw

Sent from my BlackBerry® wireless device

Tuesday, September 11, 2012

China 1 stage 4

It was a slippery dippery day here at the tour of china. As I have mentioned before the Rds are not the cleanest in the world with oil, dust, rocks and any other type of general waste that spills from what would be described as poorly serviced vehicles!! Basically it is a film of filth that combined with a light shower of rain becomes an ice skating ring.



On a positive we had a basic plan for the day to keep the peleton together for bunch sprint hoping our bundy bullet could pulverize the other opposition in the bunch gallop. A nice little break went and I planted myself on the front with a few riders from other teams to keep all under control and most importantly keep every body at a safe speed around the slippery corners. All went according to plan and with 5km to the finish the field was all together and the bunch sprint was set up. Only problem we had was now negotiating the final series of corners in the final 2km. Aaron was in perfect shape however once we hit the corners our japanese kamikaze's decided it was crash or win and hit the corners at full speed. Not surprisingly the results were mixed for them with half crashing but half surviving and ultimately winning the stage as crashes and confusion meant they were alone ahead with a pile of chaos behind so congratulations to them, take the risk and be rewarded for it. Our boys were not so aggressive and consequently a few fell while the rest of us were happy to get to the finish and live to fights another day with all our skin intact. Once again never a dull moment racing in china!!!



Cjw 



Distance: 100km

Time: 2hrs 5min

Speed ave: 49kmph

Power ave/max: 285/1070 watts

Heart rate ave/max: 125/185bpm

Energy burnt: 2000kcal

Monday, September 10, 2012

The Bridgeport - Port Jefferson Ferry



Every now and then it’s great to see a transportation system that works really well.  Case in point, the Bridgeport (CT) to Port Jefferson (NY) ferry.
I’ve written in the past about some folks’ crazy idea that ferry boats are the solution to our traffic problems along I-95.  They are not.  But they do prove useful when they take you where the roads and rails can’t, like across Long Island Sound.
The first ferry ran this 18-mile route in 1872.  By 1883 permanent service was offered by a company owned in part by Bridgeport’s PT Barnum (after whom one of the line’s current vessels is named).  In 1980 all-season service began with the line’s largest vessel, “The Grand Republic”.
The Bridgeport & Port Jefferson Steamboat Company is 100% owned by Brian McAllister, a fourth generation seaman and tugboat czar who lives on Long Island.  You’ll usually see one of his tugs in Port Jeff’s harbor.
Each of the line’s three ferries is “RO-RO”, for roll-on, roll-off.  At Bridgeport, cars and trucks drive on from the rear and exit in Port Jefferson by driving off thru the raised bow of the vessel.  The ferries can carry between 90 and 110 vehicles and a thousand passengers.
The crossing takes about an hour and a quarter but you can save considerable time, tolls and aggravation by avoiding driving to New York City and crossing the Whitestone or Throgs Neck bridges.
When it began, the ferries carried food grown on Long Island to industrial cities in New England.  Today you’ll still see an occasional truck ferrying seafood, but most of the traffic is tourists and business people.
In season, all three vessels are in operation allowing for almost hourly departures.  If you’re bringing a vehicle a reservation is a good idea, though on most weekday runs you can just drive right up and catch the next boat.
The vehicle unloading and re-loading process is smooth and when passengers leave their cars they can join foot passengers upstairs at the snack bar or cocktail lounge.  In good weather the sundeck affords a wonderful view.  There’s Wi-Fi available onboard and cell-phone signals are strong, even in the middle of the Sound.
In Bridgeport, the ferry dock is a two-minute walk from Metro-North.  But in Port Jefferson it’s about a 25-minute walk from the dock to the nearest Long Island Railroad station.  Taxi service is available at both terminals.
Fares aren’t cheap:  $54 for a car and driver, $15 for each additional passenger.  Foot passengers are $18 one-way, $26 for same-day roundtrip.  Seniors (age 60+) are $13 one-way, $18 for a same-day return.  Kids 12 and under are always free when traveling with an adult.
There was talk a few years ago of offering additional service from New Haven to Port Jeff.  More recently there was discussion of also running to Stamford and from there to NYC using a high speed ferry, but rising fuels costs sunk those plans.
The current ferries are hardly high speed… just 17 mph according to my GPS on a recent crossing.  But they’re a fun way to travel, avoiding the traffic mayhem of New York City when going from Connecticut to Long Island.

Sunday, September 9, 2012

A simple 23 step guide to Books, Batches, and Bursting in Hyperion Financial Reports

Introduction to the guide

I was asked in in this thread over on the Network54 Essbase board to post a guide to Hyperion Financial Reports batch bursting I wrote a while back.  I’m happy to share what I came up with but first a couple of caveats:
  • I have redacted identifying information from the screenshots.  It’s usually pretty obvious where this has happened.  
  • If you have questions about this, go ahead and make comments but unfortunately, I can’t reproduce the environment I did this one because:
    • I wrote this for EPM 11.1.2.0 (so an almost two year old release).  I have no idea if the defects/bugs/weirdness/obvious-stuff-that-I-am-too-dense-to-see have been resolved or not in 11.1.2.1 and 11.1.2.2.  Mercifully, I have not been called upon to do more with batches since writing this document.
    • Some of the issues I encountered were, I think, caused by a less-than-perfect installation.  I could rant on and on about how bad it was but it would bore everyone, even me.  At the time, I asked someone I know in infrastructure what he thought it would take to resolve all of the issues (oh, I had a working issues list).  The reply?  “I wouldn’t touch that with a 40 foot barge pole.  If I were to come in, I would insist on a complete reinstallation on a clean box.”  In other words, nuke and pave.  I mention this not to reflect the frustration we application developers encounter when an install is bad, but to note that some of the general weirdness may be because the software wasn’t “right”.
  • I wrote this in the form of a step-by-step tutorial.  I never did find one on the web – I thought for sure there would be one but my google-fu failed me.  Maybe there’s one now, but I sort of doubt it.
  • Contrary to what I wrote in that thread, doing all of this is not 23 steps, but instead:
    • 24 steps (23 to create + 1 to view) to create that scheduled batch
    • 6 steps to import a bursting file (and yes, I explain what a bursting file is) into Workspace
    • 6 more steps to applying the bursting file into the batch scheduler
    • Although I am somewhat math-challenged, that means this is a 36 step process.  It's almost the 39 Steps.

And with that out of the way, enjoy.    

Background

Briefly, there are six kinds of Financial Reports documents typically encountered in a Planning implementation:
  1. Financial Reports – the base Essbase/Planning report
  2. FR Books – collections of FRs using, where applicable, a common POV to drive all reports within a book
  3. FR Batches – Objects that contain reports and books.  A batch can contain a single report, multiple reports, a single book, multiple books, mixes of reports and books, etc.
  4. FR Scheduled Batches – Scheduler (Workspace has its own, reports-only scheduler) of FR Batches and their Books and reports.  Scheduled objects can get written to Workspace folders, zip files, and emails.
  5. Burst batching – A way to parameterize scheduled batches and overload single dimension selections (only one dimension can be bursted and yes that is a strange word for it) with either manually selected members or members driven through imported burst files.
  6. Bursting files – These are comma-delimited files used to drive burst batching

How to create a Scheduled Batch in Workspace 11.1.2.0

It’s just a simple 23 step procedure to define a scheduled batch.

Creating a book


1)  After creating a FR report, create a FR book by logging into Workspace and clicking on the Explore button.  Then select File->New->Document,.
2)  Select “Collect Reports into a book”
3)  Pick the report you want to incorporate into the book.  Books commonly contain more than one report but that is not a requirement.

4) Move the report(s) over to the right hand list box and when complete, click “Finish”.
5) The data sources in the report(s) will show up in the book.  These will be driven by the book’s POV.  
6) If you wish to get rid of the book’s table of contents, deselect it as shown below.
7) To force the save of the book, close the document; you will be prompted to save the book.
8) Save the book to whatever name and location you desire.
9) This book will be used in the batch.

Creating a batch


10) Go to File->New->Document again, but this time select “Batch Reports for Scheduling”.
11) Batches can be just a single or multiple books and reports.  To see them in the file selector, use the dropdown at the bottom to toggle between the different kinds of base documents.
12) Move the object you want to put into the batch over to the right.
13) Again, close the document to force a save action.
14) Save the batch.

Scheduling a batch

Creating the scheduled batch

15) Schedule the batch by going to the Navigate->Batch Scheduler menu.
16) In the Batch Scheduler screen, right click and select “New Scheduled Batch”.  This will launch the scheduled batch wizard.
17) Name the batch.  You can make the batch a one-tme affair by selecting “Delete Scheduled Batch Entry from Scheduler if Completed Successfully”.  Do not do this as creating a batch is fairly painful, as you may have noticed.  Click on Next to move to the next step.
18) Select the batch you want.  In this example, it’s “Batch for XXXXXXXXXXX”.  After entering the name, click on Next to move to the next step.
19) You will be prompted to log in to both FR and Essbase with an administrator id.  I do not recommend a specific userid like CameronTheConsultant as these ids get terminated.  

Selecting members for data connections

20) Individually select the connections (the All option doesn’t work, see Oracle Support ID 1097787.1) and select (usually) identical cost centers for each data source.
21) There’s a big bug in FR batches – as far as I can observe, when the scheduled batch is edited the Selected Members appear to be defined (and are shown in the Select Members text box) but are not.  The only way around this bug is to select the individual data connections and click on the Copy Members button to reapply the Cost Center members.

I have also found that clicking on the Preview Bursting List button for a given data source will deselect the selected members for the other data source.  To make sure both data sources are selected, click on the Copy Members button for both data sources and do not use the Preview Bursting List.

Click on Next to move to the next screen.

Defining where the batch output goes

22) Select “Export as PDF” and “Export to an external directory”.  Click on Next to run the batch.
23) A confirmation dialog box will appear.
 

Reviewing the output 

24) The external directory FRExport1, as defined through the FRConfig.cmd utility on the Financial Reports server, corresponds to \\yourservername\f$\FRExport1.  The output structure is as below.



Bursting files in scheduled batches

Bursting files are comma delimited files used to externally drive batch bursting member selections.  Given the bugs in FR batch scheduling, bursting files also provide a way to quickly and consistently select members in the Bursting Options.
For Oracle’s take on the bursting file parameters see:  http://download.oracle.com/docs/cd/E17236_01/epm.1112/fr_webuser/scheduler_wizard_fr.html

Bursting file fields

dimension_dimensionname

In the CCRpt example, the column name is dimension_Cost Center.  Within the field, the member values are the cost center numbers.  Per the documentation, member names must match on case.  Only one dimension per burst batching file can be defined.

subfolder_name

The name of the folders underneath the main one defined in the batch schedule.  The CCRpt example uses <<FinancialReportingObjectName()>>-<<MemberAlias()>> which passes the name of the book and the member alias from the dimension_dimensionname column into the sub folder name.  Other valid tags are <<MemberName()>>, <<BatchPovMember(DataSrcName,DimName)>>, <<BatchPovAlias(DataSrcName, DimName)>>, <<FinancialreportingObjectDescription()>>, and <<Date(“format”)>>.

financial_reporting_object_name

The name of the pdf files.  The same parameters as subfolder_name apply.

group_names

The Shared Services group that runs the batch, by row.  Not used in the CCRpt example.

role_names

The Shared Services role that runs the batch, by row.  Not used in the CCRpt example.

user_names

The Shared Services user name that runs the batch, by row.  Not used in the CCRpt example.

email_list

The SMTP email address that receives the batch pdf output.  Although this is set in the CCRpt example, it does not work because the SMTP configuration was not done during installation.

external_pdf_root

The root of the file output.  This overrides the output from the scheduled batch.

Importing the bursting file to Workspace

For the scheduled batch to read the burst batching file, it must be imported into Workspace.
1) After creating the batch bursting file in Excel and saving the output as a comma delimited file, import the file into Workspace by clicking on the Explore button, navigate to the target folder,  and then the menu File->Import->File and then select the file.
 
2) Click on Browse and select the file.
3) After confirming the file in the File textbox, click on the Next button to move to the Advanced screen.
4) Click on the Next button to move to the Permissions screen.
5) Click on Finish to finish the import process.
6) The file will appear in the target folder.
For your amusement, I have stuck a copy of the file here.  It’s in (as noted) comma-delimited format.

Applying the bursting file into the batch scheduler

1) In the batch scheduler, select the data source, then tick the “Run Batch for multiple members in the dimension”.  Then click on the ellipsis button to import the burst file.
2) Select the burst file – this is the file just imported into Workspace.
3) You will see the comma delimited batch bursting file’s full path.  Click on the “Copy Members” button to apply the values in the batch bursting file to the data source.
4) Once the Copy Members button has been clicked on, the members in the burst batch file will be shown in the Select Members text box.  This comma delimited list of members can be modified by clicking on the magnifying glass.
5) Select the other data source and apply the members by clicking on the “Copy Members” button.  It will look like the members are selected – this is not the case – never be afraid to click on that button.
6) Click on the Next button to continue defining the scheduled batch as defined above.

Conclusion

That was easy, wasn’t it?  :)

Okay, it wasn’t really hard at all, and it is pretty cool functionality.  However, it took me FOREVER and a day to figure out how to do this and I had to reach out to multiple people (in fact an ex-client from my ex-consulting company. Hello! Lisa Abrewczynski and Rholanda Brooks) to get the answer.  What, you think I figure all this stuff out by myself?  If only.  Oh wait, no one thinks that.  Regardless, it was super nice that they both took time to help me out – I am obliged.

And that’s it!  I hope you enjoyed this super short (hah!  25 pages in Word) guide to books, batches, and bursting.


Popular Posts