Hi,

Key issue: It looks like PTS assumes that if there is no data at higher
level, there will be no data at lower level, but this is not a case for
"Last Child" aggregation.

Explanation:

I have date dimension with levels:
Year
Quarter
Month
This is hierarchy, actual Year, Quarter, Month attributes are not visible.


I also have measure group with measure Contracts that has aggregation "Last
child".

Date dimension has values: 2004-12 : 2005-09
In fact table I have following values:
2004-12:NULL (NULL = No fact record)
2005-01:NULL
...
2005-06: NULL
2005-07: 1
2005-08: 1
2005-09:NULL

Point here is that last value in year in NULL or No record. Now, when I drag
Contracts measure into measure area and Date dimension into row area, I have
no data returned. This is because at the end year my contracts value = NULL.
This makes sense. What does not make sense, that at row I cannot expand year
2005 value to see data at quarter/month level. Year 2005 is not shown, as at
the end of the year there is no data. But there is data in month below year!
As front end I am using Microsoft 2003 Office PTS component and PTS that
comes with SSAS. Both have same behaviour.
It looks like PTS assumes that if there is no data at higher level, there
will be no data at lower level, but this is not a case for "Last Child"
aggregation.
Anyone knows fix for this?

I am using SSAS 2005 64bit, no SP1.

Thanks

Hello Vimas,

This seems to be current behavior of PTS. Please rest assured this has been
routed to the proper channel. In the meantime, I also encourage you submit
this feedback via the link below

http://lab.msdn.microsoft.com/produc...k/default.aspx

You may want to check if Custom Rollup Formula:
[Date].CurrentMember.LastChild of the Date dimension could work around
this issue.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.