Hi,
I am trying to convert the date prompt filter to slicer for performance tuning. Below function does not throw error and not filtering the data as per selected date in prompt. Date prompt is chosen not tree prompt. Also what is the DMR function to convert in to specific date format. Please shred some light on this.
filter(
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)],
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)].[Date (ship date)]
between ?Parameter1 and ?Parameter2?
)
Quote from: Cognos8 on 09 Sep 2015 04:07:01 AM
Hi,
I am trying to convert the date prompt filter to slicer for performance tuning. Below function does not throw error and not filtering the data as per selected date in prompt. Date prompt is chosen not tree prompt. Also what is the DMR function to convert in to specific date format. Please shred some light on this.
filter(
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)],
[gosldw_sales].[Time (ship date)].[Time (ship date)].[Day (ship date)].[Date (ship date)]
between ?Parameter1 and ?Parameter2?
)
Hi,
What does "not filtering data as per selected date in prompt" mean? Can you explain *exactly* what you see and what you are expecting to see (bearing in mind that slicer filters are for context, and impact measure values not the members shown in sets of members on row/column edges).
MF.