Main Blog 2017-03-25T04:04:50+00:00

3 Reasons Rolling Forecasts Can Drive Real ROI

By | August 22nd, 2017|

Today's business environment is moving at a lightning pace. Many businesses increasingly struggle to keep up. With the advent of big data, organizations are seeing a constant stream of information come their way. They're under pressure to respond quickly to market demands. Plus, these organizations want to become more agile decision makers. With so [...]

Mainstreaming Predictive Analytics For The Masses

By | April 3rd, 2017|

Whether your business makes medical supplies, or you run a multi-national accounting firm, predictive analytics is necessary. In order for every business, marketing professional and layperson to be able to use predictive analytics, it needs to readily available. However, before we explore why mainstreaming predictive analytics for the masses is important, we first must [...]

The Analytics Bottleneck: Make Your Data Easier And Quicker To Access

By | March 27th, 2017|

When it comes to big data and analytics, you should be able to access this information quickly without a hassle. Once data has been collected, it is translated into a user-friendly language creating materials that that are crucial to running a business. Big data and analytics serve to track key performance indicators, target new [...]

How To Use Analytics To Take Action For Your Business

By | March 20th, 2017|

Any adept business owner will tell you that in order for your business to thrive and maintain a competitive edge, you need to use analytics to your advantage. Analytics is the discovery and diagnosis of patterns found within data. These patterns are presented in a way that allows businesses to grow by predicting future [...]

TM1 Web – unable to select from Action Menu or SUBNM

By | March 16th, 2017|

Mozilla released Firefox web browser version 52.0 on March 7, 2017.  With this version, there appears to be a problem with some of the features in IBM Cognos TM1 Web.  Specifically, the Action Menu dropdown was no longer functioning.  Also, users were unable to select a specific element within a SUBNM dropdown object.  The [...]

How Big Data Analytics Can Help Businesses Learn And Grow

By | March 13th, 2017|

There is information out there that can help your business succeed. This information will give you insight into how consumers think, how to effectively manage your company, how to budget, how to plan, how to gain competitive advantages and most importantly, how to consistently generate revenue. In order to have this information at your [...]

What Is Big Data?

By | March 6th, 2017|

Data is information rendered into a form that is easily understood allowing it to be moved or processed. Although most of us are able to comprehend what data is, we may not know the difference between big and small data or how it applies to our business. What exactly is big data? Big data [...]

Alternatives To Excel That Are Better For Budgeting And Planning

By | February 27th, 2017|

Excel is spreadsheet technology created by Microsoft to accompany their Windows system. It features graphing tools, calculation, pivot tables and a macro programming language for pattern recognition and creation. Excel was developed by Microsoft, so it is more suited to computers and technology that is either made by or runs on Microsoft systems. However, [...]

Why Cognitive Computing Will Help You Get Your Job Done

By | February 20th, 2017|

Problem solving, forecasting and troubleshooting are three things that every business needs to have control over. Issues can crop up without notice and if you do not have the right resources in place to combat these problems, you risk slowing down your entire operation. With cognitive computing, these issues all but disappear. What is [...]

How To Streamline Your Budget Process & Planning With IBM Cognos TM1

By | February 13th, 2017|

As the economy shifts, it’s important for businesses to adapt. Through strategic planning, budgeting and analysis, we can aim for better business outcomes, regardless of the economic climate. We need to address performance gaps, forecast accordingly and ensure that our financial targets are connected through a dynamic solution. In order to do so, we [...]

IBM Planning Analytics Webinars

By | November 30th, 2016|

IBM Planning Analytics is a fast, easy, flexible and complete cloud planning solution that embeds powerful analytics into your everyday decision-making processes. Participate and see how you can retain the familiarity of Excel but gain so much more with the world’s Smartest Planning & Analytics solution ever! IBM Planning Analytics is built to support the largest of enterprises but priced for small and medium sized businesses so join us to find out how it will work for you.

Why CFOs should care about advanced analytics and cognitive computing?

By | November 30th, 2016|

Historically, the emphasis has been on leveraging trusted information to understand and communicate the state of the business (hindsight), and helping to anticipate where the business is going (foresight). That’s no longer enough. In light of today’s multi-faceted challenges, CFOs must help uncover hidden opportunities and risks. Over 80% of Finance teams expect to use [...]

IBM Planning Analytics Webinars

By | March 2nd, 2016|

IBM Planning Analytics is a fast, easy, flexible and complete cloud planning solution that embeds powerful analytics into your everyday decision-making processes. Participate and see how you can retain the familiarity of Excel but gain so much more with the world’s Smartest Planning & Analytics solution ever! IBM Planning Analytics is built to support the largest of enterprises but priced for small and medium sized businesses so join us to find out how it will work for you.

CPA Ontario’s Conference for Controllers 2016

By | February 28th, 2016|

CPA Ontario’s Conference for Controllers is designed for aspiring and current controllers. This year’s robust program will provide you with the opportunity to network, share ideas and gain the latest skills and knowledge relevant to controllership. Each topic and speaker will provide controllers an update on the newest information, requirements, emerging procedures and applications of controllership. The concurrent workshops will provide you with essential tools for informing decisions and driving improved results.

IBM Vision 2016 Conference

By | February 27th, 2016|

Vision is the premier global conference for finance, risk, and incentive compensation professionals. In three information-packed days, you can see how IBM® solutions help you drive profitable growth, manage risk – and optimize your performance. Vision 2016 will be held May 9 – 12, 2016 at the Hilton Bonnet Creek, Orlando, Florida.

Update your forecasts when you want to

By | November 26th, 2015|

Wouldn’t it be nice to be able to update your forecasts on a quarterly basis rather than annually?  Budgeting, planning and forecasting has typically been an annual process because of the time, effort and money involved.  Collecting data from multiple sources, consolidating it, checking it, refining it, checking the numbers again can definitely take weeks [...]

Business Analytics for the Office of Finance

By | November 25th, 2015|

The vast majority of CFO’s are now taking a more prominent role in decision-making, beyond the traditional role of finance.  The Office of Finance needs access to tools and best practices that allows them to be ready for the challenge.  These leaders need to know where their organization is headed.  They need to know [...]

The One National Conference 2015

By | September 9th, 2015|

September 28-29, 2015 Metro Toronto Convention Centre 222 Bremner Boulevard, Toronto, Ontario M5V 2T6 Jointly presented by CPA Canada and CPA Ontario, The One is the must-attend, multi-track event of the year. Clear Insight will be attending this event. Speakers: Dean McCann, Christopher Ragan, Curtis Zimmerman and Dr. Kimberley Amirault-Ryan.   EVENT DETAILS The One national conference is designed [...]

Leveraging IBM’s Watson Analytics Free Offer – Webinar

By | June 11th, 2015|

IBM Watson Analytics provides powerful automated data preparation, predictive analytics, reporting, dashboards, visualization and collaboration capabilities to address a business problem or seize a new opportunity. IBM customers can get Watson Professional Edition for free for 12 months. Unfortunately the vast majority of businesses will opt-in to the offer and just [...]

Clarity Support

By | June 7th, 2015|

Clear Insight has the experience; the professionals and the support systems to provide both emergency break fix and longer term strategic servicing and support for your IBM Clarity system.  Clear Insight has an excellent relationship at the executive levels in IBM and has the support and backing of IBM in order to service and resolve [...]

Migrating to IBM Cognos

By | June 7th, 2015|

There comes a time when it is necessary or desirable to move away from one software application in favour of another.  There are many good reasons for you to upgrade your current budget, planning and forecasting system in exchange for a more robust and comprehensive replacement.  Some of the reasons that our clients have made [...]

Speeding up Clarity with Analysis Services Compression

By | May 21st, 2015|

Overview Some Clarity implementations use Microsoft Analysis Services as the OLAP engine. For those implementations, there are some system settings we can enable to speed things up. These should only be enabled in a production environment. Development environments where objects are changing should not have any caching or compression enabled. Implementing Compression in Analysis [...]

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

CPA Ontario Spring Leadership Conference

By | March 31st, 2015|

June 18-19, 2015 Hilton Toronto Airport, 5875 Airport Road, Mississauga The CPA Ontario Spring Leadership Conference is the meeting place for some of Canada’s most innovative business and cultural leaders who are ready to share their recipes for success.  From inspirational speakers to technical workshops, this annual event provides essential tools and practical skills [...]

Virtualizating an IBM Clarity Server

By | March 12th, 2015|

Virtualize Clarity? Recently, I worked with a client whose IT department was going through the process of virtualizing physical servers into the cloud. For them, moving to the cloud would reduce their maintenance effort, and provide a safe off-site location for all their data. Their IBM Clarity servers were physical boxes located in their office [...]

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

IBM Clarity 7 Studio Template – 3 day Course

By | December 12th, 2014|

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

Restarting COM Objects

By | October 31st, 2014|

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 (Analysis Services) – How can I fix it?

By | October 21st, 2014|

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

Writing Advanced Snippets When Building Templates

By | December 20th, 2013|

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

Automated Regression Testing for Clarity and TM1

By | November 28th, 2013|

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

What is Hierarchy Security in IBM Clarity?

By | November 19th, 2013|

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

Suppressing the OnSave Warning

By | November 18th, 2013|

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

Super Fast Saves with Relational Writeback for IBM Clarity

By | October 16th, 2013|

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

Filtering by Measures in TM1

By | September 12th, 2013|

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

Updating Clarity Software For Free

By | September 12th, 2013|

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

Where is the documentation for my version of Clarity?

By | September 12th, 2013|

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 in Clarity

By | September 12th, 2013|

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 in Clarity

By | September 12th, 2013|

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