Tag Archives: BI

Cognos Analytics for rapid creation of Professional Reports

Learn how to create Professional Reports quickly using the new guided user experience in Cognos Analytics. Learn more about Cognos Analytics http://ibm.co/cognosanalytics

New Extensible Visualizations in IBM Cognos

This video is walks the user through the new extensible visualizations that are now available.

Self-Service Business Intelligence is Becoming Reality: Intro to Power BI

The first step for using Microsoft BI

If you have Microsoft Excel 2013, Never used Microsoft BI tools, Then this post will guide you in the first steps how to install.

What the Microsoft BI tools do and what they are used for.

What license agreement is required

Self-Service Business Intelligence is Becoming Reality: Intro to Power BI

IBM Cognos Insight – the Learning Series (Part II)

Part II from the post  Ask The Expert Series – What’s New In Ibm Cognos Insight, So some more  amazing Cognos Insight functionality

Part 1  (if you missed the older post) 

IBM Cognos Insight is a personal analytics solution that empowers users to independently explore, analyze, visualize and share data without relying on IT for assistance. In minutes, analysts and line-of-business managers can create and share custom applications, dashboards and visualizations to help

Tableau Software vs. Microsoft Power BI

Nice Blog post by Andrew Crouse from Piraeus consulting 

Read full Blog Post:


Or just read the sumary Bottom Line

PowerBI is best used for simple data visualizations or for Scorecards and Dashboards that will not change significantly over time. PowerBI, and the Q/A feature specifically, can be very valuable for users who are not interested in diving into data sets, but who are looking for specific analytics, quickly. Another benefit to PowerBI is the value add of Microsoft Suite in the purchase, making it a great value for businesses working with a smaller budget.

Tableau is a much faster and more flexible tool that works best for deeper analytics and enterprise dashboard solutions. The flexibility available for creating a wide variety of dashboards makes Tableau the optimal choice for business that need quick results from reporting and analysis. Tableau also offers customizable geo-mapping, background images and polygon maps for visualizing unordinary data models. Tableau would be most useful to analysts and organizations that require fast adaptation to changes in their business, and have multiple users who need constant access to this data.

Off course, the best BI work will be done by professionals who utilize PowerBI and Tableau in conjunction with one another, allowing each to lend its particular strengths to the specific needs of each challenge.


IBM Cognos Insight – LodestarSolution clip, What is new Cognos Insight 10.2.2

There are some issues with the sound however great clip for IBM Cognos insight  users who wish to upgrade Or join a great product

Ask the Expert Series – What’s New in IBM Cognos Insight

Ask the Expert Series – What’s New in IBM Cognos Insight

Chart axis and tooltip localization for custom data items in IBM Cognos Report Studio

This tip provides generic steps to make chart axis titles and tooltips to support localization when custom data items are used to design it.

When a custom data item or in other words data items created at report level are used either in chart Measure or(and) Category section then a few additional settings needs to be done to make axis titles and tooltip information(hover mouse pointer on markers or bars) localized.

If the Framework model is translated in required languages then query items referred in reports will automatically support localization. But in cases where calculated data items are created at report level, then this article will help report authors to perform the required translation at report end to support localization.


IBM Cognos 10.2 and higher versions.


You should be an IBM Cognos report author or one with good knowledge on IBM Cognos Report Studio


The following steps will help to localize the chart axis title and tooltips when you have custom data items in the chart.

In this example, Returned items (query) namespace under Sales and marketing (query) folder of GO Data Warehouse (query) package is used.

The following steps are to be used for designing the report.

  1. Open IBM Cognos Report Studio and create a new chart report using the GO Date Warehouse (query) package.
  2. In this example use the Stacked Column chart with 3D effect chart type.
  3. In the Query Explorer select the chart query (Query 1). Drag Product line from Products query subject, Return quantity from Returned items fact query subject, Region and Retail country from Retailers query subject of the Returned items (query) namespace .

    ([go_data_warehouse].[Sales and Marketing (query)]. [Returned items (query)].[Products].[Product line])
    ([go_data_warehouse].[Sales and Marketing (query)]. [Returned items (query)].[Retailers].[Region])
    ([go_data_warehouse].[Sales and Marketing (query)]. [Returned items (query)].[Retailers].[Retailer country])
    ([go_data_warehouse].[Sales and Marketing (query)]. [Returned items (query)].[Returned items fact].[Return quantity])

  4. From the toolbox drag Data item to the Query Explorer window and name it as Area. Area is a concatenation of Region and Retailer country.

    Area —–> [Region]|| ‘ (‘ || [Retailer country] || ‘)’.

    Area is the custom data item created in this step.


  5. On the Page Explorer drag Return quantity to Default measure (y-axis) section, Area to Categories (x-axis) section and Product line toSeries section on the chart.


  6. When we execute this report for instance in French locale then only the data items which are directly used from a translated Framework Manager model are displayed in French whereas Area which is a custom data item is shown with default English language as its not localized yet at report level. Also, if we see the tooltip that also shows Area in English.


  7. In order to localize the axis title, create a Report Language Variable with the languages which will be supported by the report from Condition Explorer.


  8. Expand the Axis titles and select the x-axis. Set the Default Title property under General section to No. Double click on the axis title and rename it to Area.


  9. Select the language (French) from Conditional Explorer – Report Language1 then select the axis title. Chart text item should be shown in the property section.


  10. Using Text Variable property set Report Language1. Set Source Type property to Text and provide the translated string under Text property.


  11. By following above steps we can get the axis title localized but the tooltip would still show ‘Area’ not ‘Area_French’.


  12. Now to localize the tooltip as well, select the Chart Node Member and turn on the Custom Label property to Show.


  13. Select the custom label and then the language from Conditional explorer Report Language VariableChart text item should be shown in the Property section
  14. Using Text Variable property set Report Language1. Set Source Type property to Text and provide the translated string under Textproperty.


  15. When report is executed it will show both axis title and tooltip localized for custom data items.


  16. The same technique can be followed if custom data items are used in Measure (y axis) section.


Submitted by Kalyani Raut, IBM Software Lab, IBM Predictive Maintenance and Quality and Swamy ST, IBM Software Lab, IBM Predictive Maintenance and Quality

Original link : https://www-304.ibm.com/connections/blogs/basupportlink/entry/chart_axis_and_tooltip_localization_for_custom_data_items_in_ibm_cognos_report_studio?lang=en_us