Re: Seperate MDX Aggregation formulas for non-leaf members of a dimension

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

Hi Graeme,

To answer the 2 points that you raised:

1) Unary operators are supported in AS 2000, but since weights can't be
assigned to them, they may not serve your scenario well. However, Mosha
also suggested (in the same blog entry) an approach for AS 2000, using
calculated cells, which would work (assuming you have AS 2000 Enterprise
Edition). This entails a "Weight" member property, stored in a dimension
table column.

2) Maybe there's some confusion about what the GUI is showing (which is
dimension developer info) - end-users would not see these weights, and
the weights would only apply when leaf values roll up to parent members.
The leaf values themselves should appear unmodified to end-users.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: MLE
    ... ranges maximise the expression: typically you will find the maximum ... the quotient of the sum of all weights of all samples that fall in the ... leaf, divided by the volume of the leaf. ...
    (sci.stat.math)
  • dynamic programming on a tree
    ... I have a binary tree. ... So there is a unique path from root to each ... Each leaf L also has a number associated with it, ... I have to assign weights w_i to all nodes ...
    (comp.theory)
  • Re: dynamic programming on a tree
    ... > Each leaf L also has a number associated with it, ... > including leafs such that product of weights from root to a leaf j equals ... Start with 0 OOI weights at the root. ...
    (comp.theory)