CODEWITHSUNDEEP
business-intelligencebusiness-objects
RonaldB
RonaldB

Reputation: 1200

Business Objects - query with parameter based on a variable

I'm writing a report in Business Objects, and need to select data dating 10 weeks from the current reporting date to the current reporting date.

I have a query element telling me the current reporting date, and I have created a variable holding the date 10 weeks ago.

=RelativeDate([Current Date];-10;WeekPeriod)

I'm now editing the data provider, and add a query filter for the date range. However, I'm not able to select the variable as an object available in the query.

I feel that I'm missing something basic. How can I select my dates based on a database object date and a predefined range of dates?

Upvotes: 1

Views: 9642

Answers (1)

Arnaud Develay
Arnaud Develay

Reputation: 3970

Document variables cannot be used in the Query Panel. After your query is executed and a report has been generated, you can then filter it by using this variable.

Upvotes: 2

Related Questions