Drill ups/Drill downs

[kalyan_y]

Hi...
I have a measure by name Headcount and TIME Dimension where the levels are Year/Half Year/Quarter/Month. Drill ups/downs are available in the report. So, starting at the detailed level, headcount for each month is displayed and when drilled up to the next higher level, it should not get summed up for all the months in the quarter, rather value for last month of the quarter to be displayed.
How to implement this??? Any ideas??

[Naven]

Hi Kalyan,

In Framework Manager, select Headcount measure item, under properties pane click Aggregate rules and then select time dimension and assign aggregate rule as 'Last' and publish the model.

Hope this works.

Cheers!!!
Naveen

[kalyan_y]

Hi Naveen,
   Thanks for ur reply. But I couldn't find the aggregate function last. From which version of cognos, it is available?
   

[mrcool]

Hi,

Please check the attached screenshot

Regards,
Mrcool