US and Worldwide: +1 (866) 660-7555
Results 1 to 5 of 5

Thread: Calculated Member on non Measure dimension

  1. #1

    Default Calculated Member on non Measure dimension

    Hi,

    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

    Thanks!

  2. #2
    Join Date
    May 2014
    Posts
    5

    Default

    Sure, this works.

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

    <CalculatedMember name="prevMonth" caption="Last month" dimension="Time">
    <formula>
    [Time].CurrentMember.PrevMember
    </formula>
    </CalculatedMember>


    see http://mondrian.pentaho.com/document...ulated_members

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

  3. #3

    Default

    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
    Time
    2013 2014
    Actual 100 200
    Prev Period 50 100

    Thanks!

  4. #4
    Join Date
    Jan 2013
    Posts
    476

    Default

    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

    Default

    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
  •