Re: custom Rollup formula syntax

#1

Custom Rollup Formula is applied to the current level and the results are
rollup to the parent level.

If the Custom Rollup Formula(CRF) is setup at the bottom level, no value
exists because the leaf members has no children.
I think CRF need to be defined at the upper levels.

Also the order of dimensions of the cube should be considered, if other
dimenson has some rollup logic, for example account dimension.

You can verify the finally applied logic at cube browser. Right click some
cell and select "Cell Evaluation List..." and you can see the applied lists.

Ohjoo

"Truc H." <TrucH (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm using AS2000 and doing some testing on Custom Rollup.
We have a fact table with 1 measure and 1 dimension (Geo) with
3 levels (country, province, city).
I wanted to alter the default aggregation(sum) to average, so I set up the
Custom Rollup Formula property of the dimension to :
avg([geo].currentmember.children)
Process and browse the cube, nothing is displayed !
Anything else need to be set up ?
Thanks.

#2

Did you consider Custom Member Formula?

"Truc H." <TrucH (AT) discussions (DOT) microsoft.com> wrote

Quote:

I think that you are right.
Now, how can I define a CRF at a higher level , let see geo.province ?
I can't seem to find the right syntax to do it in the dimension editor.
Any example would be very useful.

"Ohjoo Kwon" wrote:

Custom Rollup Formula is applied to the current level and the results are
rollup to the parent level.

If the Custom Rollup Formula(CRF) is setup at the bottom level, no value
exists because the leaf members has no children.
I think CRF need to be defined at the upper levels.

Also the order of dimensions of the cube should be considered, if other
dimenson has some rollup logic, for example account dimension.

You can verify the finally applied logic at cube browser. Right click
some
cell and select "Cell Evaluation List..." and you can see the applied
lists.

Ohjoo

"Truc H." <TrucH (AT) discussions (DOT) microsoft.com> wrote in message
news:79A62608-C1C3-4958-B080-008C592F3AA9 (AT) microsoft (DOT) com...
I'm using AS2000 and doing some testing on Custom Rollup.
We have a fact table with 1 measure and 1 dimension (Geo) with
3 levels (country, province, city).
I wanted to alter the default aggregation(sum) to average, so I set up
the
Custom Rollup Formula property of the dimension to :
avg([geo].currentmember.children)
Process and browse the cube, nothing is displayed !
Anything else need to be set up ?
Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: custom Rollup formula syntax

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

Re: custom Rollup formula syntax - 12-10-2006 , 10:43 PM

Re: custom Rollup formula syntax - 12-13-2006 , 05:52 PM