Managing External Data in Cognos Workspace Advanced

Workflow

IBM Cognos Workspace Advanced and IBM Cognos Report Studio allow you to integrate external data directly into your reports. This allows you to create a report using an external source that contains data which is not part of your IBM Cognos Business Intelligence enterprise data. You can import your own data file and start reporting [...]

Quickly Secure PowerPlay Cubes with Custom Group Security by Using MDL Scripting

MDL Language

Introduction When faced with the challenge of creating and securing custom views in Transformer models (and their resultant PowerPlay cubes), one can easily perform the necessary steps via the Transformer GUI. However, when the number of custom views to be created and secured is large, it often makes sense to perform this task by using [...]

Embed Google Maps in IBM Cognos Reports

101811_0049_EmbedGoogle1.png

IBM Cognos has a built-in map functionality that provides great visualization. With multiple layers on each map you can display data at different levels and even create drill throughs to other reports. It is a nice feature to visually present your data. However, everything has its limitations. There are some rich map features that IBM [...]

IBM Cognos and JavaScript – Part II

092711_1142_IBMCognosan1.png

In the previous JavaScript article, we spent some time learning about JavaScript and web page basics. We completed a couple of simple examples on how to insert JavaScript into an IBM Cognos report in Report Studio. Today let’s continue our journey. Note: All information and examples are specifically designed for IBM Cognos 10 Report Studio [...]

Database Structure in IBM Cognos Warehouses

092711_1136_DatabaseStr1.png

A Cognos report is only as good as its data. How that data is organized will affect performance, accuracy, and ease of authoring. There is no single solution — before you get can your data right, you need to know how it is going to be used. Know Your Requirements In an ideal world, databases [...]