Rowno() / Synthetic dimensions and set anaylises

[Anonymous]

Hi,

I created a synthetic dimension (1 to 10). Based on a startdate I would like to have rolling period.

So startdate + 1,startdate + 2.

From what I know you cannot use a synthetic dimension in a set analysis. So I tried to use Rowno() instead.

This expression workfine whitout re-calculating it $(= ..)

$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))

(Count({1<PARTY_ID=Cohort_1::PARTY_ID,

YEARMONTH={'$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))' } >}PARTY_ID)

Thanks,

Ben

[#2]

Hi Ben, Why you are using Synthetic Dimension here ? What is your actual requirement ?

Your dimension id tied the STARTDATE , so you can create the new field on the data model  and use the new field in your chart.

Can you please post sample qvw here ?