What Does This Do? Recently, a client was trying to figure out why a template wasn't working and it came down to just one checkbox, the Only Send Changed Rows checkbox. By default, this is checked when you start building a template, but what does it mean, and why do I care? If we are [...]
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 [...]
Instructor-Led Classroom Training & Workshops Education for the project team and user community is critical to the success of the project. We can provide education throughout the implementation process and beyond, ensuring people are trained just in time. Clear Insight is a licensed supplier and trainer for all your IBM training needs, including IBM Cognos [...]
If you ever ask IBM Support or a consultant for help with Clarity, they will probably ask you, "What version of Clarity are you using?". This is meant to be a simple question, but for folks that don't know how to find the version, it can be a bit confusing. Here are some simple ways [...]
Clarity uses Component Object Model (COM) objects to handle all the server-side operations. This includes querying, saving, configuring and more. For a variety of reasons, the COM objects can get confused. Often times, the system can go right back to normal if the COM objects are restarted. There are a couple of ways to do [...]
Versioning is a tool in Clarity enabling users to copy data from a set of source dimension elements to a set of target dimension elements. The most common implementation of it gives users a selection for a source (scenario, year) combination and a target (scenario, year) combination. The tool itself looks clear and straightforward, but [...]
With the release of Cognos TM1 10.2.2, there are a number of updates users should try out. Here is a quick look at some of the ones I recommend checking out. CAFE (Cognos Analysis For Excel) This tool has been around for a while, but has some noticeable improvements in this release. For anyone trying [...]
Both IBM Clarity and IBM Cognos TM1 support the MultiDimension eXpression (MDX) query language through snippets. Snippets are single MDX phrases that can be evaluated as part of an MDX query. At first glance, it can seem intimidating, but starting with a few key functions, it’s easier to start using it to put together advanced [...]
One of the best things about IBM Clarity7 and IBM Cognos TM1 is their flexibility and empowerment to build templates fast. This quick development time introduces a natural challenge... did we break something? Here are some examples of simple things that break old code. Common Challenges That Break Old Code Adding new children under [...]
Once you start building a TM1 solution, you'll quickly notice a lack of email components or tools... That's because there aren't any out of the box. Don't sweat it though. There are several good sites that describe how to use a VBscript file to send out an email. VBscript is fine and works well, but [...]
