Google
 

Monday, May 26, 2008

The Voodoo Lounge: ProClarity Madness

Some useful tips for deploying Proclarity.

ProClarity Madness

This past few weeks were practically devoted to working on ProClarity BI solutions. The near heart-stopping moments came while implementing structural changes to the Time dimension and during the solution migration to the production server.

Implementing structural changes for OLAP cubes is straight-forward. The difficulties arise when we already have a lot of BI content (reports and analytics) created and almost all of them uses the Time dimension. With ProClarity, it can potentially disable all reports and analytics. Even with running the Missing Data Wizard will not be enough, as ProClarity Shared Items such as Dynamic Sets and KPI uses the Time dimension as well. The strategy that we used to resolve such change was:

The Voodoo Lounge: ProClarity Madness

No comments: