Skip to Content
0

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

Dec 18, 2017 at 08:58 AM

41

avatar image

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

10 |10000 characters needed characters left characters exceeded

Please clarify what you are asking for.

0

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

0

So how are the start date and end date defined?

0

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

0

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?

0

database: sql server 2012

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Joe Peters Dec 18, 2017 at 03:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded