LAST Function Query

[xplorerdev]

Hi,

I am running Cognos 10.2.1 on ISAPI module on SQL Server 2012 on a Winodws 2008 server

In Framework Manager I have the following:

Namespace1 with the following two Regular Dimensions:
Dim1 = MIS Time with 3 levels i.e. Year, Quarter and Month.
Dim2 = Months on Books with just one level i.e. Months on Books.

Now, Namespace2 has all the measures which are coming from my Aggragate table.

My Requirement:
Use LAST function to display the measure, $Revenue.

What I have done:
For the measure, $Revenue, in the FM, I have added an aggregate rule with following details:
Dimension = Dim1
Aggregation Rule = LAST

Result:
In Report Studio, when I display Revenue by Year/Quarter/Month, I get the desired result.
But when I display Revenue by Months on Books, I get an empty table. NO DATA.

How do I get to show the correct data by Months on Books along with Year/Quarter/Month?

Any advice/suggestion will be highly appreciated.


Thanks n Regards
Dev