Blog Pro de Jean-Baptiste HEREN

Notes d'un consultant Freelance en Informatique

To content | To menu | To search

Entries feed - Comments feed

Tag - Cognos


Cognos Report : Display a different measure in row for the aggregated column

Following tip is when you use a Relational Datamodel (DMR). In a Cognos Report crosstab, If You need to Display different measure in the aggregated column, you can do it using a simple if-then-else...

Continue reading

Cognos 8 - convert a member unique name from one hierarchy to another

If you need to build any report or Event studio Query using the same data from different packages; and you want to prompt just once. You can convert the member unique name from one hierarchy to...

Continue reading

Extract Cognos reports & packages list with path

When you want to make a documentation on Cognos (or anything), it's hard to keep it updated... One of my recent projects has been to buid an automatic documentation on Cognos, showing dependencies...

Continue reading

Cognos Report Studio : position d'un membre dans une hierarchie

L'expression suivante renvoie niveau de profondeur du membre spécifié dans une hiérarchie. [script] ordinal (level(currentMember([My_Package].[My_Dimension].[My_Hierarchy])))...

Continue reading

Cognos 8 Macro functions list

We have seen that cognos macro functions available in framework manager are also available in report studio. Here is a simple list of existing Cognos Macro with description. This list contains...

Continue reading

Cognos 8 Report Studio's Conditional block

Conditional blocks allow you to add multiple reports to one page. By defining multiple zones, for example, you can coose between a Synthesis and a detailed table. To make use of conditional blocks,...

Continue reading

Last period prompt option in Cognos report Studio

When you build a new report with some prompts, including a time dimension; you may want to add an option to automatically select the last Period. this way users can : see their last data without...

Continue reading

setup cognos to work with OLAP MSAS cubes security

Usually, when we create a data source in Cognos, it is easier to specify a connection using Cognos Service Credentials. This means that all connections to the data source are done using the Cognos...

Continue reading


Row Level security in MSAS

Security implementation in Analysis Services In some cases, companies want to give different level of access to strategic data, depending on user’s profiles. Analysis services gives us ability to...

Continue reading



Jean-Baptiste HEREN, né le 25 Juillet 1977. Curriculum en pdf : Version française | English version | Expérience Projet Titre & fonction Consultant Indépendant Data Architect / ERP / Décisionnel /...

Continue reading