Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: GeethaKL on 27 Jul 2016 10:25:26 PM

Title: Top 10 Funds with the best Termination Reason
Post by: GeethaKL on 27 Jul 2016 10:25:26 PM
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
Title: Re: Top 10 Funds with the best Termination Reason
Post by: raj_aries81 on 28 Jul 2016 06:17:17 PM
Quote from: GeethaKL on 27 Jul 2016 10:25:26 PM
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
Text only | Text with Images