dbTalk Databases Forums  

Custom Rollup Formula question

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


Discuss Custom Rollup Formula question in the microsoft.public.sqlserver.olap forum.



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

Default Custom Rollup Formula question - 01-09-2004 , 09:09 AM






I'm trying to get a very basic custom rollup formula working for a
parent-child dimension.

One dimension, drug, one measure sales, simple p-c dim. With no custom
rollup formula, works as expected. I put in the following, and get empty
values (not ERR though) Any ideas?

SUM([Drug].CurrentMember.Children, Sales)

I do not want to use RollupChildren because eventually I want to specify
individual rollup % using a weight stored in a member property...

TIA!

Derrick



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

Default Re: Custom Rollup Formula question - 01-09-2004 , 05:19 PM






You must exlude leaf members from this formula using an IIF statement and
the CalculationPassValue function in the elst clause to refer to the raw
fact data...

Thierry

--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Derrick" <derrick1298 (AT) excite (DOT) com> wrote

Quote:
I'm trying to get a very basic custom rollup formula working for a
parent-child dimension.

One dimension, drug, one measure sales, simple p-c dim. With no custom
rollup formula, works as expected. I put in the following, and get empty
values (not ERR though) Any ideas?

SUM([Drug].CurrentMember.Children, Sales)

I do not want to use RollupChildren because eventually I want to specify
individual rollup % using a weight stored in a member property...

TIA!

Derrick





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.