dbTalk Databases Forums  

How to prevent rollup of values in parent-child dimension

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


Discuss How to prevent rollup of values in parent-child dimension in the microsoft.public.sqlserver.olap forum.



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

Default How to prevent rollup of values in parent-child dimension - 08-05-2003 , 02:38 PM






I have a parent-child dimension, but I do not want the
cube's values rolled up. I only have one member
named 'qty'. I just want the 'qty' values associated
with each level to remain the original value because my
original values are already rolled up. What is the best
way to achieve this?

Reply With Quote
  #2  
Old   
Kathy Davis
 
Posts: n/a

Default How to prevent rollup of values in parent-child dimension - 08-06-2003 , 11:02 AM






Thank you Brian. I read the article. Unfortunately this
is new to me and I don't have knowledge of MDX and how
the calculationpassvalue will work.

After I posted my question yesterday, I came up with a
solution. Tell me if you think it is OK, or if I need to
try the calculationpassvalue. In my dimension I set the
Unary Operator to true. I gave each dimension member a
unary operator of "~" which means don't include it in the
rollup. It seems to give me the result I'm looking for.

What do you think?

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.