PDA

View Full Version : get a set dynamically totaling child members?



brad0929
11-28-2003, 05:24 PM
How to return a set generated by dynamically totaling child members in a specified set using JPivot?
For example, assume that the Product dimension has the member Baked Goods with a child of Bread. Bread has the child members Bagels, Muffins, and Sliced Bread.
Unit Sales
Bread 7,870.00
Bagels 815.00
Muffins 3,497.00
The results for the parent member reflect the precalculated values of all of its children and do not take into account that other child members have not been included in the resulting set.
Is there an alternate solution to use a function to dynamically total the child members in the set and display an accurate value for Bread? see below
Unit Sales
Subtotal-Bread 4,312.00
Bagels 815.00
Muffins 3,497.00
thanks

jhyde
11-28-2003, 07:26 PM
Sounds like you're thinking of the 'VisualTotals' MDX function?

brad0929
11-28-2003, 09:09 PM
i just want to get a set dynamically totaling after users changed current memebers in jpivot. but i do not know to implement it?
thanks

jhyde
11-29-2003, 09:37 AM
MDX provides the VisualTotals function for this purpose (search MSDN for documentation).
However, this function isn't implemented in Mondrian, and it's not on the plan. I can't think of any workaround. Sorry!
If we ever implemented it, JPivot could have a button to switch between visual totals & real totals.