[Mondrian] Dinamic Sum

[miguel]

El mar, 05-08-2008 a las 01:08 -0700, Julian Hyde escribió:
> > miguel wrote:
> >
> > My question is whether we can create a Mondrian a dynamic element that
> > would give the sum of its parts are visible.
> 
> Take a look at the VisualTotals MDX function. I think it does what you need.
> 
> Julian
> 
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian


Thank you for responding but I have further questions and perhaps very
silly but still failed to get the result.

The first solution that tries to be after reading the forum was modified
to add the dimension property "VisualTotals" leaving it well:

 <Dimension name="Products">
  <Hierarchy hasAll="true" allMemberName='All Products'
VisualTotals="true" primaryKey="id_product">
   <Table name="products"/>
   <Level name="Prod" column="product_name" ordinalColumn="product_name"
type="String" hideMemberIf="IfBlankName" uniqueMembers="true"/>
  </Hierarchy>
 </Dimension>

And although not generate any mistake, I could not observe any change in
the cube.
The second solution was to try to do so by MDX and done that:

with set [Test GrandTotal] as '
VisualTotals
 (
    Distinct
    (
       Hierarchize
       (
          { Ascendants ([Products].[All Products]),
Descendants([Products].[All Products]) }
       )
    )
 )
'

SELECT {[Products].Members} ON Columns,
{ [Vendors] } ON ROWS
FROM [Sales]

But not see any change.
What I want is to put this element within the "Products" for the "All
Products" show what is being viewed on screen.
It may sound stupid and that Mondrian should be able to do that but
could advise me on how or at least guide a little?



-- 
Miguel Ángel Villagómez Díaz
Sayab Technologies S.C.
Tel. 3616-9100