Even if IBM Cognos Workspace Advanced (WSA) has greater flexibility than the older IBM Cognos Query Studio tool, they work in different ways and the transition from one tool to the other represents somewhat of a learning curve.  Following are the steps to create an advanced combined filter in WSA. Exercise Objective: Using the package Go Sales (query), create a filter on the Sales that match the condition below: (Year from 2005 to...

Having a BI system in an organization is among the top priorities for executives.  It has become an essential element in gaining a competitive advantage in a furiously fast-paced market.  However, no BI system can run itself and there is always going to be some upkeep necessary.  Whether this is due to changing requirements, upgrades & optimization, a maturing or expanding BI community, your BI environment can become increasingly...

In summer 2014, IBM announced changes in the IBM Cognos User Roles and Definitions.  This new licensing model has made it easier for users to access Cognos 10 capabilities, such as Cognos Workspace, Active Report and Mobile. Cognos customers had their user roles automatically migrated to one of three simplified roles with increased functionality, with the exception of the Consumer license role, which remains unchanged. You can give...

Advanced analytics are becoming more common in the business world. In order to make the most of these analytics, it is necessary to tell a clear, concise story incorporating analysis to influence critical decisions. A data analytics story is a story that includes more than just analytical facts; it weaves together pieces of analysis in a narrative that will push people to action. How to Tell an Effective Data Story An effective data...

Companies today know that data is a highly valuable asset, and they are becoming increasingly effective at handling data. The value of data comes from a variety of factors, including the ease with which it can be accessed. Data’s core value, however, comes from its use. The same data may have different value to two different institutions, even two in the same industry, depending on how they can use it. If one organization can use...

Increasingly, more businesses are utilising data to improve their sales, market share, and profits. Data used in this way is called business intelligence, and it can give your small business a competitive edge. There are a number of aspects of business intelligence you should be aware of that you can use to build your business. Our list below covers five recent trends in business intelligence that may be relevant to your business....