Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

about function the corresponding period rate?

Help
maixq
2004-09-21
2013-04-29
  • maixq
    maixq
    2004-09-21

    I want to analyzed the relation of different period.Is JPivot has a function to implement the corresponding period rate?
    e.g.
    a measures,i want to compare the change of Current month,Last month,The same month last year

    how can i do it?

     
    • Andrew
      Andrew
      2004-09-23

      I'm looking to solve the same problem. Maybe this could be helpful for you:

      With
        member [Measures].[diff] as
         '[Measures].[quantity]-([Measures].[quantity],[Time].[Year].CurrentMember.PrevMember)'

      select {[Time].[Year].Members,[Measures].[diff]} ON columns,
        {[Measures].[quantity]} ON rows
      from [schemaname]

      but i need something different. In particular i would compare two years, the current and the previous one, but considering only the month of the previous that have a value in the current. i mean, considering the cumulative quantity since the start of the year (ie: from january to september) i would compare it with the same period of the last year.

       
    • maixq
      maixq
      2004-09-27

      Thank you Andreas,it's a feasible resolve,
      but in this way will be make lots of additional measures.
      I have once used Cognos to finished the same task,it is provide a general model to dispose it,it is very nice.
      does JPivot have a similar function unit?