Translate

Master-Detail Relationship in Cognos Report Studio

1. Create a List report with just one column Product Line


2. Unlock the Lock Symbol --> Insert another List inside the List Column cell --> Associate this List to Query1

 


3. Now, insert Product Type, Product Name and Revenue columns as shown below


4. Right-Click on List2 and select Master Detail Relationships

 
5. Create a link between Product Line columns as shown below

               
6. Apply formatting as shown below

 

7. Select List Column Title --> select Box Type as None



 

8. Run the report --> You will see the report output like a section created on Product Line 


3 comments:

Unknown said...

The article was very clear and it's usefull information Cognos Tm1 Online Training Hyderabad

Naz said...

Hello
I would like to know in cognos 11 the how to the ranking for a columns
eg:

percent value rank
0.968 50
0.967 49
0.966 48
0.965 47
0.964 46
0.643 upto 1

please help much appriciated

Keerthi55 said...

P0wer bi onlinetraining
P0wer bi training