Skip to Content

Hi I want to generate the report based on start date and end date to fetch the required Data.T

Hi

I want to generate the report based on start date and end date to fetch the required Data.To achieve requirements from semantic layer should not use any @prompts, query level filter, and report-level filter by using SQL functions how will achieve the result

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 18, 2017 at 03:40 PM

    To create a predefined filter that can be dropped into a report to restrict the dates:

    Create the filter with the following WHERE text:

    table.column BETWEEN '20171201' AND '20171220'


    To make the filter apply to all queries that are run using universe:

    Create the filter as above, then check off "Use filter as mandatory in query" and "Apply on Universe"


    To make the filter apply when a specific object is used in the query:

    Set the object's WHERE text to the same condition above

    Add comment
    10|10000 characters needed characters exceeded