BI | ARCHITECTURE | STRATEGY

Welcome Back!

In Uncategorized on May 19, 2010 at 9:56 am

Welcome back to my blog! After a long hiatus I am back to writing again, now with renewed vigor and a lot more real world experience in implementing one of the largest data warehouses and a big financial firm. Over the next few posts, I’ll outline some of the lessons learned, some new approaches and new ideas I have developed. For those who have kept in touch during these months, THANK YOU! And to those who have just landed on this blog, welcome!  Do drop in a line or a comment on any post you like, agree or not!

Many of you have requested I republish my earlier posts and I am happy to do so shortly.

Happy reading…

Security in an OBIEE implementation

In Business Intelligence on June 11, 2008 at 4:31 pm

Don’t make security of your OBIEE or, for that matter, any BI deployment, an afterthought. I did this presentation this week at an Oracle Users group. It illustrates ways to secure your OBIEE implementation to restrict access to users and ways to limit access to only the data they need (e.g. restrictions by cost center). It also explains how to integrate your OBIEE application with eBusiness Suite single sign-on and responsibilities. Further, if you are looking for an easy way to encrypt sensitive data in your warehouse (like social security numbers or credit card numbers), you will find clues on how to do this without virtually writing any code.

Remember the AAMIE of security – Authentication, Authorization, Monitoring, Integration, Encryption.

Download the presentation OBIEE-Secured!

 

The Human Resources Data Mart

In Business Intelligence on March 5, 2008 at 2:46 pm

The recession is here…

And the cost cutting season has begun. We know the drill: across the board budget cuts, new projects delayed, the organization chart de-layered, voluntary retirement packages and, of course, reduction in force and severance packages.

This is not just an exercise in reigning in escalating costs. The more agile organizations also take such opportunities to align their corporate workforce to the new realities of their business and acquire new employees with the skills that are more suited to their  core competencies and evolving business focus.

This brings into focus the need to retrieve and analyze information about employee performance, learning, compensation, benefits, payroll, time management, and recruiting. As with most modules, there are plenty of pre-built HR Analytic applications like Oracle Daily Hr Intelligence, Oracle BI Applications (Siebel Analytics) – HR Analytic module, Cognos Performance Applications, Business Objects HR Analytic Application, to name the leading few. However, more often than not, you will find that these applications work very well if you haven’t customized your HR application (be it Oracle HRMS or SAP R/3 HR module). They will lack some of the most critical information of your business that you have carefully stored in the customizations of the ERP application as I am experiencing while analyzing an Oracle HRMS implementation at one of my clients. After careful evaluation and cost-benefit analyses, we decided to build a custom data mart, rather than buying a pre-built BI application from Oracle or BO. I will focus this series on building the HR data mart from Oracle eBusiness Suite, based on this recent experience.

Building a HR data mart is considerably more difficult than building other common data marts like a Sales data mart or Finance data mart. 

Follow

Get every new post delivered to your Inbox.