Oracle Virtualization and Cloud Consulting
view counter

Data Warehousing Feed

Oracle Data Warehousing, reporting, online analytics, and data mining resources, news, and support articles.

Free Introduction to Data Warehousing the Data Vault Way

My good friend Dan (@dlinstedt) has put together a sweet set of three videos to introduce everyone to the wonderful world of Data Vault. When you sign up you will get a set of email messages from Dan discussing the Data Vault Approach to data warehousing. You get access to three videos about the architecture, […]

Another Free Tip for SQL Developer Data Modeler (and a Challenge)

So here is another tip on using Oracle SQL Developer Data Modeler – but this time it is one I will NOT be showing during my session at #KScope13. In SDDM there is a really nice wizard for building views. Once your view is built, you should probably test it right? You could generate the […]

Investing to Improve Our Health

Great information this morning from @Claudia_Imhoff on Twitter: #BDA13 Investing to improve health, wellness and community vitality pays off for business and — Claudia Imhoff (@Claudia_Imhoff) June 6, 2013 Pay me now, or pay me later… It is amazing what impact an upfront investment can return over the longer term. And that applies in […]

The 1st Tip is Free: Oracle SQL Developer Data Modeler

This year’s ODTUG KScope conference is less than a month away and I am ready to get to New Orleans and meet up with all my friends and colleagues to talk shop and learn some new things. So in hopes of getting you to attend, I will share with you one of my productivity tips […]

Filtering Presentation Hierarchy Columns From Report Navigation

It has been awhile, I think a year now, since my last blog.  It has just been a very busy past year.  In any event, I came across a problem that involves presentation hierarchy columns.  The ever-beloved new feature of 11g , which all users and clients love to use for pretty much all reports.

The issue: How to create a navigational report which will filter the presentation hierarchy column based on the selected record from the calling report?  This is otherwise known as report navigation via action links.

Are you certifiable?

Just a quick note to let everyone know that Dan Linstedt, (inventor of the Data Vault Model and Methodology) has announced that he will be teaching a live Data Vault 2.0 Certification Class on July 29th in St Albans, Vermont. This class will cover all the new DV2.0 standards which incorporate big data, and NoSQL […]

A New Limerick to start your week…

This was an assignment my son did for his 3rd grade class. They were studying styles of poetry. This one he was proud of and asked me to publish for him. Enjoy. A New Limerick by Biaggio Graziano (copyright 2013 all rights reserved) Once there was a dog and a frog They live in a […]

Paralyze resistance…

Paralyze resistance with persistence. – Woody Hayes (College football coach) Resistance is futile – The Borg (Intergalactic marauders) Filed under: Quotes Tagged: persistence, quote, woody hayes

By failing to prepare

By failing to prepare, you are preparing to fail. - Benjamin Franklin Filed under: Quotes Tagged: Ben Franklin, benjamin franklin, leadership, quote

Another First at ODTUG’s #Kscope13

Those crazy kids at ODTUG have done it again! At this year’s KScope in New Orleans this user group is introducing an evening of crossover sessions. Over the years the event has grown and actually blended the traditional Oracle database development world with the world of EPM, Hyperion, and Essbase. In fact many folks who […]

view counter