Skip to Content

Custom measure for 6 months on YTD model?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • 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

      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)
      33884-time.png (39.5 kB)
  • 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

  • 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

  • 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