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

Special sorting in list

Started by Kindness, 28 Feb 2011 06:05:23 AM

Previous topic - Next topic

Kindness

Hi.

I have a dimension with organizational structure, one prompt with organozational structure and fact table with 5 measures. I need to show 5 measures for each organization entity one level below the selected level, including selected organization.
for example, the output should be something like this:
------------------------------------------------------------------------
| <org>|measure 1|measure 1|measure 1|measure 1|measure 1|
------------------------------------------------------------------------
|org1.1|                |                |                |                |                |
------------------------------------------------------------------------
|..........|                |                |                |                |                |
------------------------------------------------------------------------
|org1.n|                |                |                |                |                |
------------------------------------------------------------------------
|org1   |                |                |                |                |                |
------------------------------------------------------------------------

There is requirement that all rganization entity one level below the selected level should be sorted descending by measure 1 and the selected organization should be exactly last record in the table.

Does anybody know how to do that?

thanks/