COGNOiSe.com - The IBM Cognos Community

I have a report that I need to complete. It has project name, project manager, hours worked and quote rate. Quote Rate is from a custom dynamic application. When I run the report, it's picking the right quote rates for different category of workers in the projects. The problem is Cognos is adding all the values. Instead of giving me a rate quote, for example Engineer, of $60 per hour, its adding all the rate for all the rate categories for that project. I am using directoryuserID in join queries. Any suggestion? Aggregate function and Rollup Aggregrate function is set to None for quote rate column.

To the extent that I can guess what you're trying say, I would wonder if checking the usage might be in order.   I would not be surprised if you would want the setting to be attribute.

I'm a little uncertain about what you mean here.   Could you explain a bit more please.

QuoteInstead of giving me a rate quote, for example Engineer, of $60 per hour, its adding all the rate for all the rate categories for that project.

Do you mean your data is sort of like this:
project      job class                                 rate   hour   cost
1   Engineer                                            60           1           60
1   Electrical stuff guy                             30           2           60
1   Banging bits of metal together guy         25   4        100
2   Engineer                                                60   2          120           
2   Electrical stuff guy                                  30   3          90
2   Banging bits of metal together guy           25   7         175
            
You're seeing this            
1      115   7   220
2      115   12   385
            
You want to see this            
            
1      60   7   220
2      60   12   385
            
            
or you're seeing this:            
            
project      job class                                 rate   hour   cost
1   Engineer                                              60              1           60
1   Electrical stuff guy                                60     2          120
1   Banging bits of metal together guy      100   4          400
2   Engineer                                              120   2          240
2   Electrical stuff guy                               90   3         270
2   Banging bits of metal together guy       175   7         1225

QuoteI am using directoryuserID in join queries.

Without knowing your model, the underlying data bases, and the data itself it would be difficult to pass judgement on that either way.


Why are you doing this?  Why isn't your modeller doing this?





Sorry about the ragged tables.  I still can't figure out how to get them to work.

I have a project which has the following example cost rate for job categories:

Electrical Engineer	130
Electrical Aide	60
PM	160

Instead of showing the cost rate/hr for Electrical Engineer as 130, the report adds all cost rate (130+60+160), 250.