If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Pictorial Representation of a Pyramid in report studio

Started by gshilpa24, 29 Sep 2010 01:21:14 AM

Previous topic - Next topic

gshilpa24

Hi,
I have a small requirement. Below is the description.
Its a kind of organisational structure .

Like we have CEO's ->BU Heads -> Managers -> Leads -> SSE's -> SE's etc.

My requirement is i need a pictorial representation when ever a manger logs in to the cognos portal.
Like , A is the name of the manager, and he has his team members.

                                 Count
Manager name (A)               1
Project Leads                      2
SSE + SE                           5
Graduate Trainee                 7

Its an hierarchy. Basically my report should show a pyramid structure.

I have an idea for this.

I can use a list report, drag two columns which has the names and the count, and embedd an HTML item and pass the output of this (count) as parameter into that html script , but i am anware of the html script.

If anybody knows how to write a script and pass the parameter plz let me know.

Or is there any other way to represent this pictorially as we don have in built charts in cognos.

Please provide your valuable thoughts as this is in priority,
Any help in this regard would be highly appreciated.

Thanks,