Time Dimension in AS2005 -
10-25-2006
, 10:32 PM
Dear all,
Actually, I have posted these questios before. It seems that no one reply.
Are the following questions problems in AS 2005? They cannot be solved now?
If not, please help me. It's really an urgent matter. Thanks!
1. Year to Date
This field value is "#value". The error message is "The following system
error occured: Type Mismatch..MDXScript (Cube Name) (12,5) There is a Type
mismatch for the '-' operator." I tried to search for the 12th row and the
5th columns, I found that it is the MDX expression for Net Sales:
"[Measures].[Sales]-[Measures].[Discount]". What happen to my expression?
2. Last Year
This field can capture correct last year figures at month level. However, it
is wrong at year level. For example, at year level, the current figure is the
sum from 2006 Jan to 2006 Oct(up to 2006-10-16). However, the last year
figure is the sum from 2005 Jan to 2005 Dec. These two figures are not
comparable! I think that the last year figure should be the sum from 2005 Jan
to Oct (up to 2005-10-16). How to solve this problem?
Thanks! |