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: