Friday, August 30, 2013

IBM Cognos Report Studio : Using CSS Classes to Manage Report Formatting

Source:http://www.ironsidegroup.com/

Managing Risk with IBM’s GRC Business Analytics Solutions

Source:http://www.ironsidegroup.com/
In a world of ever changing government and industry regulations, many organizations are having a challenging experience efficiently meeting compliance requirements. Additionally, as the economy continues to sputter, organizations are exploring new ways to reduce loss, improve decision making around resource allocation, and optimize their business processes. With the latest release of IBM’s Governance, Risk & Compliance (GRC) solutions, which includes: OpenPages and Algorithmics, meeting these requirements and beginning to improve processes internally can become seamless. The painful, long drawn out process of managing market, credit and liquidity risk can soon become an efficient exercise. Integrating your current reporting technologies (IBM or not) will help your organization gain greater risk visibility and be ready for any challenges.

IBM OpenPages Software

Currently, IBM OpenPages offers specific GRC solutions for several highly regulated industries including banking, utilities/energy, insurance, and pharmaceuticals/healthcare. OpenPages is designed to enable C-level leadership to take a proactive approach to managing risk. These prebuilt solutions provide reporting, analytics and document management capabilities that address Key Risk Indicators (KRIs), Issue Management, and Loss Event Management. By leveraging Cognos as the reporting backend, users experience best-in-breed reporting technology with complete intractability including drill down, drill up, dash-boarding and mobile integration. Most importantly, OpenPages will integrate directly with your reporting tools in most cases.

IBM Algorithmics Software

Within the financial industries, identifying credit and market risk proactively will ensure that all organizations are able to identify the strongest opportunities for profit, as well as the largest areas of risk or loss. By utilizing Algorithmics, asset management firms are able to run simulations to learn what risk is present in any investment, in many different markets. Additionally, Algorithmics has an automated data management system that enables users to directly reduce operational risks. Algorithmics also offers a web-based reporting front-end that can also tightly integrate directly with other reporting tools and source systems.

TM1 Cell-level Security, Custom Security Cubes and Rules

Introducing IBM Cognos Disclosure Management

Source:http://www.ironsidegroup.com/

IBM Cognos TM1 – Freezing Old Data

Source:http://www.ironsidegroup.com/

Many TM1 users have cubes with rules associated with historical data or completed plan versions and are needlessly recalculating their data on a continuous basis. This creates an unnecessary performance drain, and to make matters worse, what happens when the business rules change? Do you change history? Do you make rules overly complex by adding a time or version component to all of your rules? Using a few simple steps, this data could be “frozen” or made static, resulting in faster response time, less RAM consumption, and alleviating issues when business rules change. In this article, we will explain how to go about freezing this data.
The first step is to identify the dimension(s) that we will use to determine what data we need to freeze. It could be one dimension or the intersection of multiple dimensions, such as freezing certain months for certain versions. For this example, we will use the “Version” dimension. This dimension contains Actuals, Budgets, and various plans. You will need to create a simple numeric attribute that identifies the elements as active or inactive. We will call this attribute “Inactive” and set the inactive value to 1; this will indicate the value should be frozen.


Next, any rule files for any cubes that should be frozen will need to be updated with a line to exclude any “Version” elements that have an inactive flag value of 1. Just be aware, you may want to leave some rules active, such as rules to overwrite consolidations for items like headcount, or percentages. Simply put these rules above the line to exclude elements with the flag.
[]=N:if(attrn(‘version’,!version,’inactive’)=1,STET,CONTINUE);
The next and final step has several components. A TI process will need to be written to export the frozen values to a flat file. This process should include all rule calculated values, but should exclude consolidated elements. Next, the process should set the attribute value to 1. If the data to be frozen spans multiple cubes, simply add multiple exports to the same process, but create one file per cube.



Finally, a second process will need to be created to reload the values from the flat file into the cube from which they were exported. Again, if the data spans multiple cubes, create one process per cube and use the unique files created in each process above. It is possible to use one process to load from multiple cubes, but this makes the TI processes more difficult to create.


These formally calculated values will not show as inputtable non-calculated values. Just be aware trace calculation will no longer function, removing the audit trail of how the value was derived.
Before:

After:

To ensure maximum performance gain, conditional feeders should be used to exclude the frozen value from being fed by the rule file. Even if the conditional feeders are in place, the memory will remain consumed until the server is restarted or the cube in question is unloaded and reloaded.
=>DB(‘Income Statement’,!Account,!currency,!Market,!Period,if(attrn(‘version’,!version,’inactive’)=1,’ ‘,!Version),!Measure);
If you would ever like to reactivate a version, simply reset the flag back to zero, reprocess the feeders, and the value will be recalculated based on the current rules in place. The trace calculation functionality will also now be enabled. If the rules have changed, the calculated values could differ from the previously frozen values

Introduction to Predictive Modeling

Source:http://www.ironsidegroup.com/

IBM Netezza: The Importance of Data Distribution for Optimal Performance

Source:http://www.ironsidegroup.com/

What’s New in IBM Cognos 10.2

Source:http://www.ironsidegroup.com/

Cognos Insight, Rapid Prototyping on Your Desktop