dbTalk Databases Forums  

excluding non-leaf members from writeback allocation

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


Discuss excluding non-leaf members from writeback allocation in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default excluding non-leaf members from writeback allocation - 05-04-2006 , 03:46 AM






Hi everyone,
I have the following need: in a father-child dimension, I need to
writeback a value to the father and let it be allocated to his
children. The problem is that if I put a value of, let's say, 5000 to
the father and this has 4 children, each child gets 1000 and the father
too gets 1000, because it is at the same time included in the hierarchy
as a father and as a member.

Now, while AS2000 got the options to associate data only to leaf
members "leaf-member only", AS2005 shows only two options: "Non-leaf
member data visible" and "Non leaf member data hidden", while
"Leaf-members only" is no longer available.

My question is: is it possible in a father-son hierarchy to exclude the
father to get a slice of data that are written back to it? If so, I can
I get this result?

Thanks in advance,

rq


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.