Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Formulas for Grand Totals in Saiku

  1. #1
    Join Date
    Oct 2012
    Posts
    1

    Default Formulas for Grand Totals in Saiku

    Hello,

    I am creating a Mondrian Cube and using it in a Saiku Analytics Report.

    I use the option in Saiku to add a Grand Totals row. This works fine for all the columns which are summable. However, there are columns for which I want to tell the system not to apply the sum but in the case of a sum row, apply the row-wise formula.

    For example the below table shows a Ratio% column which is ColumnA / ColumnB as a percentage. When I apply the Grand Total row using the Sum aggregation, I get the sum of the percentages as shown in red below.

    Session ColumnA ColumnB Ratio%
    A 56 57 98,25%
    B 40 45 88,89%
    C 32 42 76,19%
    Total 128 144 263,32%

    How can I tell the schema or Saiku that in case of a Totals row being added, that column should not be summed up but it should rather apply the formula applied to the calculated member?

    Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    This looks like the same thing as:
    http://forums.pentaho.com/showthread...asure-accuracy

    In that thread, the user was advised to go to the Saiku forums/support pages.

  3. #3

    Default

    Quote Originally Posted by gutlez View Post
    This looks like the same thing as:
    http://forums.pentaho.com/showthread...asure-accuracy

    In that thread, the user was advised to go to the Saiku forums/support pages.
    not the same issue

    Drew: I guess you can't do this

  4. #4
    Join Date
    Dec 2016
    Posts
    1

    Default

    Quote Originally Posted by Drew View Post
    Hello,

    I am creating a Mondrian Cube and using it in a Saiku Analytics Report.

    I use the option in Saiku to add a Grand Totals row. This works fine for all the columns which are summable. However, there are columns for which I want to tell the system not to apply the sum but in the case of a sum row, apply the row-wise formula.

    For example the below table shows a Ratio% column which is ColumnA / ColumnB as a percentage. When I apply the Grand Total row using the Sum aggregation, I get the sum of the percentages as shown in red below.

    Session ColumnA ColumnB Ratio%
    A 56 57 98,25%
    B 40 45 88,89%
    C 32 42 76,19%
    Total 128 144 263,32%

    How can I tell the schema or Saiku that in case of a Totals row being added, that column should not be summed up but it should rather apply the formula applied to the calculated member?

    Thanks in advance.

    Hello Drew,
    I have same problem,Have you solved your problem and share with me?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.