Our Blog

Versioning (Analysis Services) – How can I fix it?

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 [...]

2017-03-22T18:39:16+00:00 October 21st, 2014|

Writing Advanced Snippets When Building Templates

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 [...]

2017-03-22T18:39:17+00:00 December 20th, 2013|

Automated Regression Testing for Clarity and TM1

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 [...]

2018-05-09T05:28:24+00:00 November 28th, 2013|

What is Hierarchy Security in IBM Clarity?

In IBM Clarity, hierarchy security is the security layer that controls who can see which dimension elements in a particular cube. Hierarchy security is just one component of the security profile. Here are some key definitions we need before discussing this further. Users - These are the individual users or logins for the Clarity application [...]

2017-03-22T18:39:17+00:00 November 19th, 2013|

Suppressing the OnSave Warning

When saving from a template, you may see the following error message: This program is attempting to save ....xml to your hard drive.Are you sure you want to save ....xml to your hard drive? While in development, this is slightly annoying. The simple workaround is to just click 'Yes' and move on. As [...]

2017-03-22T18:39:17+00:00 November 18th, 2013|

Super Fast Saves with Relational Writeback for IBM Clarity

When Is It Useful? Clarity is a budgeting and planning tool. As a budget deadline approaches, system usage skyrockets. Everyone has left their budget entry until the last possible moment. For that one day, when everyone is furiously trying to finish updating and approving their budgets, some systems grind to a half. Heavy save [...]

2018-05-09T07:02:26+00:00 October 16th, 2013|

Filtering by Measures in TM1

Overview When building applications on Cognos TM1, there is often a need to filter something by data in another cube for a user. In regular database applications, this would some form of a JOIN clause (INNER, LEFT OUTER, RIGHT OUTER). TM1 does not have those constructs, but not to worry. This can be done just [...]

2017-03-22T18:39:17+00:00 September 12th, 2013|

Updating Clarity Software For Free

Did you know that you are entitled to all Clarity software updates from IBM, as long as you are current on your maintenance contract?  Bug fixes and enhancements are released periodically as incremental updates. Many fixes improve stability and small annoying challenges for which folks commonly implement workarounds. At the time of this writing, the [...]

2017-03-22T18:39:17+00:00 September 12th, 2013|