Groupings: A New Module Created for the IBM Cognos Space
Posted by Corey Mendelsohn on October 16,2022
Home - Blog - Groupings: A New Module Created for the IBM Cognos Space
Corey Mendelsohn, President at NewIntelligence recently noticed a manual task in the reporting activities of one of his clients, and after considering how time consuming it was, sought out a creative solution to change their reporting and dashboarding into a simple automated grouping capability within the IBM Cognos space that would save them time, effort, and even reduce their workload.
The need: A client wanted to analyze the activities of Sales Managers and the assigned Sales Agents that reported to them. They also needed to analyze the Territories related to their multiple office locations.
The problem: Because there were often updates, changes and job reassignments in the business, multiple areas of the reporting process were affected whenever an updated needed to be submitted. A person would have to remember all the reports and/or places that needed to be updated since the reports were not in sync with one another. It was therefore easy to accidentally overlook where an update needed to be made, which resulted in errors in the way information was organized on the final reports.
The solution: NewIntelligence created an automated solution for data that was grouped together, referred to as ‘Groupings’, where the above fields that were often fluctuating would be added into one manageable excel sheet, that once updated, would automatically update all relevant reports in the Cognos space based on the predefined Groupings.
Corey Mendelsohn shares what lead to the vital update in the Cognos space during a conversation with one of his clients in the Transportation industry after a report was not correctly showing the required information.
Limitations of Groupings in the Cognos Space
A lot of reporting systems have the ability to correlate certain fields to a certain degree, but they may not necessarily have the concept that you and I have in the way those fields relate to one another. For example, how a sales manager relates to a sales agent, or territory – we can easily grasp how these groups interact with one another to hold a business together, but it is simply not within the capacity of most operational systems. This means if a company wants to create a report on these, the majority of steps are taken manually.
When the client was limited to the manual functionality of the groupings, NewIntelligence came in to find a solution using our suggested grouping capability that would help automate their data and reports.
We created an Excel spreadsheet leveraged by Cognos, which allowed the client to manage the particular grouping as needed. Once ready, Cognos pulled the data automatically.
So when a salesperson is reassigned, this client can then go into the Excel spreadsheet and add the new record with the relevant grouping. They can organise the grouping hierarchy as they see fit and no longer have to worry about the report being out of sync.
Every single report from here on in is going to get modified and updated automatically.
Any one who makes these updates can freely interact in the Cognos environment and build their reports the way they want to with more simplicity and ease.
Sample of Grouping Displays (IBM Cognos & Excel)
Testimonial from our client
When asked how the creation of the groupings has affected their experience working in the Cognos environment, the Business Intelligence Analyst shared with us the following:
The creation of the groupings has been great because it enables me to see which sales agent belongs to which territory and also prevents missing a sales rep in any report. It made reporting easier because I’m finally able to filter on the territory group instead of manually hardcoding the names in the filter criteria. Overall, it has saved me a lot of time.
At NewIntelligence we like to come up with creative solutions when any of our clients face a particular challenge, especially in the reduction of manual work. Automation and removing redundancy are key in the way we do business. The recent client challenge provided insight into the ways some of our clients work and the extra steps they were taking. Once we understood what was holding them back, we were able to quickly adjust their processes.
If you have a hierarchal grouping that you would like to setup into a similar automated capacity, contact NewIntelligence, and we will get you started.
Get the latest Business Intelligence news and views here.view all blog posts
”NewIntelligence (NI) has been a joy to work with."
”NewIntelligence (NI) has been a joy to work with. We were initially concerned that we would not be able to fully use QuickStart as we don’t have an in house IT department. NI showed us how easy it is to use Quickstart and they continue to promptly support us if we have any questions.”
VP Sales & Marketing, Thai United Food Trading Ltd.
”The support we have received from them before and after implementation has been phenomenal."
”As CFO at New West Oil, I selected NewIntelligence as the product of choice for helping to get data out of our SAP B1 database in a more user-friendly and meaningful way. Corey Mendelsohn helped guide us through the process in a very structured way, without pressure, but always with great follow-up and thoroughness. ”
CFO, New West Oil Company LLC
”It is a pleasure to work with Corey and experience his professionalism to ensure we expand our knowledge."
”We are currently working with Corey, expanding our use of the NewIntelligence tools and excellent Customer Service to ensure his solution fits our needs. It is a pleasure to work with Corey and experience his professionalism to ensure we expand our knowledge and find new ways to extract information from SAP B1”
VP Operations & Administration, Trux Accessories
”We highly recommend the NI SAP B1 QuickStart for Reporting and Dashboarding Solution."
”Working with NewIntelligence as our IBM Cognos partner has been a great experience. They are extremely knowledgeable, and their customer service is outstanding. The implementation phase went very smoothly, and they have since remained available, even reaching out to us regularly to see how we are doing with the tool. They have continued to patiently support us and help us evolve within the Cognos tool.”
Director of Finance, Fischer Technology, Inc.
”We see a good partnership where NewIntelligence will help us meet those challenges and empower Arani’s team to access good data."
”NewIntelligence listened to our issues and built a solution that met our needs with the ability to add more users and functionality as we grow. We see a good partnership where NewIntelligence will help us meet those challenges and empower Arani’s team to access good data.”
VP Operations & Supply Chain, Arani
”Very professional and much appreciated."
”Following the IBM Cognos training the main user was very pleased with the sessions. The trainer knew the solution well and the training format allowed flexibility for real life questions… they even used our existing data to demonstrate functionality!! So in general, it was very professional and much appreciated.”
Manager, IT PMO, Domtar
”Their promises have been fulfilled 110%."
”I would like to take this opportunity to thank the NewIntelligence team for having completed the mandate of implementation of their Cognos solution. Their promises have been fulfilled 110%. Following last week’s training, the excitement is at its peak and our people are looking forward to make use of the solution on a daily basis. A big thank you to all of you!”
VP Finance, Regal Confections Inc.
”The experts at NewIntelligence have understood our challenges and guided us very well in our project."
”Since the beginning of our partnership with NewIntelligence, we restructured our cubes, had numerous training and, recently, a major migration. We are very happy with our IBM Cognos 10 release. Our users love the new Workspace tools and they would never go back to the old version for the world.”
Vice President IT, CDMV Inc.