Re: Unable to use original aggragation with Custom Rollup Formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ohjoo Kwon (ojkwon_at_olap.co.kr)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 21:16:59 +0900

I do not understand this part.

---------------
When I have some data for quarterly value for other dimension, I found that
the values are missing
because they do not use SUM ({[Time].CurrentMember.children}) formula as its
aggregation. They suppose to use value in the fact table instead.
---------------

Maybe... for other measures? You mean other measures use other aggregation
function such as count?
If then, use Aggregate() insted of SUM().

If I do not understand your question right, do not blame me. ^^

Ohjoo Kwon
www.olapforum.com

"Joel Leong" <ch_leong@hotmail.com> wrote in message
news:285c01c51332$fd3504d0$a401280a@phx.gbl...
> I have a time dimension which consists of year, quarter
> and month members.
>
> The Quarter member takes 3rd month of each quarter as the
> Cost measure value. For other value it will sum up 1st,
> 2nd and 3rd month.
>
> This works well for monthly value but not quarterly
> value. When I have some data for quarterly value for
> other dimension, I found that the values are missing
> because they do not use SUM
> ({[Time].CurrentMember.children}) formula as its
> aggregation. They suppose to use value in the fact table
> instead.
>
> This is my MDX for Custom Rollup Formula for quarter
> member in Time Dimension.
>
> IIF([Measures].CurrentMember IS [Measures].[Cost],
> [Time].CurrentMember.LastChild, SUM
> ({[Time].CurrentMember.children}))
>
>
> My question is how to write a MDX so that it will only
> use custom rollup formula when only this condition
> ([Measures].CurrentMember IS [Measures].[Cost]) is meet
> and use default rollup if the condition is not meet?
>
> Any workaround?

Relevant Pages

  • Re: Average Calculate Member
    ... Once we know sum and count, ... If the grain of fact table and cube, you can count any fact with aggregation ... you add Calculated Member whose definition is somthing like SUM/Count ... > How I can get the same effect of an aggregation Sum on any dimension ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS2005: 0 aggregation designed for 1million rows cube?
    ... By default it is Sum, but you can have others (Min, Max, DistinctCount, ... I have another dimension where the Isaggregate option is set to false (so ... The result of this combination of options result in 0 aggregation designed ... my big partitions. ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS2005: 0 aggregation designed for 1million rows cube?
    ... By default it is Sum, but you can have others (Min, Max, DistinctCount, ... I have another dimension where the Isaggregate option is set to false (so ... The result of this combination of options result in 0 aggregation designed ... my big partitions. ...
    (microsoft.public.sqlserver.olap)
  • Re: Average Calculate Member
    ... I need to have the average of the budget sales with any dimension of ... As when I define a measure with aggregation "Sum". ... How I can get the same effect of an aggregation Sum on any dimension ...
    (microsoft.public.sqlserver.olap)
  • Re: Vectors summing to zero
    ... These vectors are typically unit vectors of the dimensional space or the ... If the dimension is large then the chance of hitting a coplanar triple ... the sum itself seems so simple that I don't see much ... The sum of the angles will always be 2 pi and so by computing these ...
    (sci.math)