Hi all,
There are lots of limitations of reportnet 1.1 MR2 with SAP BW datasources, for example you CANNOT use filtering statements on a BW datasource on business date/time functions: current_date, _first_of_month, _last_of_month etc...
still I need to filter my BW queries as following: 0CALDAY between 2005-05-01 and 2005-05-31.
I had the idea to create a calculation under framework manager that generate dynamically first_of_month and last_of_month from an oracle table.
When I test the results of these calcultions under report studio , the result is ok, but now if I want to include these calculation items in the filters of my datasource query...it does not work.
So first, can we use calculation results in a query filter? if so how?
if not, has anyone any clue how to pass this 'date/time' filter to a BW datasource from reportstudio.
thanks
David
There are lots of limitations of reportnet 1.1 MR2 with SAP BW datasources, for example you CANNOT use filtering statements on a BW datasource on business date/time functions: current_date, _first_of_month, _last_of_month etc...
still I need to filter my BW queries as following: 0CALDAY between 2005-05-01 and 2005-05-31.
I had the idea to create a calculation under framework manager that generate dynamically first_of_month and last_of_month from an oracle table.
When I test the results of these calcultions under report studio , the result is ok, but now if I want to include these calculation items in the filters of my datasource query...it does not work.
So first, can we use calculation results in a query filter? if so how?
if not, has anyone any clue how to pass this 'date/time' filter to a BW datasource from reportstudio.
thanks
David