Re: GroupFooter and SummaryExpr in DCube 3

GroupFooter and SummaryExpr in DCube 3

04-16-2009, 5:27 AM
Hi All,

We start to use DCube 3 instead of 2.5. We have used calculated field in v.2.5 and used aggregate functions.They have to be applied through the SummaryExpr. In the v. 3 we try to use the GroupSum and GroupAvg in the GroupFooterExpression, but the result very different, because the groupfooter add 3 more colums to the spread and the right sum apear only the groupfooter, but we need this in the calculated colums.(Let see the attachment.) In the sample provided we want only 3 column: Data1, Data2 and GroupFooter' s last column. (Let see the picture in the attachment ) Could you please help us how to achieve this.

Thank you,
Zotya K.

Re: GroupFooter and SummaryExpr in DCube 3

04-16-2009, 6:29 AM

Zotya,

Please note that there are some differences between DynamiCube 2 and DynamiCube 3 syntax / features, especially:

GroupFooterType / Expression defined differently in 3.0

Calculated fields in 3.0 defined differently in 3.0

You can find the list of changes here:
http://www.datadynamics.com/forums/59193/ShowPost.aspx

The GroupFooterType functionality in DynamiCube 3 has been changed and improved from DynamiCube 2.5.
When a GroupFooterType("x") = DCFCalculated you can supply your own formula using GroupFooterExpression("x"). If you do not specify a GroupFooterType for an intersection, DynamiCube will use the default setting depending on the AggregateFunc of the associated DataField.

See also:
http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~Field~GroupFooterExpression.html
http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~Field~GroupFooterType.html
HOWTO: Create a calculated group footer for a field:
http://www.datadynamics.com/forums/87243/ShowPost.aspx
INFO: GroupFooterType Property in DynamiCube 3:
http://www.datadynamics.com/forums/64794/ShowPost.aspx
INFO: Calculated Fields in DynamiCube 3.0:
http://www.datadynamics.com/forums/63838/ShowPost.aspx

I've modified your sample to achieve desired result. Please see the attachment.

Thank you,
Andrey T.