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.
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.
On the screenshot I don't see 2016.INP member with PARENTH1
Also - correct PERIOD property!
"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