Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Calculated Member on non Measure dimension

  1. #1

    Default Calculated Member on non Measure dimension


    Is it possible to generate a calculated member on a dimension different than Measures? I've used both the dimension and hierarchy attributes in schema workbench but when I publish the cube I don't see the member in saiku.

    What I want to do is a member that shows the previous month value of any measure: [Time].CurrentMember.PrevMember


  2. #2
    Join Date
    May 2014


    Sure, this works.

    You should have something like this in your schema (within the cube tag):

    <CalculatedMember name="prevMonth" caption="Last month" dimension="Time">


    Then in Saiku, it should be available on you time dimension.

  3. #3


    Hi alci,

    What you proposed doesn't work because the member should not belong to Time dimension as I need the cross with the CurrentMember of the dimension.

    The view could look like this, Actual and Prev Periods are members of a custom dimension:

    Measure Sales
    2013 2014
    Actual 100 200
    Prev Period 50 100


  4. #4
    Join Date
    Jan 2013


    You could define the member on any other dimension. This is where some people use a dimension whose sole purpose is to hold calculations.

  5. #5


    Hi mcampbell,
    I've done that but I don't see the member in Saiku. Maybe it's a Saiku issue.

    In JPivot I see the member only if I put it under All (default), if I change its parent, I can't see it either.

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 - 2017 Pentaho Corporation. All Rights Reserved.