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

[siva_ram20]

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

[Joe_Peters]

Please clarify what you are asking for.

[siva_ram20]

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

[Joe_Peters]

So how are the start date and end date defined?

[siva_ram20]

example: whenever the user select date its must generate the 1 DEC 2017 AS Start date and 20 Dec 2017 as Endate should change as the requirement on the selection aslo

[Joe_Peters]

What you do mean by "whenever the user select date"? Do you mean any query run in the universe should have this condition applied? Or whenever a specific "date" object is selected for use in the report?

And which database are you using?

[siva_ram20]

database: sql server 2012

[Joe_Peters · Accepted solution]

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