dbTalk Databases Forums  

MDX Query Custom Rollups

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


Discuss MDX Query Custom Rollups in the microsoft.public.sqlserver.olap forum.



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

Default MDX Query Custom Rollups - 07-25-2004 , 08:24 PM






Ppl of the world,

Am a MDX newbie, and having some problems understanding how to apply
rollups.
I Hv a Product Dimension and would like to create custom Rollups to
the measures excluding certain products.

Would appreciate any help regarding this.

Cheers,
Jaspal

Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: MDX Query Custom Rollups - 07-29-2004 , 11:53 PM






Depending on whether the custom rollup formula is the same for all products
or not - you can either use custom members defined only on the products that
you care about or use custom rollup formula which excludes the products that
you don't care about.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Jaspal" <jmuker (AT) hotmail (DOT) com> wrote

Quote:
Ppl of the world,

Am a MDX newbie, and having some problems understanding how to apply
rollups.
I Hv a Product Dimension and would like to create custom Rollups to
the measures excluding certain products.

Would appreciate any help regarding this.

Cheers,
Jaspal



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.