LinkMember Error on result: -
04-07-2006
, 08:50 AM
Error on LinkMember result:
I have 2 organized dimensions :
[Mov].[ Year].[Month] and [EDZ].[ Year].[Month] where
Mov
stands for operation, movement and EDZ stands for Edition i.e. the
date
creation of the product.
I have to find the total amount of products that have been "moved"
in a given
period and how many of these have the date of creation=date of
movement.
I've tried to find it with LinkMember method:
QTA, [MOV].CurrentMember,LinkMemeber([MOV].CurrentMember,[EDZ])
The Result:
Quantity Quantity-EDZ [MOV]
[EDZ]
10 2 [MOV].[ 2006]
[EDZ].
[2006]
3 0 [MOV].[2006].[January]
[EDZ].
[2001].[ January]
On level Year it gives me the correct result, but, on next level,
month, it
seems to loose the year and gives me the same month, on different year.
I apologize for my funny English, can someone help me? |