Posts

Showing posts from 2014

LLS Light The Night Walk, Norwalk CT, 10/24/2014

This year I am participating in the LLS Light the Night Walk in Norwalk, CT to raise money and awareness for the Leukemia and Lymphoma Society. I am the captain of my corporate team.  We have committed to raising $5,000, and I personally have committed to raising $2,000 of that amount. LLS is an amazing organization working for an extremely worthy cause.  Would you please consider supporting me by making a donation at  http://pages.lightthenight.org/ctwhv/Norwalk14/gcrisci Thank you for your support! Gary Crisci

ODTUG Board Nomination

I would like to announce that I am running for the ODTUG Board of Directors.  I submitted my nomination this past weekend and I am hopeful I will gain enough votes to be elected to the board. Below is my campaign statement and Bio. Voting opens October 7 - October 28 for ODTUG members with a full membership. I hope you will please vote for me. Thank you. Campaign Statement: I have been involved with ODTUG since June 2008.    That year I knew ODTUG was special and my career has never been the same as a result of my involvement.   I would like to continue giving back by becoming a member of the ODTUG BOD. I have had amazing opportunities working with ODTUG.   I was the president of the ODTUG Hyperion SIG, Vendor lead for KScope12/13, and this year I am the business content lead.   In the years I have been involved with ODTUG I have tried to promote the growth and well being of the organization.   I was instrumental as...

MDX queries to get Parent/Child and Gen/Lev format (sort of)

I recently stumbled across some interesting MDX functionality.  Unfortunately I have to put the disclaimer right off the bat that sadly this feature may not be of much use given the very poor format of the output, nonetheless this is an interesting way to go about extracting this data and if the user has no other method available to them, it might be helpful.  Perhaps someday Oracle will provide a better facility for formating MDX output and for those of you using MDX behind the scenes to feed a custom app, this should be right up your ally. The feature I am referring to is the MDX Property Expression.  Basically what this function does is allow you to pull onto your result axis DIMENSION properties for the members you are returning.  The options for what you pull can be quite robust if you structure properly. So for starters let's say you wanted to query a dimension and return parent child members You could run the following query:  SELECT {} ON AXIS(0)...