about function the corresponding period rate?

  • 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?
    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:

        member [Measures].[diff] as

      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?


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks