http://blog.wherescape.com This is where we talk about things related to data warehousing, WhereScape RED and anything else that come along. Thu, 04 Sep 2008 03:01:20 +0000 http://backend.userland.com/rss092 en We have just started working with IBM, and I have to say what a pleasurable experience it has been. A big thanks to Boris, Laura, Ceyhan and their team for all their assistance.  We are now in the IBM Global Services Directory, the IBM developerWorks wiki and have been validated with ... http://blog.wherescape.com/corporate/big-ups-to-ibm/ Morgo is a two day conference for hi tech entrepreneurs from New Zealand held in the picturesque Bay of Islands.  The official theme this year was “Partnering for Success” but some of the strongest presentations were on giving back rather than partnering. Selwyn Pellet, on the board of AIM listed Endace and now with ... http://blog.wherescape.com/corporate/live-from-morgo/ RED operates with dimension types that are recognized by modern data warehouse theory. When a developer starts working on dimension tables he gets to chose from four options for the default generation of the dimension table and its update procedure via the following dialog box:   A Normal Dimension is where ... http://blog.wherescape.com/technology/dimension-types-what-are-the-different-dimension-types-and-how-they-are-implemented-in-wherescape-red/ I'm soaking up sunshine on the terrace outside the annual TDWI World Conference in San Diego.   Pelicans are diving into the harbor just a few yards away.  Must remember to add tube of expensive French sunblock to expense report.  This is a great town for a conference.  Sales Veep Mark Budzinski and I ... http://blog.wherescape.com/corporate/live-from-tdwi-2008-in-san-diego/ Join CIBER, WhereScape, and Strategy Companion for a complimentary one-hour webinar to learn how you can launch a business intelligence / data warehouse initiative without an overwhelming investment in time, tools, and technologists. The webinar will take place on Wednesday 10th September Noon Eastern / 9.00am Pacific Time.   Registration is free and ... http://blog.wherescape.com/corporate/simpler-faster-business-intelligence-webinar/ When your software enables rapid building, eases change and simplifies management, one of the really nice things is that the cost for our customers of building and maintaining  data warehouses comes tumbling down.  While this is good for everyone in this economy, it is especially valuable in the mid and ... http://blog.wherescape.com/corporate/bi-on-a-shoestring/ It is coming up to conference season again, and WhereScape will be participating in a number of events around the world in the next couple of months.  You can catch us at: - 9th Annual Business Intelligence Conference July 24-25th in Sydney, Australia.  This will feature a case study (Data Warehousing ... http://blog.wherescape.com/corporate/out-and-about/ Our thanks to Rosalie and Yohan at ASB Bank for the great case study on their Human Resources data mart.  It was the sort of project our guys really enjoy working on, with committed and involved users.  When you are doing a prototype based build engagement is the critical factor.  It can be used ... http://blog.wherescape.com/corporate/thanks-to-asb-bank-for-a-great-case-study/ I recently came across a useful Excel macro that calculates NZ holidays - I have adapted it to generate SQL to update our date dimension.  Feel free to contact us on support if you would like a copy. http://blog.wherescape.com/corporate/nz-holidays-calculator/ Every action in the information database and warehouse in particular has a consequence. Database developers, business analysts and DBAs  feel agonizing pain when an organization makes changes to their data warehouse applications without having complete insight into the true impact and cost that a modification will have. So, what is an ... http://blog.wherescape.com/technology/impact-analysis-what-can-fizzle-while-applying-changes-on-the-database-and-how-to-sustain-a-healthy-evolving-data-warehouse/