I have built a transformation table with YYYYMM_ID and YTM_ID in a way
YYYYMM_ID YTM_ID
200401 200401
200402 200401
200402 200402
200403 200401
200403 200402
200403 200403
200404 200401
..
200404 200404
Report has Current Month column and a metric using YTM transformation object. Current month is also a report prompt. Running report and selecting months in a prompt Jan, Feb, March, April 2004, the transformation metric works OK, as data for all months from 2004 is in the report. It sums up numbers from beginning of 2004 to each of the months.
When I select March and April 2004 in the prompt only, transformation metric only sums up data for the first month selected in the report, which is March 2004, rather then January 2004.
When I select April 2004, the metric only sums up data for April 2004 only and not Jan - April 2004.
Any idea what I may be doing wrong ?
YYYYMM_ID YTM_ID
200401 200401
200402 200401
200402 200402
200403 200401
200403 200402
200403 200403
200404 200401
..
200404 200404
Report has Current Month column and a metric using YTM transformation object. Current month is also a report prompt. Running report and selecting months in a prompt Jan, Feb, March, April 2004, the transformation metric works OK, as data for all months from 2004 is in the report. It sums up numbers from beginning of 2004 to each of the months.
When I select March and April 2004 in the prompt only, transformation metric only sums up data for the first month selected in the report, which is March 2004, rather then January 2004.
When I select April 2004, the metric only sums up data for April 2004 only and not Jan - April 2004.
Any idea what I may be doing wrong ?