Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: using the "With member"

  1. #1
    Join Date
    Mar 2006
    Posts
    114

    Question using the "With member"

    Hi,
    I´m having a problem when I try to subtract my "Share Mes" measure. This measure was created using the "With member". I would like to know if is possible that I do the comparison between April 2007 and March 2007 ("April 2007"."Share Mes" - "March 2007"."Share Mes")


    -------------------------------------------------------------------------------------------------------------------
    with set [InterestingProduct] as '{[Produto.Product].[Todos].Children}'
    set [TotalPeriods] as 'LastPeriods(13.0, [Periodo.Time].[Todos].[2008].[Q1].[March 2008])'
    set [MatPeriods] as 'LastPeriods(12.0, [Periodo.Time].[Todos].[2008].[Q1].[March 2008])'
    member [Measures].[Share Mes] as 'Format(IIf(([Produto.Product].CurrentMember.Parent = 0.0), NULL, ([Measures].[Real] / ([Measures].[Real], [Produto.Product].CurrentMember.Parent))), "0.00%")'
    member [Produto.Product].[Total of Real] as 'Sum([InterestingProduct])'
    member [Measures].[Evolution] as '(Format(((([Produto.Product].CurrentMember / [Periodo.Time].[Mes].CurrentMember.PrevMember) - 1.0) * 100.0), "0.00") || "%")'
    member [Periodo.Time].[Total] as 'Aggregate([TotalPeriods])'
    member [Periodo.Time].[MAT] as 'Aggregate([MatPeriods])'
    select NON EMPTY Crossjoin({LastPeriods(13.0, [Periodo.Time].[Todos].[2008].[Q1].[March 2008])}, {[Measures].[Real], [Measures].[Share Mes], [Measures].[Evolution]}) ON COLUMNS,
    NON EMPTY Order({[Produto.Product].[Todos].Children, [Produto.Product].[Total of Real]}, ([Periodo.Time].[Todos].[2008].[Q1].[March 2008], [Measures].[Real]), DESC) ON ROWS
    from [SALES_MANUFACTURER_BY_TIME]
    -------------------------------------------------------------------------------------------------------------------

    Tks, Concon
    Last edited by leandroconcon; 12-03-2008 at 09:36 AM.

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.