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

result_crosstab.png

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

Monday 30 January 2012, 19:43

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

Wednesday 06 April 2011, 15:45

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

Monday 28 March 2011, 22:33 1

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

Wednesday 03 November 2010, 18:02

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

Friday 13 November 2009, 11:24

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

Thursday 12 November 2009, 16:51

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

Tuesday 10 November 2009, 20:42

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

Wednesday 26 August 2009, 20:38

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

[image:Use_Case]

Row Level security in MSAS

Wednesday 26 August 2009, 07:11

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

jbcorporate.JPG

Curriculum

Wednesday 23 January 2008, 15:19

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