dbTalk Databases Forums  

LinkMember Error on result:

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss LinkMember Error on result: in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pezzulli@diesseci.it
 
Posts: n/a

Default 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?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.