Instructional Videos2017-03-23T00:40:34-04:00

Free Youtube Course on Building IBM Clarity7 Reports

By |May 13th, 2015|

Building reports in ClarityStudio can be a bit challenging without some guidance. To help new folks along, we have developed a series of Youtube videos to walk you through the process of developing a complex report. This particular report that we build together is a validation report to compare two cubes. This is a very important part of any testing phase of a project. This gives us the visibility into the system to question any number in the cube, and reconcile it back to a source system. Instead of having to ask a DBA to verify numbers, the Finance team can [...]

Archiving – How to improve performance by archiving old (Scenario,Year) combinations – IBM Clarity

By |February 11th, 2015|

Any database application should be able to deal with data growth. As an application is used, data is created and evolves. With a corporate performance management tool, data can nicely sliced by a (Scenario, Year) combination. For example (Actual, 2004) would be the actual transactions that happened in 2004. (Budget, 2006) would be the approved budget for 2006). If a system has been in use for 5 years and each year is focused on building only a 1-year plan, 80% of the data is static. Many administrators do not know that, in most cases, all active data is reprocessed each night. [...]