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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
A common question we receive is, "How can I get help from IBM on Clarity or TM1?...and what do they cover?". Companies current on their support contracts with IBM are entitled to support from them. The support is limited to making sure the base product works as expected. It does not include any custom development, [...]
The IBM website can be a bit intimidating due to the size and quantity of products they support. How can we find documentation for our specific version of Clarity? Here are some steps to find the documentation for your version of Clarity. Some versions do not have full documentation. In that case, please try to [...]
Line Item Detail is a powerful feature, but not often used in Clarity. Line Item Detail allows users to enter detail below the lowest grain of the cube. The most common use is for budget planning. Most cubes have an Account dimension that matches their chart of accounts. Some users may know that they have [...]
What If Modelling is a great feature of Clarity. The challenge for this is in the setup of the tool. Each cube is different. Each team has a different type of modeling they want to do. At a high level, what if modeling enables power users to copy a (scenario, year) combination into another (scenario, [...]
