OpenDoc with Crosstabs

building reports webintelligence
1

I need to create an OpenDoc variable that works on a crosstab on a column by column basis, rather than selecting everything.

Obviously if you click a measure column on a crosstab then all associated columns are highlighted for the measure. How can I create a URL that selects the measure according to the dimension on the column headers?

EG (AS ATTACHED) -

If I create an OpenDoc for Count(A) if will take me to the detail report for ALL the YYYYMMs along the top. I need the OpenDoc code to specify any given YYYYMM so when clicked it will take me to that exact YYYYMM for the given row in the detail report.

thanks
OpenDoc BOB.xls (31.0 KB)

frank35 :uk: (BOB member since 2005-08-25)

2

you would put the opendoc url on the dimension for yyyymm not the measure

erik.stenson :us: (BOB member since 2012-07-30)