Skip to Content
avatar image
Srikanth Godavarthi

Custom measure for 6 months on YTD model?

May 11, 2017 at 07:41 AM | 157 Views

time.pngcustomqtd.pngcustomqtd.txtHi,

We have cutsomperiodic and customQTD on YTD model.

but we need 6 months(TTD- termtodate) custom measure. Can any one help me how to create a custom measure for 6 months.

I have attached customQTD measure and TIME dimension for reference.

Regards,

Srikant

time.png (39.5 kB)
customqtd.png (33.4 kB)
customqtd.txt (1.2 kB)
SAP Business Planning and Consolidation, version for SAP NetWeaver
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Vadim Kalinin
    May 11, 2017 at 08:50 PM

    Sorry, but I am unable to see what do you mean by TTD measure. No sample, no algorithm.

    And why you are providing links to the pictures instead of inserting pictures directly? Hard to read.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      May 12, 2017 at 04:13 AM

      Hi Vadim,

      Thanks or your reply.

      currently we are using customqtd measure which is aggregated value for 3 months in a YTD model.

      Similarly user want to see the aggregated value or 6 months (Term -to-date).please see the sample below.

      the CustomQTD measure giving correct results with the below formula.

      This is our time dimension.

      please let me know i you require any other details.

      Regards,

      Srikant

      ttd.png (7.4 kB)
      33885-customqtd.png (33.4 kB)
      33884-time.png (39.5 kB)
  • avatar image
    Vadim Kalinin
    May 14, 2017 at 08:13 AM

    Looks like your time dimension is configured incorrectly - you use P0x instead of month names and half year members has empty property - has to be WEEK.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vadim Kalinin
    May 15, 2017 at 08:35 AM

    On the screenshot I don't see 2016.INP member with PARENTH1

    Also - correct PERIOD property!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vadim Kalinin
    May 15, 2017 at 09:55 AM

    "I know our BW/BPC is too old and we already requested for up gradation. For the time being is that possible to create custom formula for 6 months using formula customqtd."

    First - upgrade!

    Then ensure that standard QTD is working correctly

    Then - new measure TTD

    Other options - just a waste of time!

    Add comment
    10|10000 characters needed characters exceeded