Date Range Parameter Drill OLAP->DMR

[rob.hollenbeck]

I'm working on a C8 OLAP->DMR drill and my date range isn't coming through as expected but can't justify the alternate value to determine where/how to resolve

I've developed another Cube->DB Drill project and I proved handled the YYYYMMDD-YYYYYMMDD date filter either at the Framework Query Subject or in Report Studio however I'm building another and not getting the same result from the cube parameter feed

I've verified that everything within Transformer is as identical as I can tell and when I look at the fields within Dimension Viewer that the Category Code is as expected and should push through cleanly

We are in 8.3 and upgrades are out of the question but I have the working project in the same version but I'm trying to figure out where/how/why my Drill Use Value is different than the Category Code and how to resolve

Thanks in advance

--Framework Query Subject
WHERE DATEFIELD BETWEEN TO_DATE (SUBSTR (#prompt('Date Range','String')#, 1, 8), 'YYYYMMDD')
   AND TO_DATE (SUBSTR (#prompt('Date Range','String')#, 10, 8), 'YYYYMMDD')

--Report Studio Detail Filter
[DATEFIELD] between to_date(substr(?RANGE?,1,8),'YYYYMMDD')
   and to_date(substr(?RANGE?,10,8),'YYYYMMDD')
   
Model-based Drill-through access:   
Display Value   Use Value
2009 Q 4      [Test_Cube].[All Periods].[All Periods].[Quarter]->:[PC].[@MEMBER].[20091001-20091231]

Parameter Mapping
Parameter Name   Display Value   Use Value
RANGE       2009 Q 4      2009-10-01    

Category Label:    2009 Q 4
Category Code:   20090701-20090930
Source Value:   

Code Select Expand

20091001