Thursday, September 22, 2011

Run while you can


It’s that time of year again

ODTUG is looking for nominations for its board of directors but you only have until 28 September 2011.  

As one of the members not up for election this year (see you next year), I was asked to write up why I thought you might want to run for this august group of geeks.  Take a look at the ODTUG blog for my guest post.  You may also want to check out Mike Riley’s slightly more sane post on why he did it and why it might be for you.

If my (not Mike’s) kind of drivel isn’t your cup of tea (But then why oh why are you even reading this?  I will leave that to you to ponder.), at least check out the call for nominations and the nomination guidelines.

If you’re interested, the nomination deadline is next Wednesday, so there isn’t much time.  Don’t let the deadline pass you by if you’re interested.

Sunday, September 18, 2011

Quiet Cars Come (Finally!) To Metro-North


It’s been more than five years since I first wrote about the idea of “Quiet Cars” on Metro-North.  It looks like my persistence has paid off, as the railroad is about to start an experiment with such cars this fall.  The first trains offering a "quiet CALM-mute" will be on the Danbury branch line starting in mid-October when the new timetable takes effect.
The “Quiet Car” idea originated at riders’ suggestions on Amtrak way back in 2001 on the early morning express from Philly to NYC.  Passengers wanted a place to enjoy a peaceful ride (and maybe a nap) without obnoxious cell phone chatter or loud conversations.  The idea was so successful that it was quickly rolled out on other routes.
Conductors remind boarding passengers that the “Quiet Car” maintains a “library-like” atmosphere.  Cell phones, computers, radios and CD players should be muted.  If you need to take or make a call, step out to another car.
For the most part, the rules are self-enforced by passengers.  Those whose phones start ringing are quickly reminded they are in the wrong car and they usually move.  There have been exceptions, including a celebrated case this spring when a woman was arrested for yacking for 16 hours on her cell phone and refusing to move from the Quiet Car.
Most commuter rail lines in the east and west have picked up on Amtrak’s success, offering the Quiet Car concept, usually to passenger acclaim.  But not Metro-North.  When the CT Rail Commuter Council suggested the concept, Metro-North refused, offering a number of excuses. 
First, they said it would be hard for conductors to enforce.  That’s strange, as the conductors have no trouble enforcing other rules like no smoking, no bags or feet on the seats.  Then the railroad said it might violate free speech, never mind other passengers’ rights to a peaceful, enjoyable ride.
But the real reason for Metro-North’s opposition was crowding.  Without enough seats for all paying passengers, how could those seeking solace be sure they could find a seat?  It seems that the railroad assumed that a handful of peace-freaks who couldn’t fill a Quiet Car would force standees in other cars.
In fact, it will be just the opposite.  I’d predict that the Quiet Cars on Metro-North trains will be jammed.  And there’s certainly precedence.
Remember the old days of “smoking cars”?  It used to be that every other car on a train allowed smoking.  Those who wanted to avoid the blue haze sat in the non-smoking cars.  Those clean-air cars soon became so popular that fewer cars were designated for smokers.  Eventually, the smoking cars were eliminated.  Now, in NY State, you can’t even smoke on the train station platform!
Nobody is suggesting that cell phones be banned from the trains.  Rather, those of us looking for a quiet commute just want our fellow riders to be more considerate.  The railroad’s attempt to educate cell phone users to step into the vestibule to make their calls has had some success, but the issue goes beyond cell phones.

Have you ever been on a train where a gaggle of teens has carried on in a loud voice, oblivious to the impact of their chatter on others?  Or how about the recent case where a “well educated” young lady was kicked off a train for loud profanity? 

When the members of the “me generation” take public transportation they forget that they are sharing the ride with others.  The behavior they can get away with at home or in the car just doesn’t cut it on the train.  To them I say, “Grow up”.  It’s about “we”, not “me”.
So kudos to Metro-North for finally getting the message.  Let’s all do what we can to make this experiment a success.

Thursday, September 15, 2011

Hate Smart View? Love the add-in?


Don’t be a hater

It looks like it’s finally time to embrace Smart View.

Why?  

Remember all of those things that the add-in has done since the year dot but Smart View has not?  (Ooooh, a rhyme, and not even intentional.)

Yes, you remember.  How could you possibly forget?

The answer to all of our Smart View prayers is here:  full add-in parity has (apparently, see below) been reached.

Has wild cheering ensued on your end?  It did on mine when I heard about it.  

See the Essbase Labs post on the functionality right here.

And MMIC's even more detailed take on it here.

Fall in love all over again on 29 September 2011

If you want to see this in action, go to Oracle Support and search for document id 1356368.1.  This will sign you up for the webinar.  Remember all of those Support Advisors I’ve blogged about?  This webinar is part of that initiative.  Have you had good thoughts for Support lately?  You should.

See you there.

Sunday, September 11, 2011

Stage 5 padania

the final stage of padania went nice and smoothly and successfully for our team liquigas cannondale. By days end Elia finished another very close 2nd in the bunch sprint, Ivan wrapped up the overall victory for the tour and elia won the points classification so was a great 5 days of racing for our team and most significantly our two leaders Ivan Basso and Elia Viviani. The day went along pretty calmly. A breakaway of 2 got away early and built up a big lead of 7min untill we started to real them in with about 100km to go. I traded some work on the from with longo and vanotti so was also a bit easier day for me than the previous days were i spent alot of time alone on the front. With 30km to go the race was back together so then we really whipped up the pace to discourage and further attacks and with 10km my time in the sun on the front of the peleton came to an end for the tour and i retreated to the saftey of the back of the bunch for an enjoyably fast ride to the finish as our strong men, bodnar, oss, basso, sabatini and finally elia took over to set up the sprint. So all in all the days work went off without a hitch and we all had a nice end to a great 5 days racing. It was a particularly enjoyable race for me as it was first opportunity to race a small stage race with our team leaders in fine form and me also feeling good and being in the condition required to contribute so from this point of view i was really happy to be appart of the sort of race i had always hoped to be with liquigas and its big leaders like Ivan and Elia. To see ivan win was certainly a special moment for me as being so close to him throughout the year on and off the bike and training and racing i had seen him have a few tuff months but he never diverted from his work ethic and finally this week in padania it was rewarded. He truly showed his true class with this win in padania and i hope it gives him the confidence that he was missing at times this year to keep up with these great performances. For Elia well he is a young kid going places very very fast as per his charactoristic as a sprinter and the cycling world will be hearing alot about him in the years to come. It would come as no surprize then to know that it is very very enjoyable working for these guys and knowing that a long day on the front will usually result in a great performance by one of these guys makes the pain and fatique pretty much dissapear. It was certainly a great 5 days with a great bunch of guys.

SRM
Time 4hrs 10min
40kmph average
265watt average
140 heart rate average
3600kj burnt
1500m altitude gain

CJW

Sent from my BlackBerry® wireless device

Saturday, September 10, 2011

Stupid Planning queries #5 -- dimension list and Custom dimension

Introduction

Has anyone been reading this series of Planning dimension extracts?  Anyone?  Other than Godoy (oh so close to Godot, and maybe I’m waiting for him)?

Hmm, well, no matter, I think I do this as much for myself as anyone else.  So today I’m going to share two (oh, be still my trembling heart) queries today.

As always with these queries, they are 100% unsupported by Oracle and there’s a tremendous chance that I’ve gotten them wrong, so test, test, test and remember that you are hacking the tables and if anything blows up you are completely on your own.  Got it?  Good, let’s begin.

First query

Have you ever wondered how the code I’ve posted knows that HSP_OBJECT’s OBJECT_ID 32 is Account?  Or that 34 is Period?   After some of what you’ve seen, this should be easy peasy lemon squeezy.

--    Purpose:    Query to figure out dimension ids
--    Modified:   29 July 2011, first write Cameron Lackpour
--    Notes:      The DIM_ID values will be used in all kinds of dimension
--                queries
--
SELECT DISTINCT
    M.DIM_ID,
    O.OBJECT_NAME
FROM HSP_MEMBER M
INNER JOIN HSP_OBJECT O ON
    M.DIM_ID = O.OBJECT_ID

First output


Second query

Now that we know what the dimension id for Segments (remember, this is the Planning sample application and Scenario, Account, Entity, Period, Version, and Year are required dimensions with HSP_Rates and Currency thrown in for good measure in the Hyperion-built multiple currency application) the query to bring out all kinds of custom dimension goodness should be pretty easy.

If you are as sad as I am, you might find this a special treat:  both UDAs and Attributes get pulled out as shown below:

UDAs



Attributes


The code

--    Purpose:    Illustrate the querying of a custom dimension
--    Modified:   3 August 2011, first write
--    Notes:      Now with formulas, UDAs, and Attributes!
--               
SELECT
    PO.OBJECT_NAME AS 'Parent',
    O.OBJECT_NAME AS 'Child',
    -- Use SQL Subquery to get aliases.
    -- NB -- The overall SELECT from HSP_MEMBER ensures that members with
    -- and without an alias are selected.
    -- ISNULL puts in zero length string in place of NULL
    ISNULL((SELECT OA.OBJECT_NAME
        FROM HSP_ALIAS A
        INNER JOIN HSP_OBJECT OA
        ON A.MEMBER_ID = O.OBJECT_ID AND
        OA.OBJECT_ID = A.ALIAS_ID), '') AS 'Alias',
    --    Remember, there can be up to five plan types per Planning
    --    application, so CONSOL_OP1 through CONSOL_OP5 are valid.
    CASE M.CONSOL_OP1
        WHEN 0 THEN '+'
        WHEN 1 THEN '-'
        WHEN 2 THEN '*'
        WHEN 3 THEN '/'
        WHEN 4 THEN '%'
        WHEN 5 THEN '~'
        WHEN 6 THEN '^'
    END AS 'Operator',
    CASE M.DATA_STORAGE
        WHEN 0 THEN 'Store Data'
        WHEN 1 THEN 'Never Share'
        WHEN 2 THEN 'Label Only'
        WHEN 3 THEN 'Shared Member'
        WHEN 4 THEN 'Dynamic Calc and Store'
        WHEN 5 THEN 'Dynamic'
    END AS 'Storage',
    CASE M.TWOPASS_CALC
        WHEN 0 THEN 'No'
        WHEN 1 THEN 'Yes'
    END AS 'Two Pass',
    --    Change the syntax of the CASE statement to support testing for NULL
    --    Dave's Unofficial Guide has DATA_TYPE = 0 as
    --    Unspecified, but in 11.1.2 that isn't the case.
    CASE
        WHEN M.DATA_TYPE IS NULL THEN 'Unspecified'
        WHEN M.DATA_TYPE = 1 THEN 'Currency'
        WHEN M.DATA_TYPE = 2 THEN 'Non Currency'
        WHEN M.DATA_TYPE = 3 THEN 'Percentage'
        WHEN M.DATA_TYPE = 4 THEN 'SmartList'
        WHEN M.DATA_TYPE = 5 THEN 'Date'
        WHEN M.DATA_TYPE = 6 THEN 'Text'
    END AS 'Data Type',
    --    As far as I can tell, this isn't used in Planning, but is still
    --    there.  Why?
    CASE
        WHEN M.USED_FOR_CONSOL = 0 THEN 'False'
        WHEN M.USED_FOR_CONSOL = 1 THEN 'True'
        ELSE 'Undefined'
    END AS 'Used for consol',
    ISNULL(F.FORMULA, '') AS 'Formula',
    --    The subquery will puke if it returns more than one
    --    UDA, so do string concateenation using FOR XML PATH
    ISNULL((STUFF((SELECT ',' + U.UDA_VALUE
        FROM HSP_MEMBER_TO_UDA MU
        INNER JOIN HSP_UDA U ON
            MU.UDA_ID = U.UDA_ID AND
--        INNER JOIN HSP_OBJECT O
            MU.MEMBER_ID = O.OBJECT_ID
             FOR XML PATH ('')),1,1,'')), '') AS 'UDAs',
    ISNULL((STUFF((SELECT '; ' +
        OAN.OBJECT_NAME + ': ' + OAV.OBJECT_NAME   
    FROM HSP_MEMBER_TO_ATTRIBUTE M1
    INNER JOIN HSP_OBJECT OAN
        ON M1.ATTR_ID = OAN.OBJECT_ID AND
        M1.MEMBER_ID    = O.OBJECT_ID
    INNER JOIN HSP_OBJECT OAV
        ON M1.ATTR_MEM_ID = OAV.OBJECT_ID
    INNER JOIN HSP_MEMBER MB
        ON O.OBJECT_ID =  MB.MEMBER_ID
    FOR XML PATH ('')),1,1,'')), '') AS 'Attribute assignments'
FROM HSP_MEMBER M
INNER JOIN HSP_OBJECT O
     ON M.MEMBER_ID = O.OBJECT_ID
INNER JOIN HSP_OBJECT PO
     ON O.PARENT_ID = PO.OBJECT_ID
LEFT OUTER JOIN HSP_MEMBER_FORMULA F ON
    M.MEMBER_ID = F.MEMBER_ID
WHERE M.DIM_ID = 52305

Custom dimension output

This is too big again, so please go here to download it and see it in all of its glory.

Conclusion

I said I would get the Planning dimensions out in a month and this has just taken longer than I anticipated.  I do try to have a semblance of a life that includes not always sitting in front of a computer doing unbillable work.  

Having said that, we have made pretty good progress on the dimension front with:
Scenario
Account
Version
Segments (custom dimension)

That leaves:
Period
Year
Entity (the big one)

I will try to get those out as soon as possible and then I’m going to switch gears for a while, and focus on EPM and the cloud and some Amazon Web Services Stupid Tricks.

Friday, September 9, 2011

Stage 4 padania

It has been another great day for liquigas cannondale here at the tour of padania on stage 4 with an emphatic victory by our team caption, Ivan basso. Today was the only mt top finish so therefore was always going to shape the GC and it was Ivan who proved to be the strongest of the mountain goats. By virtue of his 52second victory he also takes the overall GC lead so we have the jersey to defend again for the second time this week and on the final stage 5 tomorrow as we head from trento to venice, the scenic way i am told.

For me it was a pretty quiet day, my role was to stay with ivan aslong as i could on the climbs but after the previous days on the front i was well aware i was not going to be climbing with the best of them today. Elia viviani showed his versitility and was present in the days breakaway and although it was swept up on the first of the 2 major climbs for the day elia survived in the front along with danial oss and myself to occompany Ivan to the base of the final climb. I made sure he had plenty of fresh fluids for the final climb and once it kicked up with just inside 10km to go my time at the front came to an end and Ivan was alone but fortunately in quite a small group and as he proved very capable of looking after himself. Soon after he shredded the field to just 5 and from there one by one they dropped off his wheel until he was alone for final 5km. I was aware he was infront when i hit 7km to go so started saving my biscuits for anticipating him taking the jersey and just after passing the 3km to go sign i was told of his victory so was a very enjoyable final part of the climb in anticpation of defending his lead tomorrow which i am pretty confident will require me to spend some more time on the front. So all in all was a great day, i would have loved to help him more in the final climb but after the previous days work on the front my climbing musles simply desserted me so i just had to contribute in any way i could and fortunately i was of some help. Best on groud was certainly elia for his ride in the break, survival in the front group till the final climb, winning the days intermediate sprint and extending his points jersey lead and doing all this after alread winning one stage and finishing 2nd in 2 others so definately hats off to him. Time for some rest, cant wait for the final stage tomorrow and finally getting the opportunity to defend the lead of my great friend, team mate and training partner mr Ivan Basso.

SRM data
Time 4hrs 45min
Speed 40kmph average
Power 264watt average
Altitude gain 2000m
Heart rate 147average
Energy burnt 4700kj

Cjw

Sent from my BlackBerry® wireless device

Popular Posts