Top 10 Funds with the best Termination Reason

[GeethaKL]

Hi All
I am working in a Cognos dimensional Modelling  Dashboard from SSIS cube where in I have to show Top 10 Funds  with the best termination Reason both in a list report and visualisation Chart

The List report should show Top 10 Funds with best Termination Reason
Data Items     1. Fund Names 
                     2. Termination Reason
                     3.Termination Actuals
                     4.Termination Actual %
     


Relationship: Fund  -- Termination Reason (1:n)

Please let me know how to accomplish this

Regards
Geetha

[raj_aries81]

Hi All
I am working in a Cognos dimensional Modelling  Dashboard from SSIS cube where in I have to show Top 10 Funds  with the best termination Reason both in a list report and visualisation Chart

The List report should show Top 10 Funds with best Termination Reason
Data Items     1. Fund Names 
                     2. Termination Reason
                     3.Termination Actuals
                     4.Termination Actual %
     


Relationship: Fund  -- Termination Reason (1:n)

Please let me know how to accomplish this

Regards
Geetha

Hi Geetha,

Can you try using topCount or topPercent in conjunction with any other functions as required.Below thread might be of some help -

http://www.cognoise.com/index.php?topic=8098.0

Regards
Raj